quick problem

[jwk811]

    $sql = "SELECT max(size) FROM products";

 

    $result = dbQuery($sql);

 

$row = mysql_fetch_assoc($result);

extract($row);

$size isnt an option? how can I get the number of the max size?

 

(functions are fine, just simplified)

[utexas_pjm]

    $sql = "SELECT max(size) FROM products";

 

    $result = dbQuery($sql);

 

$row = mysql_fetch_assoc($result);

extract($row);

$size isnt an option? how can I get the number of the max size?

 

(functions are fine, just simplified)

 

SELECT max(size) AS max_size FROM products

 

Now use max_size as the col name.

 

Best,

 

Patrick

[jwk811]

aww i remember that now.. thanks!

[btherl]

max(size) on its own will give you a column named "max".  But I always use AS with aggregates.  Makes things neater