-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Here's the syntax I use.
$db=mysql_connect( "$host", "$db_user","$db_password")
or die ("<h2>".mysql_error()."</h2>");
mysql_select_db("$db_name", $db);
$rs = mysql_query($qu, $db)
or die ("<h2>".mysql_error()."</h2>");
- ---Original Message---
From:Lane Johnston
Sent: Wednesday 22 January 2003 01:31 pm
> 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
>
>
- --
Jeff Powell
[EMAIL PROTECTED]
http://www.yonezawa-english-school.com
http://www.yonezawa-english-school.com/powell
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+Lj6mbJk3zHBW5lARAt80AJ98zx7t7oxs9pP6Is30J6OvnL2RIQCfQJiX
1zDjRnKkBr9Mo3VknCAXsDE=
=v6rJ
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
