MAX(id)

[mattennant]

anyone any ideas why this

$query3="SELECT keyword_id FROM keywords";
$result100 = mysql_query($query3) or die(mysql_error());
while ($row = mysql_fetch_array($result100)){
echo $row['keyword_id'];
}

returns 123456

wheras this

$query3="SELECT MAX(keyword_id)FROM keywords";
$result100 = mysql_query($query3) or die(mysql_error());
while ($row = mysql_fetch_array($result100)){
echo $row['keyword_id'];
}

does not return 6
?
tis bugging me

[mattennant]

sorted it SELECT MAX(keyword_id) as id FROM keywords

echo $row['id'];

did the trick

[eelixduppy]

Cool. Glad you got it :)