Query problem - most likely simple

[defroster]

A bit troubled, any input would be much appreciated

 

This works fine:

$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE videos.cat_id =" . $_GET['cat'] . " AND videos.status ='1'";

 

And this doesn't.. Any ideas why? What am I doing wrong.

$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE videos.cat_id =" . $_GET['cat'] . " AND videos.status ='1' AND videos.dateposted <= now()";

[PFMaBiSmAd]

It would really help if you told us what it did do -

 

a) Produced a sql error?

b) Executed without error but matched zero rows?

c) Returned the wrong rows?

[defroster]

Thanks for quick reply. I get this error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/cat.php on line 247

Line 247

$total_pages = mysql_fetch_array(mysql_query($query));

 

A bit of all the code:

$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE videos.cat_id =" . $_GET['cat'] . " AND videos.status ='1' AND videos.dateposted <= now()";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

[shlumph]

Is the only difference the fact you appended

videos.dateposted <= now()

to your query?

 

There's obviously a problem there then, and after answering PFMaBiSmAd, you should find the problem mightily quick

[shlumph]

What does mysql_query($query) or die(mysql_error()) return?

[defroster]

Sorry guys, it was me. I had a faulty code on another place returning an invalid id. Time for bed I guess Thanks for the help anyways.

[PFMaBiSmAd]

You MUST ALWAYS validate external data. If $_GET['cat'] didn't have a value in it or it was not numeric, you should have never executed the query.

[defroster]

You are absolutely correct PFMaBiSmAd.

 

I see your signature says the same:

Debugging step #1: To get past the garbage-out equals garbage-in stage in your code, you must check that the inputs to your code are what you expect.

 

Thanks and good night,

df