I did this directly into MySQL on the LinuxPPC box:

mysql> select * from biz where
    -> ID LIKE '%AXD%' AND
    -> Type LIKE '%' AND
    -> Con LIKE '%'
    -> ORDER BY ID;

and this is the response:


+--------+---------------------+---------+----------+---------+-------+
| ID     | Type                | Con     | Operator | History | Notes |
+--------+---------------------+---------+----------+---------+-------+
     |DC | Piper Aztec         | 27-4169 |          | G-AXDC  |       
     |DL | Piper Twin Comanche | 30-1856 |          | G-AXDL  |       
     |DM | BAE HS 125/400B     | 25194   |          | G-AXDM  |       
+--------+---------------------+---------+----------+---------+-------+

In these records, what is actually in the ID field is also being displayed in 
'History'.

Not sure if this clarifies things?

George


----- Original Message ----- 
From: Torgil Zechel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2001 11:38 AM
Subject: SV: [PHP-DB] newbie having problem


> Check if mysql_query returns false. If it does (and im pretty sure it do),
> use mysql_error to check whats wrong... (Another way is to echo the query
> and paste it into the mysql command line client..)
> 
> $result = mysql_query("...");
> 
> if( $result == FALSE )
> {
> echo mysql_error();
> }
> 
> > 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
> >
> > [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
> >
> > 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
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to