[SOLVED] Quick Question

[Lamez]

what does this mean?

 

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /mounted-storage/home48c/sub007/sc33591-LWQU/www/user/userinfo.php on line 47

 

I know it is saying I am missing a ; or a , but where?

here is line 47, any help?

$query = mysql_query("SELECT u.username FROM users u INNER JOIN active_users a ON a.username=u.username WHERE a.timestamp < (NOW() - INTERVAL 5 MINUTE) AND u.username=$req_user_info['username']")or die(mysql_error());

[pocobueno1388]

Change it to this

 

<?php

$query = mysql_query("SELECT u.username FROM users u INNER JOIN active_users a ON a.username=u.username WHERE a.timestamp < (NOW() - INTERVAL 5 MINUTE) AND u.username='{$req_user_info['username']}'")or die(mysql_error());

?>

[Lamez]

no that did not work at all.

 

dang!

[pocobueno1388]

Show more code that is around line 47. Your query should have been giving an error though, and what I changed it to should have fixed that.

[kenrbnsn]

Can you post a few lines before that line between

tags?

 

Ken

[Lamez]

omg, sorry for wasting your time

 

I forgot a ; in my echo above the line, sorry thanks though

 

now it shows if the user is on or off line!