Help Please Select Max Not Working

[rosh1e]

Hi,

Can someone please tell me what is wrong with this code, it is doing my nut!!!!!


$result=mysql_query("SELECT max(productcode) FROM tblproductcodes where categoryID=$category");
$lastproductcode=mysql_fetch_row($result);
echo $lastproductcode[productcode];

I have checked that something is returned, one row is returned, yet I cannot for the life of me get the resulting figure out, it's just blank. What am I doing wrong? Please help .

It's sad enough that I'm spending my Saturday evening working, but even worse that what I'm doing is not even working.

Thank you in advance

[grahame]

Try
echo $lastproductcode[0];

[Accurax]

how is php work?... the two are completely different.

If grahame's solution doesnt work you may try adding the '' and do:

Code: Select all

echo $lastproductcode['productcode'];

Dont you need those when dealing with arrays?

[rosh1e]

Hi Grahame,

Thanks that worked a treat. Your a star xxx

Thank you so much