[mememia]

Hi,

I get this error on one of my pages and i cannot figure out how to fix it.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dkizis/public_html/browse.php on line 284

the link is : D Kizis Developers

I am trying to learn so i used a working website and copied it to make it onto a new one with a different template. I ceated the database etc....i just cant solve this one.

Thanks in advance.

Mia

[hemi]

post that query that is causing the problem

[mememia]

PHP Code:

<?

   $querySearch = mysql_query("SELECT * FROM info WHERE category LIKE '%".$_POST['category']."%' $CITYVAR $STATEVAR $PRICEVAR $PRICEHIGHVAR $MINBEDVAR $MAXBEDVAR $PRICETYPEVAR  ORDER BY `pk` DESC limit $offset, $limit");

      while($myrowSearch = mysql_fetch_assoc($querySearch))

    {        

    ?>

Thanks

[wirehopper]

What are the columns in the info table?

[Jcbones]

What is:

PHP Code:

$CITYVAR $STATEVAR $PRICEVAR $PRICEHIGHVAR $MINBEDVAR $MAXBEDVAR $PRICETYPEVAR 

??