Looping through fields in a row

[stacey]

Hi All,

I am trying to display a mysql record on the screen. I would rather
not use specific field names in case the fields change, etc. So, I
just want to create a simple table with the field names down the first
column and the corresponding values in the second. I've tried several
different snippets of code that I found, but I can't seem to get it
working right.

This is what I've been working off of:

$fieldNames=array_keys($myrow);

But this array have every other value as, what seems to be, a row id.
Looks like this:

Array ( [0] =0 [1] =sheet_id [2] =1 [3] =client_id [4] =2
[5] =business_name [6] =3 [7] =business_address [8] =4 [9] =>
business_city)

Any suggestions would be appreciated.

[Captain Paralytic]

On 13 Sep, 15:28, stacey <[e-mail]:

Hi All,

I am trying to display a mysql record on the screen. I would rather
not use specific field names in case the fields change, etc. So, I
just want to create a simple table with the field names down the first
column and the corresponding values in the second. I've tried several
different snippets of code that I found, but I can't seem to get it
working right.

This is what I've been working off of:

$fieldNames=array_keys($myrow);

But this array have every other value as, what seems to be, a row id.
Looks like this:

Array ( [0] =0 [1] =sheet_id [2] =1 [3] =client_id [4] =2
[5] =business_name [6] =3 [7] =business_address [8] =4 [9] =>
business_city)

Any suggestions would be appreciated.

use mysql_fetch_object or mysql_fetch_assoc and use a foreach thus

$rows = mysql_fetch_assoc($res);
foreach ($rows[0] as $field_name =$field_value)
echo "<tr><td>{$field_name}</td><td>{$field_value}</td></tr>";

[C.]

On 13 Sep, 15:44, Captain Paralytic <[e-mail]:

On 13 Sep, 15:28, stacey <[e-mail]:

Hi All,

I am trying to display a mysql record on the screen. I would rather
not use specific field names in case the fields change, etc. So, I
just want to create a simple table with the field names down the first
column and the corresponding values in the second. I've tried several
different snippets of code that I found, but I can't seem to get it
working right.

This is what I've been working off of:

$fieldNames=array_keys($myrow);

But this array have every other value as, what seems to be, a row id.
Looks like this:

Array ( [0] =0 [1] =sheet_id [2] =1 [3] =client_id [4] =2
[5] =business_name [6] =3 [7] =business_address [8] =4 [9] =>
business_city)

Any suggestions would be appreciated.

use mysql_fetch_object or mysql_fetch_assoc and use a foreach thus

$rows = mysql_fetch_assoc($res);
foreach ($rows[0] as $field_name =$field_value)
echo "<tr><td>{$field_name}</td><td>{$field_value}</td></tr>";

Thanks for playing Captain, unfortunately the correct answer was:

while ($row = mysql_fetch_assoc($res)) {
foreach ($row as $name =$val) {
echo "<tr><td>{$name}</td><td>{$val}</td></tr>\n";
}
}

C.

[Rik Wasmus]

On Thu, 13 Sep 2007 16:28:15 +0200, stacey <mo********@gmail.comwrote:

Hi All,

I am trying to display a mysql record on the screen. I would rather
not use specific field names in case the fields change, etc. So, I
just want to create a simple table with the field names down the first
column and the corresponding values in the second. I've tried several
different snippets of code that I found, but I can't seem to get it
working right.

This is what I've been working off of:

$fieldNames=array_keys($myrow);

But this array have every other value as, what seems to be, a row id.
Looks like this:

Array ( [0] =0 [1] =sheet_id [2] =1 [3] =client_id [4]=2
[5] =business_name [6] =3 [7] =business_address [8] =4[9] =>
business_city)

Don't fetch the result with mysql_fetch_array(), use mysql_fetch_assoc()
instead. mysql_fetch_array() will return both a numerical as named array
by default.
--
Rik Wasmus

[Captain Paralytic]

On 13 Sep, 15:44, Captain Paralytic <[e-mail]:

On 13 Sep, 15:28, stacey <[e-mail]:

Hi All,

I am trying to display a mysql record on the screen. I would rather
not use specific field names in case the fields change, etc. So, I
just want to create a simple table with the field names down the first
column and the corresponding values in the second. I've tried several
different snippets of code that I found, but I can't seem to get it
working right.

This is what I've been working off of:

$fieldNames=array_keys($myrow);

But this array have every other value as, what seems to be, a row id.
Looks like this:

Array ( [0] =0 [1] =sheet_id [2] =1 [3] =client_id [4] =2
[5] =business_name [6] =3 [7] =business_address [8] =4 [9] =>
business_city)

Any suggestions would be appreciated.

use mysql_fetch_object or mysql_fetch_assoc and use a foreach thus

$rows = mysql_fetch_assoc($res);
foreach ($rows[0] as $field_name =$field_value)
echo "<tr><td>{$field_name}</td><td>{$field_value}</td></tr>";- Hide quoted text -

- Show quoted text -

Yes of course it was!

I have spent so long using mysql through a framework, that I totally
forgot what the raw functions do!

[Norman Peelman]

Rik Wasmus wrote:

On Thu, 13 Sep 2007 16:28:15 +0200, stacey <mo********@gmail.comwrote:

>Hi All,

I am trying to display a mysql record on the screen. I would rather
not use specific field names in case the fields change, etc. So, I
just want to create a simple table with the field names down the first
column and the corresponding values in the second. I've tried several
different snippets of code that I found, but I can't seem to get it
working right.

This is what I've been working off of:

$fieldNames=array_keys($myrow);

But this array have every other value as, what seems to be, a row id.
Looks like this:

Array ( [0] =0 [1] =sheet_id [2] =1 [3] =client_id [4] =2
[5] =business_name [6] =3 [7] =business_address [8] =4 [9] =>
business_city)

Don't fetch the result with mysql_fetch_array(), use mysql_fetch_assoc()
instead. mysql_fetch_array() will return both a numerical as named array
by default.
--Rik Wasmus

Or just:

mysql_fetch_array($result,MYSQL_ASSOC); // MYSQL_ASSOC, MYSQL_NUM,
MYSQL_BOTH are allowed. Default is MYSQL_BOTH.

Norm