MySQL output methods
Posted: Thu Oct 05, 2006 6:25 am
I know of two ways to output a query from a MySQL DB. Are there any other ways to do this other than:
And
Regards,
Code: Select all
$query = mysql_query("SELECT something FROM somewhere");
while ($results = mysql_fetch_array($query)) {
echo $results['something'];
}Code: Select all
$query = mysql_query("SELECT something FROM somewhere");
$numRows = mysql_numrows($query);
for ($i = 0; $i < $numRows; $i++) {
$colOne = mysql_results($query, $i, "colName");
$colTwo = mysql_results)$query, $i, "colTwoName");
echo $colOne;
echo $colTwo;
}