Whats wrong here?

[matrixweb]

$online = "INSERT INTO xtwf_online (uname, place) VALUES ('$user', 'Just logged in' )";  
mysql_query( $online );

it looks right to me but it doesnt work , no error but it doesnt insert the values

 

[dequadin]

How fussy is MySQL with it's semicolons?

Maybe this:

$online = "INSERT INTO xtwf_online (uname, place) VALUES ('$user', 'Just logged in' );";
mysql_query( $online );

 

[DearHeart]

Why '$user' (string)? and not just $user (variable)? Except if it is some advanced technique I'm not aware of

PS Posted: 19-08-2009, 12:05 AM - There's your problem!

 

[dequadin]

Why '$user' (string)? and not just $user (variable)? Except if it is some advanced technique I'm not aware of

PS Posted: 19-08-2009, 12:05 AM - There's your problem!

Oh I see what you're saying he should have something like

$online = "INSERT INTO xtwf_online (uname, place) VALUES ('" + $user +"', 'Just logged in' );";
mysql_query( $online );

Maybe someone can post the paramaterised version of this, me no speak PHP.

 

[James]

$online = "INSERT INTO xtwf_online (uname, place) VALUES ('".mysql_real_escape_string($user)."', 'Just logged in' )";

$r = mysql_query($online, [i]insert DB resource here[/i] );

 

[ColinR]

Why '$user' (string)? and not just $user (variable)? Except if it is some advanced technique I'm not aware of

php will replace the variable with it's contents as it's within ", not '

 

[DearHeart]

Ya, I'm dreaming... Just woke up with your post! This should do with "." instead of the "+" concatenation.

 

[James]

'Just logged in' );";

That ; needs to disappear too.

 

[dequadin]

That ; needs to disappear too.

Well it was a bit of a shot in the dark

This thread seems to have picked up, I wonder if matrixweb is still having this problem

 

[DearHeart]

Hehehe.... matrixweb, when you eventually wake up, look in the php_error.log or run the script through phpMyAdmin, should tell you what's wrong ;0)