Returned Results Without Loop

[The Little Guy]

Is there a different way that I can go through results from a database without using a loping method such as the "while loop"?

[phpSensei]

I can't think of any other way...

 

edit: nvm, i dot think that would work.

[ikmyer]

just wondering... why are you looking for a different way?

[The Little Guy]

this seems to work:

 

$sql = mysql_query("SELECT count(*) as countFROM users");
mysql_result($sql,0);
mysql_result($sql,1);
mysql_result($sql,2);
//etc.

[phpSensei]

why dont you just do

 

$row = mysql_fetch_array($sql);

 

doesnt seem to have any difference from what you are doing there.

 

 

mysql_fetch_row()

mysql_fetch_array()

mysql_fetch_assoc()

mysql_fetch_object()

[discomatt]

Is there a different way that I can go through results from a database without using a loping method such as the "while loop"?

 

If you have a constant amount of rows returned, mysql_result( $resource, $rowNum, $colNum ) will return the given cell. This is kinda useless for dynamic data though.

[The Little Guy]

Here is my query:

 

(SELECT COUNT(id) AS count FROM users)
UNION
(SELECT COUNT(id) as count FROM users GROUP BY gender)
UNION
(SELECT COUNT(id) as count FROM images)
UNION
(SELECT COUNT(id) as count FROM videos)
UNION
(SELECT COUNT(id) as count FROM events)
UNION
(SELECT COUNT(id) as count FROM leagues)