[RESOLVED] best way to see entire rows

system_critical

Hi,

What's the best way to get entire MYSQL table rows, when querying for more than one row. For instance, if your query returns 2 rows with 4 columns each how can you access the entire first row as a unit. Both mysql_fetch_row and mysql_fetch_array seem to index each individual column 0-7 (in the 2 rows). I need to query more than one row at a time, but get at them only one at a time. Any thoughts? I've been toying around with a for loop based on the number of rows (via num_rows), but I can't figure out how to get at the individual rows (ie you can't mysql_fetch_row($result[$for_variable])😉 Thanks.

HalfaBee

Use a while loop

while( $row = mysql_fetch_assoc( $result ) ) {
// do stuff here $row is an assoc array of the row.
}

FijiSmithy

I kinda like this one I made all you need to do is supply a query and it will output a nice formatted table for you

<?php
$result = dbquery('YOURQUERY');
$row = dbfetch($result);
$firstrow = true;
$num_of_rows = count($row);
$Header = array_keys($row);
$num_of_values = 0;
?>

<HTML>
<HEAD>
<style type="text/css">
  #row0  {background-color: #DDEDC6}
  #row1  {background-color: #FFFFFF}
 </style>
</HEAD>
<BODY>

<?php
$index = 1;
echo "<table border=\"1\" width=\"100%\">\n";
do{
echo "<tr id=\"row";
 echo $index%2;
 $index += 1;
 echo "\">\n"; 
if($firstrow){
 for( $i = 1; $i < $num_of_rows; $i += 2){
  echo "<td><b>";
  echo $Header[$i];
  echo "</b></td>\n";
 }
 echo "</tr>\n";
 echo "<tr id=\"row";
 echo $index%2;
 $index += 1;
 echo "\">\n";
 $firstrow = false;
}
 for ($i = 0; $i < $num_of_rows/2; $i += 1){
  echo "<td>";
  echo $row[$i];
  echo "</td>\n";
 }

echo "</tr>\n";
$num_of_values += 1;
}while($row = dbfetch($result));
echo "</table>\n";
echo "<hr>".$num_of_values." rows returned";
?>

</BODY>
</HTML>

system_critical

I can't seem to access the elements in the assoc. array. I tried echo $row[0];. This outputted nothing. I tried echo $row[0][0]; and got nothing. I tried array_keys ($row); and got Array. What am I doing wrong with the keys? Thanks for being patient. Here is my code.

$default_query ="SELECT user_id, user_img, score, level FROM my_table ORDER BY score";
    $result = mysql_query($default_query); // query works fine

while( $row = mysql_fetch_assoc($result)) {
    $keys = array_keys($row);
echo $keys; // outputs ArrayArray
    echo $row[0].'here is row 0'; // outputs nothing
echo $row[0][0].'here is row 00'; //outputs nothing
echo $row['Array'].'here is row "array"'; // outputs nothing

}

HalfaBee

Bacause the assoc array uses the column names.
Use mysql_fetch_array()

system_critical

Pefect, works very well now. Thanks for the help. I really appreciate it.

laserlight

Actually, why use numeric indices at all? You might as well use $row['user_id'] as it is more readable than $row[0].

Weedpacket

For that matter, [man]mysql_fetch_array[/man] returns the values indexed both ways (numerically and associatively). There is also [man]mysql_fetch_row[/man]; and flags for controlling [man]mysql_fetch_array[/man]. [man]mysql_fetch_assoc[/man] returns an associative array (hence the name). Associative arrays are a bit more robust.

system_critical wrote:

  while( $row = mysql_fetch_assoc($result)) {
        $keys = array_keys($row);
    echo $keys; // outputs ArrayArray

That's because [man]array_keys[/man] returns an array, And you're trying to echo it twice (once for each row).