whats wrong with this line?

[trevor]

hey, i've been playing around with this for hours:

PHP Code:

$query = "UPDATE 'users' SET 'age' = '$age' WHERE 'username' = '$username'"; 


thanks

[Nitro]

Ok, the problem is that you are using '', e.g. 'users', 'age', '$age'. You dont need to do this, however if you want to, you are supposed to use the back tick(`), found to the left of your '1' key.

PHP Code:

$query = "UPDATE `users` SET `age` = `$age` WHERE `username` = `$username`"; 


PHP Code:

$query = "UPDATE users SET age = $age WHERE username = $username"; 


Both of those will work. Personally, I dont use anything like in the second example, but it's your preference. Hope this helps,

[joe_bruin]

wtf are you talking about?

you're supposed to quote your strings, but not identifiers.

PHP Code:

$query = "UPDATE users SET age='$age' WHERE username='$username'"; 


[bdl]

Nitro - actually you're only half correct. You would need single quotes around a string you want to compare, e.g.

PHP Code:

$sql = "SELECT * FROM table WHERE name = '$username'";

// or
$sql = "SELECT * FROM table WHERE name = 'bdl'"; 


The `backtick` only works for selecting column names, not values. You must use single quotes.

[bdl]

Originally posted by joe_bruin
wtf are you talking about?

you're supposed to quote your strings, but not identifiers.

PHP Code:

$query = "UPDATE users SET age='$age' WHERE username='$username'"; 


Actually, it is a good idea to use backticks on your column names, in the case you should happen to use a MySQL reserved word. I refer you to the MySQL manual section on <reserved words>.

[sde]

i always wondered why phpmyadmin uses backticks so heavily ... i wonder why i can't name a field 'order' still though. i guess some reserved words aren't allowed at all. ( well i haven't tried in a long time .. maybe something changed )

[trevor]

so that was it eh....its working fine now, thanks everyone. when i couldn't figure it out i got phpmyadmin to generate the php code for me, and i guess i mistakened the ` ticks to be single quotes '.
good to know.

[idx]

Originally posted by sde
i always wondered why phpmyadmin uses backticks so heavily ... i wonder why i can't name a field 'order' still though. i guess some reserved words aren't allowed at all. ( well i haven't tried in a long time .. maybe something changed )

Yep, I get caught up trying to name a description field "desc" and it wont let me. Guess that would foul up the sorting.

-r

[Nitro]

Lol, yeah, i've done that before, also, I once tried to name a field "order", which obviously didnt work:-p