Newbie: Extracting Data

[Tentux]

I understand how to extract a row of data but was wondering if I could extract a feild of data at a time?😕

[stolzyboy]

show us what you have, then explain a little better what you want

[Tentux]

Well i know i can use like mysql_fetch_row and it returns an array. Whereas mysql_fetch_field will just give me an object containing information about the field but not the records. I don't really need to show you what i have its fairly self-explanitatory.

[stolzyboy]

well you could also use mysql_fetch_array and to this, not sure if this is too simple for what you want, but you aren't explaining yourself real well

<?
$conn = mysql_connect("localhost", "username", "password");
$db = mysql_select_db("databasename");

$query = "select * from tablename;";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
echo $row['fieldname'] . "<br>";
}
?>

[Tentux]

Thanks for your help im sure i'll work it out, pleanty of material out there.

[stolzyboy]

it would really help if you would explain yourself better, i can't read your mind, it may seem simple to you what you want, but i only know what you are talking about by what you tell me