# PHP form not submitting to database

**URL:** <https://forum.kirupa.com/t/php-form-not-submitting-to-database/264974>\
**Category:** Uncategorized\
**Created:** [July 2, 2008, 5:26pm UTC](https://forum.kirupa.com/t/php-form-not-submitting-to-database/264974 "2008-07-02T17:26:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Syous](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@Syous](https://forum.kirupa.com/u/Syous)\
**Post date:** [July 2, 2008, 5:26pm UTC](https://forum.kirupa.com/t/php-form-not-submitting-to-database/264974/1 "2008-07-02T17:26:09Z")

</div>

So I have a form built in flash that runs this script when submitted. The only problem is the data doesn’t go through. When I go to the script in my browser, ([asdfsd.com/script.php](http://asdfsd.com/script.php) for instance) I get this.

```auto
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, url, image) values ('', '', '', '', '')' at line 1

```

```php
<?php
  // create short variable names
  $title=$_POST['title'];
  $language=$_POST['language'];
  $desc=$_POST['desc'];
  $url=$_POST['url'];
  $image=$_POST['image'];

  
  $dbh=mysql_connect ("localhost", "user", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("dbname");

 $rs = @mysql_select_db( "dbname" )
                         or die ( mysql_error() ) ;
                         
               
   $sql ="insert into cms (title, language, desc, url, image) values ('$title', '$language', '$desc', '$url', '$image')";  
            
   mysql_query($sql) or die (mysql_error());
  
  

?>

```

I’m sort of a newbie to php so take it easy =p

---

<div class="post-metadata">

**Author:** ![Syous](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@Syous](https://forum.kirupa.com/u/Syous)\
**Post date:** [July 2, 2008, 5:39pm UTC](https://forum.kirupa.com/t/php-form-not-submitting-to-database/264974/2 "2008-07-02T17:39:03Z")

</div>

Solved: Language and Desc are reserved words, had to change em!