page just not showing properly

[illuz1on]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/capetown/public_html/pza/db.php on line 47

You must be logged in, in order to purchase anything from the shop

 

         

  Name  Price  Available ?  Delivery Time 

 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/capetown/public_html/pza/db.php on line 35

 

Can anyone tell me what this error could be from?

[suzzane2020]

how bout some code

[illuz1on]

Thanks for fast reply

 

this is line 35

 

function SQLGetRow($res)

{

    $row = mysql_fetch_row($res);

return $row;

}

 

 

and then this is line 47

 

 

function SQLNumRows($res)

{       

$rows = mysql_num_rows($res);

    return $rows;

}

[suzzane2020]

when are the functions called and cud u display the $res too

 

[illuz1on]

This is one place that it is being called, there are many of them..

 

 

<font class="header">Party-zA Clubs</font><br>
	<br>
		<?php
			$result = SQLQuery('SELECT ID,Name from '.SQLTable('partyza_club'));
			$c = 1;
			while (list($clubid,$clubname) = SQLGetRow($result))
			{
		?>
			<?php echo $c ?>. <a href="clubs.php?view=<?php echo $clubid; ?>&name=<?php echo $clubname; ?>"><?php echo $clubname; ?><br></a>
		<?php
				$c++;
			}
		?>

[illuz1on]

anyone? really desperate to get this code sorted out...

 

Thanks

[nogray]

I tried your functions and they seem to be fine. Check if your query return any result or if you SQLQuery function is generating any errors.