Thanks for the tip. Got it working.
--
Chip
"Rick Emery" <[EMAIL PROTECTED]> wrote on 03/22/2004 09:50:59 AM:
> What result are you getting?
>
> First off, I see that your HTML is possibly incorrect; should it be:
> echo "<td>Warranty ID:</td>\n";
>
> <th> is a table header.
>
> Second, if you are expecting a single result row, then you do not
> need the while() loop. Do a
> single fetch and display the result.
>
> rick
> "People will forget what you said. People will forget what you did.
> But people will never forget how you made them feel."
> ----- Original Message -----
> From: "Chip Wiegand" <[EMAIL PROTECTED]>
> To: "MySQL " <[EMAIL PROTECTED]>
> Sent: Monday, March 22, 2004 11:33 AM
> Subject: select statement not working in a php page
>
>
> I am trying to get a single result from a database, which works fine at
> the sql command line. I have tried several versions of code, this being
> the most recent -
> <?
> $sql = "select max(WarrantyID) from warrantycopy";
> $result=mysql_query($sql) or die("Could not get the id number :" .
> mysql_error());
> while($query_data = mysql_fetch_array($result)) {
> $WarrantyID = $query_data["WarrantyID"];
> echo "<tr>\n";
> echo "<th>Warranty ID:</th>\n";
> echo "<td>$WarrantyID</td>\n";
> echo "</tr>\n";
> }
> ?>
> No matter what I do I do not get the desired max id number from the
column
> WarrantyID. The same query works fine at the sql command line. What am I
> doing wrong?
> thanks
> --
> Chip
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
