|
|
Posted by Norman Peelman on 09/14/07 23:15
Rik Wasmus wrote:
> On Thu, 13 Sep 2007 16:28:15 +0200, stacey <monkeymynd@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)
>
> 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
Navigation:
[Reply to this message]
|