Need the PHP gurus for this one...

[Lane Johnston]

Ok php gurus,
Little info on system: XP, localhost, port 3306
i am tring to connect to a db in mysql and i looks like that I am doing something wrong?
Here is the code...

@ $db = mysql_pconnect("localhost:3306", "omegaweb", "jesus316");

if( $db ) { echo "Connected"; }
if( !$db )
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

mysql_select_db("books");
$query = "SELECT * FROM books WHERE ".$searchType." LIKE '%".$searchTerm."%'";
$result = mysql_query($query);

$num_results = mysql_num_rows($result); //This is where I am getting the error actually: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\php testing\results.php on line 33"

I figured that if $result is NULL then of course there would be an error.

Could someone shed some light on this newbie?
Thanx


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php