Thank you. Changing it to:
$max_esn = mysql_result($max_esn_result,$i);
did the trick.
sa
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 6:33 PM
To: Susan Ator; [EMAIL PROTECTED]
Subject: RE: Why is this query not working
> I am running php 4.2.2 and mysql 3.23.54.
This is a PHP question, not mySQL.
> This is my query:
>
> $sql = "SELECT MAX(esn) FROM address"; // line 37
> $max_esn_result = mysql_query($sql) or print mysql_error(); // line
> 38
> $max_esn = mysql_result($max_esn_result,$i,"esn