select problem

slimjim

Can anyone tell me what is wrong with this:

    $sql = "SELECT user, user_ip FROM note WHERE user='$shid' and user_ip='$_SERVER['REMOTE_ADDR']' AND date-$time >= '900'";
    $result = mysql_query($sql) or die(mysql_error());
    $num = mysql_num_rows($result);

mtmosier

I'm fairly certain someone can. It'd probably be easier to do if you'd share a little more information though. Like what errors you're receiving, if any. Expected behavior vs actual behavior.

slimjim

Ok I changed it and still getting this error just opening the page up..

    $sql = "SELECT user_ip FROM note where user_ip='$IPADDRESS' and date-$time >= 900";
    $result = mysql_query($sql) or die(mysql_error());
    $num = mysql_num_rows($result);

Here is the error :
You have an error in your SQL syntax near '-1109273129 >= 900' at line 1

Something to do with the time

tekky

Debugging 101

    $sql = "SELECT user_ip FROM note where user_ip='$IPADDRESS' and date-$time >= 900";
    $result = mysql_query($sql) or die('Error! query=' .$sql. ' -- sql=' . mysql_error());
    $num = mysql_num_rows($result);

Now what does your error message say?

slimjim

Error! query=SELECT user_ip FROM note where user_ip='I CHANGED THIS' and date-1109274207 >= 900 -- sql=You have an error in your SQL syntax near '-1109274207 >= 900' at line 1

I changed the ip address so I didnt post it in here...
But that is the error I got

tekky

Ok... so there is your problem... you are trying to subtract that big long # from "date" not a #....

slimjim

$time = time(); /* get the current timestamp */

//Trying to make it so that it has to be more then 15 minutes sence a person last posted a note....

tekky

"date-"

this is the problem
you need to decide what DATE should be...
do you want it to be date() or $date or... what? $time isnt wrong....

slimjim

Ok so lets say i want to make it so that a person can not submit for 15 minutes.

How would I write the select statement....
And what would be best for deciding that time....

I am using timestamp for the colum date...

tekky

I dnot think you can use date as a column name....

I would do this...

$sql = "SELECT user_ip, `date` FROM note where user_ip='$IPADDRESS' and `date`-$time >= 900"; 
    $result = mysql_query($sql) or die('Error! query=' .$sql. ' -- sql=' . mysql_error()); 
    $num = mysql_num_rows($result);