[Resolved] mysql_fetch problem

[blaster_master]

this is a part of my code that has some error within:

<?php
$db = mysql_connect("localhost", "****t", "*********");
mysql_select_db("my_db", $db);
$code_max = mysql_query("select max(code) as code from my_table");
$code_get = mysql_fetch_array($code_max);
echo $code_get;
?>

"code" is a column under my_table with the style of 'xx000' (xx are letters and 000 are pure integers), and is set to varchar.

why do i get "Array" as an output?

i've also tried mysql_fetch_row and mysql_fetch_assoc and a couple other ones, although non-related to what i want.

[Weedpacket]

Originally posted by blaster_master
Why do I get "Array" as an output?

Because that's what you're asking for:

$code_get = mysql_fetch_array($code_max);
echo $code_get;
?>

[/b]

Have a look at the [man]mysql_fetch_array[/man] page to see what to do next.

[blaster_master]

yea, forgot the while(..) statement.
thnx

[Weedpacket]

Well, not so much the while() loop (there's only one record and only one field in the record, so the loop is going to be pretty short of things to do), but rather the contents of the loop. You've got the array, now which element do you want out of it (hint: there's only one element).