Re:Warning
| From: | Sam Masiello | Date: | Sat, 09 Dec 2000 19:46:29 +0000 |
| Subject: | Re:Warning | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-29493@lists.php.net to get a copy of this message | ||
You might want to try:
$Selstmt = "SELECT zip, email FROM OK WHERE zip='$Zip'
AND email='$Email'";
You are missing an AND keyword between your two query filters.
HTH
Sam Masiello
System Analyst
Chek.Com
(716) 853-1362 x289
smasiello@chekinc.com
On Sat, Dec 9th 2000 12:54:35 Website4S@aol.com wrote:
>Hi,
>
>Anyone know why I keep getting a
>
>Warning: 0 is not a MySQL result index ----- on line 11
>
>in this code??
>
><?
>
>$host="localhost";
>$user="";
>$passwd="";
>$dbase="";
>
>$Selstmt = "SELECT zip, email FROM OK WHERE zip='$Zip'
>email='$Email'";
>$dbh=mysql_connect($host, $user, $passwd);
>$query=mysql_db_query($dbase, $Selstmt);
>$num_rows=mysql_num_rows($query);
>
>mysql_close();
>
>if ($num_rows == 0)
>{
>echo "Hi";
>}
>else
>{
>echo "Nihg";
>}
>?>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
>For additional commands, e-mail: php-general-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>