Posted by Captain Paralytic on 09/14/07 14:38

On 13 Sep, 15:44, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 13 Sep, 15:28, stacey <monkeym...@gmail.com> wrote:
>
>
>
>
>
> > 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!

[Back to original message]