using a sql MAX value to determine the end of a FOR loop

[super015]

I want to create this page with a certain number of table columns based on a MAX value from query.

The query is as follows

$sql_query_catcount = "SELECT MAX(catColumn) AS maxColumn FROM tblcategories";
@mysql_connect($db_host, $db_username, $db_password) or die("Couldn't connect to MySQL server!");
@mysql_select_db($db_name) or die("Couldn't open database");
$result = mysql_query($sql_query_catcount) or die("category query failed");

the beginning of the FOR loop is as follows

for ($column = 1; $column <= $maxColumn ; $column++) {

I want that $maxColumn value to be the value of the $sql_query_catcount, which is an integer. When I try to do it, I debug with an echo of the value $result and get this string.

Resource id #2

Anyone know how to fix this? Thanks.

[ir4z0r]

$result is just the resource link to the result, you have to fetch
it by using
$result_array = mysql_fetch_array($result);
$maxnr = $result_array['maxColumn'];

[super015]

thank you, it worked. I was a little thrown off by the different type of sql query, and it was 5am when I was thinking about it. Thanks again!

[Form1]

You might prefer the following:

list($maxnr) = mysql_fetch_array($result);