query MySQL for latest record

[Anon]

How can I get the most recent/last record from my table ?

My table "OrdNum" has two fields: Day, OrderNumber
OrderNumber is set to "default 0, autoincrement"

When a new order is produced, an entry is made into the table:
mysql_query("insert into OrdNum (Day,OrderNumber) values ('$mday','')");
How do I get the new/incremented OrderNumber "$OrderNumber"!

Thanks

[Anon]

select MAX(OrderNumber) as maxnum from OrdNum

you may need to add "group by OrderNumber" to the end if you get aggregate error

this should return the highest OrderNubmer

Ace

[Anon]

Do you mean:
$result = mysql_query("select MAX FROM OrdNum WHERE OrderNumber");

Peter

[ace21]

$result = mysql_query("select MAX(OrderNumber) as maxnum FROM OrdNum");

now you can refer to it as "maxnum" or whatever you want to call it like

$row["maxnum"]

hope this helps.
ace

[Anon]

The following keeps giving me "2" as a result, however there are now 30 records in the table !

$result = mysql_query("select MAX(OrderNum) as maxnum FROM Ordnum");

echo "order number: $result<BR>";

Here is how I have been adding new records:

$TodaysDate=date("Ymd");
$today = getdate();
$Year = $today[year];
$mon = $today[mon];
$mday = $today[mday];

$nyear = substr($Year,2);
$day="$nyear$mon$mday";
// gives me "01530"
echo "$day<BR>";
// increment order number
mysql_query("insert into Ordnum (Day) values ('$day')");

What should I change to display to highest record number ?

Thanks,
Peter

David wrote:

$result = mysql_query("select MAX(OrderNumber) as maxnum FROM OrdNum");

now you can refer to it as "maxnum" or whatever you want to call it like

$row["maxnum"]

hope this helps.
ace

[ace21]

try this code

$result = mysql_query("select MAX(OrderNum) as maxnum FROM Ordnum",$db);

$row = mysql_fetch_array($result);

echo $row["maxnum"];

[Anon]

The new code does the trick !

Now to move on to read up about table locking !

Thank you very much,
Peter

[neuromancer]

MSSQL : SELECT TOP 1 n,... FROM x