[Resolved] Problem with update string....

[RickConner]

ok, for some reason, I'm unable to do a simple update on a MYSQL database. Here is the code....

$query = "UPDATE items SET name = '$name', description = '$description', photo = '$picname', catid = '$catid' WHERE id = '$id'";

if($result = mysql_query($query,$db)) {
    ..... DISPLAY REDIRECT HERE ...
} else { 
    echo "Error Updating Record!<br>$query"; 
}

when this is called, it's giving me an error. For the life of me, I can't figure this out? PLEASE help 🙂

[RickConner]

I forgot to mention above that, if the same query is run from PHPMyAdmin, it runs perfect...

[RickConner]

I updated the query command to this:

mysql_query($query,$db) or die(mysql_error()); 

Now it's telling me : Unknown column 'name' in 'field list'

there IS a column named "name" in the database though...???

I'm more confused now then before 🙂

[nemonoman]

MySQL is CasE SenSItive. Windows is less case sensitive than Unix or Linux. If you're moving between operating systems --like query works in Windows PHPmyAdmin, not in production Linux web server, check your capitalization.

[RickConner]

I'm aware of capitalization. I refuse to work with a windows box, so I always use lowercase, with a few exceptions...

[nemonoman]

you should then echo out the query as it is being sent to the database, and check against the results of 'DESCRIBE items'.

Somewhere 'name' is being used incorrectly.

[RickConner]

It's ok, I've had a brain fart... I had the wrong database selected 🙂 changed it to the right one, and it's workin' fine 🙂 that's what I get for working 16+ hours days... THanks for the help