Warning: mysql_num_rows():

[welbyobeng]

Can anyone help..... When I search on my site this is the error I get

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php on line 28


This is a peice of the code from function.phpif(mysql_num_rows($sql_res)){
return mysql_fetch_object($sql_res);
}
else {
return '';
}
}
elseif($wtr=='num'){
return mysql_num_rows($sql_res);
}
elseif($wtr=='res'){
return $sql_res;
}
}

[sn4rf3r]

Is this the offending line?
return mysql_num_rows($sql_res);

If so, you are getting a zero result back and trying to return that. Can you post the whole function?

[welbyobeng]

Is this the offending line? If so, you are getting a zero result back and trying to return that. Can you post the whole function?

yes that is the offending line

[sn4rf3r]

put that into an if statement and go from there.
[php]

if(mysql_num_rows($sql_res)) {
//do something fancy
} else {
exit ("there is no data for you here");
}

[/php]

[welbyobeng]

put that into an if statement and go from there. [php] if(mysql_num_rows($sql_res)) { //do something fancy } else { exit ("there is no data for you here"); } [/php]

So this is how is suppose to lookif(mysql_num_rows($sql_res)){
return mysql_fetch_object($sql_res);
}
else {
return '';
}
}
elseif($wtr=='num'){

if(mysql_num_rows($sql_res)) {
//do something fancy
} else {
exit ("there is no data for you here");
}

}



if not can you post it with everything

[sn4rf3r]

you can do that or you can do everything you need to in the first if statement. that will save you some code space.

[welbyobeng]

When I put that. every result put no data, but when I had the previous script it had data but with an error on top

[sn4rf3r]

When I put that. every result put no data, but when I had the previous script it had data but with an error on top

Without seeing the entire function, i cant really help you with logic.

[welbyobeng]

<? } ?>

<? require('templates/ad_header.php'); ?>


<?
}//function

//showing header
function show_header(){
?>

Demo Site
<?
$mode=form_get("mode");
$act=form_get("act");
if($mode=="user"){
?>

<?
}
elseif(($mode=='listing')&&($act=='create')){
?>

<?
}
elseif((($mode=='listing')&&($act!='create')&&($act!='show')&&($act!='feedback'))||(($mode=='search')&&($act=='listing'))){
?>

<?
}//elseif
?>

<? require('templates/header.php'); ?>


<?
}
//showing footer
function show_footer(){
?>


<? require("templates/footer.php"); ?>

[sn4rf3r]

Try this:

[php]
if(mysql_num_rows($sql_res)){
if($wtr=='get' || $wtr == 'num'){
return mysql_fetch_object($sql_res);
} elseif($wtr=='res'){
return $sql_res;
} else {
return;
}
}
[/php]
I dont know what you are trying to do by returning a mysql resource if wtr==res, but this should compact some of your logic.

[welbyobeng]

Try this: [php] if(mysql_num_rows($sql_res)){ if($wtr=='get' || $wtr == 'num'){ return mysql_fetch_object($sql_res); } elseif($wtr=='res'){ return $sql_res; } else { return; } } [/php] I dont know what you are trying to do by returning a mysql resource if wtr==res, but this should compact some of your logic.

When I put your script I recieved this:Parse error: syntax error, unexpected $end in /mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php on line 4890

[sn4rf3r]

there is nothing syntaticlly wrong with the code i gave you, you must have copy and pasted it in correctly. You have a mis-matched { somewhere in there, maybe open the file in an IDE like zend or eclipse to figure out where the error is.

[welbyobeng]

there is nothing syntaticlly wrong with the code i gave you, you must have copy and pasted it in correctly. You have a mis-matched { somewhere in there, maybe open the file in an IDE like zend or eclipse to figure out where the error is.

Ok i am going to send you the file and can you please place the code for me and send it back.

[sn4rf3r]

No, you can do this, you need to know how to debug your own code. please do your own work.

[welbyobeng]

No, you can do this, you need to know how to debug your own code. please do your own work.

Sir i have done it several times. i am getting the same error

[welbyobeng]

<? } ?>

<? require('templates/ad_header.php'); ?>


<?
}//function

//showing header
function show_header(){
?>

Demo Site
<?
$mode=form_get("mode");
$act=form_get("act");
if($mode=="user"){
?>

<?
}
elseif(($mode=='listing')&&($act=='create')){
?>

<?
}
elseif((($mode=='listing')&&($act!='create')&&($act!='show')&&($act!='feedback'))||(($mode=='search')&&($act=='listing'))){
?>

<?
}//elseif
?>

<? require('templates/header.php'); ?>


<?
}
//showing footer
function show_footer(){
?>


<? require("templates/footer.php"); ?>

[welbyobeng]

I also trying deleting ?>

[sn4rf3r]

deleting the ?> wont help as you need an ending tag for php, there is a mismatched bracket somewhere in your code, use a code editor like eclipse or zend ide to go through and debug your code.