[PHP-DB] Re: Table results returning 2 sets of the same row

[Hugh Bothwell]

"Ron Gallant" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> And my table results are shown 2 times per row.
> http://www.chizeledlight.com/test.php

... at a guess, you requested the same field twice
in your SELECT statement.

I don't like the sample code given because it just
iterates through the rows rather than using their
names - if you alter your SQL, it could change the
column order, which is kinda non-intuitive.

> I also don't know how to specify the column I want the result from.  Like
> $columnName.

Try this instead:

$query =
     "SELECT field1,field2,field3 "
    ."FROM tablename ";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
    explode($row);
    echo "\n<tr><td>$field1</td><td>$field2</td><td>$field3</td></tr>";
}



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]