Outputting multiple rows with multiple fields

thili

Ok I need to output some rows from my mysql database in php. Each row has 110 some odd fields attached with it. How would I take each row and display everything in each of the fields for that row, then go to the next row and so on.

Heres the code I have so far.

$queryname = "SELECT name FROM surveyanswers;";
$resultname = mysql_query($queryname);
for($y=0;$y<29;$y++)
{
$rowName = mysql_fetch_array($resultname);
echo "&rowName = $rowName[0]";

for($j=1;$j<109;$j++)
{
$querya = "SELECT q$j FROM surveyanswers;";
$resulta = mysql_query($querya);
$field = mysql_fetch_array($resulta);
$temp2a = $j;
$tempa = "a".$temp2a;
echo "&$tempa=$field[0] <br>";
}

What this does is takes the names from the 30 rows in my database, but outputs only the fields from the first row for each name. I need each name to output with its own field data.

jllydgnt

I'm not sure exactly what you mean. Can you post an example of what you want to display. Not all 110 some fields, but a couple to give an idea of what you are doing. I mean, do you want a row with field names, then a bunch of rows with the field data? Like this. I know this won't look neat; they would be lined up in a table of course.

Name Age Height Weight
Billy 23 72in 180lbs
James 30 68in 160lbs
etc...

thili

yup exactly like that. Right now my output looks something like this...

name = blah
&a1=YES
&a2=YES
&a3=YES
&a4=130

name = blah2
&a1=YES
&a2=YES
&a3=YES
&a4=130

it will take the different names from each row, but give each name the same answers from 'blah' as you can see.

jllydgnt

Would you be willing to hard code the field names(they can really be considered labels) into the first row on the top of your table?

jllydgnt

Your last post confused me. Which of the two formats do you want?

Format 1:
name age height weight
billy 23 72in 180
james 25 69in 160

Format 2:
Name = billy
age = 23
height = 72in
weight = 180

name = James
age = 25
height = 69in
weight = 160

thili

They are the same thing basically, I just added a at the end of each field output. Go with yours if it makes a difference as to how you are doing it.

thili

Couldn't I just change my query

$queryname = "SELECT name FROM surveyanswers;";

to something else that will select an entire row instead of just name ?

jllydgnt

This soultion uses mysql_fetch_object(). It will allow you to reference each field by name instead of using an index. It will be helpful when you have 110 some odd fields.

//pull all info from the database
$sql = "SELECT * FROM table_name";

$result = mysql_query($sql)
or die('Yo query be broke, fool!');

//determine the number of rows you returned
$num_rows = mysql_num_rows($result);

//loop through each row
for($i = 0; $i < $num_rows; $i++)
{
$row = mysql_fetch_object($result);
echo("Name = $row->name 
Age = $row->age 
Weight = $row->weight 
Height = $row->height ")
}

This assumes you field names are name, age, height and weight so you reference them like above: $row->field_name

Does this make sense?

thili

sweet it worked thanks man. Oh one more thing. How would I skip outputting a field if the field = NULL ?