[Resolved] Need help with query.

[areid]

I'm having problems with this query, I cant find anything wrong with it.

This is what it returns:

insert into tblrights (userID, rights, pan, orders, deposit, inventory, key, signature, cost, travel, reports, a) values ('00129411', 'non', 'yes', 'yes', '', '', '', '', '', '', '', 'a');

Here is my code:

if ($rights_drop == 'non') {
$query="insert into tblrights (userID, rights,";
$result=mysql_query("SELECT nav_name, ID FROM tblnav where type='home'");
if ($row = mysql_fetch_array($result)) {
do { 
$query .= " $row[1], "; 
} while($row = mysql_fetch_array($result)); 
$query .= " a) values ('$eID', '$rights_drop',";
}

$result=mysql_query("SELECT nav_name, ID FROM tblnav where type='home'");
if ($row = mysql_fetch_array($result)) {
do { 
$query .= " '" . $_POST[$row[1]] . "', "; 
} while($row = mysql_fetch_array($result)); 
$query .= " 'a');";
}
$results = mysql_query($query);
echo "$query";
}

[drew010]

after
$results = mysql_query($query);
echo "$query";
put
if (!$results) echo mysql_error();

[areid]

Ok

Thank you for your reply, this is what I got...

You have an error in your SQL syntax near 'key, signature, cost, travel, reports, a) values ('00129411', 'non', 'yes', 'yes' at line 1

It must have been a long day, becasue I cant find any errors. It might be the " ' " its putting at the front of "key", but in the query echo, its not there.

[areid]

Alright, I found it!

The word "key" is a PHP functions, and you can't use a php function as a name for the feild you're trying to insert into. I would think that sense it's in the query it wouldn't matter, but it did, so I just changed the name to keydb and it works fine now.

Thanks for your help