newbie having problem
| From: | George Pitcher | Date: | Mon, 03 Sep 2001 10:09:41 +0000 |
| Subject: | newbie having problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12109@lists.php.net to get a copy of this message | ||
Hi all,
I'm doing some basic php/MySQL stuff (LinuxPPC on Mac7100). I'm gettin g the
following error when I search for somthing.
========
Supplied argument is not a valid MySQL result resource in
/usr/local/apache/htdocs/bizflyer/Bizflyer_R1.php on line 32
========
Here's my relevant code:
========
<?php
mysql_connect ('pingu','root@localhost','');
mysql_select_db ('Bizplanes');
if ($Serial == "")
{$Serial = '%';}
if ($Type == "")
{$Type = '%';}
if ($Con == "")
{$Con = '%';}
$result=mysql_query ("SELECT * FROM biz WHERE
ID LIKE '%$Serial%' AND
Type LIKE '%$Type%'
Con LIKE '%$Con%'
ORDER BY ID");
?>
TABLE STUFF HERE
<?php
if ($row=mysql_fetch_array($result)) { ######### this is line 32
do {
print ("<TR><TD>");
print $row['ID'];
print ("<TD>");
print $row['Type'];
print ("<TD>");
print $row['Con'];
print ("<TD>");
print $row['Operator'];
print ("</TD></TR>");
} while ($row=mysql_fetch_array($result));
} else {print ("Sorry, no aircraft matching your criteria were found.");}
?>
=========
Any suggestions as to where I'm going wrong?
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
fmdev@yahoo.co.uk
gep1@stir.ac.uk
safc2_1nufc@yahoo.com
http://www.heron.ac.uk
================================================
programmer - A device for transmuting caffeine into code.
================================================
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com