sql query to show only some fields

[nadz]

hi, i need an sql query i can execute in a table so that it only shows 2 of the fields. any help would be appreciated. thankyou.

[alpine]

In php:
[code]
<?php

$select = mysql_query("SELECT field_1, field_2 FROM table") or die(mysql_error());
while($col = mysql_fetch_array($select, MYSQL_ASSOC)
{
foreach($col as $fieldname => $value)
{
${$fieldname} = $value;
}

echo $field_1;
echo $field_2;
}

?>
[/code]

[nadz]

hi, thanks alot for your help  ;)

unfortunately im getting errors. im using phpmyadmin, the 2 fields i want to see are "members" and "date" in the table "users". i hope this helps.

thanks again for the help.

[fenway]

DATE is a reserved keyword -- change your column name; in the meanwhile, you can use `date`.