RE: [PHP] As x in mysql select

In order to access the value once you have executed your query: You can use the mysql_fetch_array function to retrieve the first row obtained from your query like this: $somevalue = mysql_fetch_array($result) // if you are going to retrieve more than one record, you will need a while loop for this then you can access fdate: $fdate = $somevalue["fdate"] ; HTH Sam Masiello System Analyst Chek.Com (716) 853-1362 x289 smasiello@chekinc.com -----Original Message----- From: William S Poarch [mailto:scott@youcanspeak.com] Sent: Thursday, August 24, 2000 11:08 AM To: php-general@lists.php.net Subject: [PHP] As x in mysql select Hope I'm not double posting this, but the first post hasn't shown up. I've got $result = mysql_query("select *,date_format(anniversary_date, '%W %M %Y') as fdate from individual_info where username = '$username'"); How do I use fdate in PHP? Scott Poarch Director, Japan Operations Editj.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net