help :(Warning: mysql_fetch_array())

medo

Hi all

I have nuke and when i delete old story i faced this two problems :

my first problem is this Warning :

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/alnassr/public_html/includes/sql_layer.php on line 238

the codes in the line 238 is :

function sql_num_rows($res)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
    $rows=mysql_num_rows($res); 
    return $rows;
break;;

line 238 is $rows=mysql_num_rows($res);

====

my secend problem is this Warning :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/alnassr/public_html/includes/sql_layer.php on line 342

the codes in the line 342 is :

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
    {
    case "MySQL":
        $row = array();
        $row = mysql_fetch_array($res);
        return $row;
    break;;

the line 342 is $row = mysql_fetch_array($res);

waiting for your help thanks

bad76

Hi,
just do a search on phpbuilder forum give you a lot of hint.
(just typing "not valid result" give me other 628 thread on this argument, and possible answer are only 3/4...)

When you make a query use this way:
mysql_query($myquery) or die(mysql_error().":".$myquery);

This will give you every thing you want know.

see you

BuzzLY

The warning tells you that $res is not a valid MySQL result. Yet, you do not tell us how you are setting $res.

Do you want help figuring out why $res isn't valid? Then show us how you set it.
Do you want to know what the error message means? It's pretty self-explanatory. The argument ($res in this case) is not a valid MySQL result. Therefore, you must have set it incorrectly. See #1 above.