insert time

[conan318]

hi im trying to insert the username and time into the online table the trouble is nothing is getting inserted into the table no errors

have echoed both variables to check they contain the right information and they do.

$time=time();
echo $time;
echo $myusername;

$insert_user=mysql_query("INSERT INTO cvisinko_db.online (username,time,) VALUES ('$myusername','$time')") ;

 

then the plan is display a basic online list

haven't been able to test this as nothing is getting inserted into the online table

$data = mysql_query("SELECT count(*) from cvisinko_db.online WHERE `time` >= DATE_SUB(NOW(), INTERVAL 30 minute);") or die(mysql_error());

 

 

 

[Pikachu2000]

Is the time field a DATETIME data type or . . . ?

[conan318]

using type time.

[xyph]

Did you check mysql_error() ?

 

It will return any errors encountered with the last MySQL query.

[conan318]

Did you check mysql_error() ?

 

It will return any errors encountered with the last MySQL query.

no i havent not sure how do that. do i just echo mysql_error()?

[xyph]

Yes. You want to echo mysql_error() right after the query.

 

A smart way to do it would be (shouldn't be used in production, just for testing)

 

if( mysql_query($query) == FALSE ) echo mysql_error();

 

Next time, try before you ask

[conan318]

thats a neat little trick. but the result was the Query was empty which explains why nothing is being inserted into the database. but does  not explain why my query is empty

$time=time();
echo $time; // echo fine
echo $myusername; // fine

$insert_user=mysql_query("INSERT INTO cvisinko_db.online (username,time,) VALUES ('$myusername','$time')") ;
if( mysql_query($insert_user) == FALSE ) echo mysql_error();

[xyph]

$insert_user=mysql_query("INSERT INTO cvisinko_db.online (username,time,) VALUES ('$myusername','$time')") ;

if( mysql_query($insert_user)

 

 

You're querying a query :/

 

[conan318]

topic solved i had an extra , after time.

 

$insert_user=mysql_query("INSERT INTO cvisinko_db.online (username,time) VALUES ('$myusername','$time')") or die(mysql_error());