query doesn't yield correct result

[StanLytle]

What I'd like to do, is look into a table, to see if a person has had more than x number of rejections (ie: 10), in the past 10 days.  I'm not getting anymore mySQL errors, but this just outputs "You can upload pictures" over and over and over again. Any help appreciated.

 

$RejectCutOffTime = strtotime('-10 days');

$query = "SELECT UserID, COUNT(UserID) FROM Rejections WHERE (Date > '$RejectCutOffTime') GROUP BY UserID ORDER BY UserID";

$result = mysql_query($query) or die(mysql_error());

while(list($id, $ct) = mysql_fetch_row($result))

{

if (($SessionUserID == $id) AND ($ct > '10'))

{ print "You have too many rejections to upload pictures"; }

else

{ print "You can upload pictures"; }

}

 

[redarrow]

are you sure that the date in the database, is the same format as the strtotime date.

[StanLytle]

Yes.  With some help  (thanks guys) I was able to output (view) the contents of the table by the cutoff time I wanted.  See:

 

http://www.phpfreaks.com/forums/index.php/topic,243819.0.html

 

for reference.  Now I want to use the data, find a specific person, without displaying the table.

 

Stan