Stupid error - cant find problem in code...

[Anon]

Aight everyone - I'm getting a 'Warning: 0 is not a MySQL result index error on the line of my code withthe while() statement. There is no reason for this error. There is information in the database. Does anyone see a problem with this code?

Thanks in advance for any help you might provide.
-=Lazzerous=-

<?php
mysql_connect("localhost", user, pass);
mysql_select_db('db');

$select = "select * from bb where forum like '$forum' and where category like '$category'";
$paco = mysql_query($select);

while ($myrow=mysql_fetch_array($paco)){
echo data from table
}
?>

[Anon]

try:

$select = "select * from bb where forum like '".$forum."' and where category like '".$category."'";

???

Just a shot in the dark...

[Anon]

$select = "select * from bb where (forum like '%$forum%') AND (where category like '%$category%')";

[Anon]

The error you got does not mean that no results were found,
it means that the query did not return a pointer to a result-set.
And empty result-set is still a valid result-set and should not give an error.

"and where" is not allowed in mysql.

after the where, just sum up the conditions.
select a from b where c=d and e=f order by a limit 23;