[SOLVED] Does this error mean there is something wrong with my database?

[db530]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /data/16/1/57/83/1546246/user/1664829/htdocs/sub_category.php on line 118

 

Here is an example page: http://www.industrialpc.com/sub_category.php?cat_id=161

 

I take it there is something wrong with my MySQL db, any suggestions?

[Barand]

It means there is an error in your query.

 

Get the contents of mysql_error() to see what's wrong

[db530]

Thanks. When I check for the error I get "No database selected", I have to use the IP as the host. It's right along with the username, password, and database. Any ideas?

[fenway]

Sounds like you're missing a call to mysql_select_db.... impossible to tell since we haven't seen any code.

[db530]

Here is my connect function, it calls mysql_select_db....Is there any other code I should post?

 

function dbcon(){

global $host, $user, $pass, $db,$link;

if(!($link=mysql_connect($host,$user,$pass)))

{

sprintf("Internal error %d %s",mysql_errno(),mysql_error());

return 0;

}

else

{

return 1;

mysql_select_db($db);

}

[Barand]

it calls mysql_select_db....

 

 

No it doesn't. It returns before the call

[db530]

Can you please tell me where it would go then? I'm new to this.

[Barand]

As soon as you use "return $val" you exit the function.

 

try

else
   {
      mysql_select_db($db);
      return 1;
   }

[db530]

Thank you barand! It worked!

[fenway]

Thank you barand! It worked!

Oh sure, Barand gets the credit ;-) lol....

 

j/k...glad you got it working.