illuz1on Posted April 12, 2007 Share Posted April 12, 2007 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? Quote Link to comment Share on other sites More sharing options...
suzzane2020 Posted April 12, 2007 Share Posted April 12, 2007 how bout some code Quote Link to comment Share on other sites More sharing options...
illuz1on Posted April 12, 2007 Author Share Posted April 12, 2007 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; } Quote Link to comment Share on other sites More sharing options...
suzzane2020 Posted April 12, 2007 Share Posted April 12, 2007 when are the functions called and cud u display the $res too Quote Link to comment Share on other sites More sharing options...
illuz1on Posted April 12, 2007 Author Share Posted April 12, 2007 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++; } ?> Quote Link to comment Share on other sites More sharing options...
illuz1on Posted April 13, 2007 Author Share Posted April 13, 2007 anyone? really desperate to get this code sorted out... Thanks Quote Link to comment Share on other sites More sharing options...
nogray Posted April 13, 2007 Share Posted April 13, 2007 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.