Oy! One more Newb Question

[FoxhoundX]

Okay, I searched and couldn't find anything.

Please ignore my stupidity, just decided to start learning MySQL as I've been using text files and they just get annoying after a while 😛

How would I recall a field and display it? What I want to do, Is I have a login script, works all fine and well, but I want to display their information (Stored in different fields) How would I go by doing this?

[dalecosp]

For one item, perhaps:

$sql="select occupation from personal_info where user='bob'";
$result=mysql_query($sql);

echo $result;  // would echo the contents of the 'occupation' column

....at least I think that's right. Seems likely mostly anymore I'm selecting whole sets of entry and turning them into arrays, vis a vis:

$sql="select * from personal_info where user='bob'";
$result=mysql_query($sql);
$info=mysql_fetch_array($result);

echo $info['hair_color'];  // would echo the contents of the 'hair color' column

mysql_fetch_array() is a cool function that creates an associative array from the columns of a table in the db. So if our table contained the rows "hair_color", "occupation", "dog_cat_lover", and "fave_music", the array might be:

print_r($info);

/*  output is:
array[4]=(['hair_color']->"red"; ['occupation']->"dentist"; ['dog_cat_lover']->"dog"; ['fave_music']->"country & western")
*/

HTH,