Fetch

[Nik]

$result=mysql_fetch_field("select name from people");

I just need a way to get a specific field from the table peopl, but that dosent seem to work!

Any help would be appreciated!

[dannys]

Try:

$result=mysql_query('SELECT name from people');
$field=mysql_fetch_field($result);

That would return the details of the field 'name' but I doubt it's what you want. If you want the value of the field use:

$result=mysql_query('SELECT name from people');
$row=mysql_fetch_assoc($result);
$name=$row['name'];

If there are multiple rows you should use:

$result=mysql_query('SELECT name from people');
while($row=mysql_fetch_assoc($result))
    $name[]=$row['name'];

That will create an array of names.

[Nik]

$result=mysql_fetch_field("select name from people");

yes but why this wont work??

when i say selct name it gets all the name column?

if i would say

$result=mysql_fetch_field("select name from people where name='Nikos'");

will it work?

[dannys]

It won't work because mysql_fetch_field doesn't accept a query as an input parameter - it takes a mysql result resource, which is produced by mysql_query which does accept a query as it's input parameter.

http://www.php.net/mysql-fetch-field
http://www.php.net/mysql-query