need help in fetching value from qry
Posted: Tue Aug 30, 2005 6:26 am
Code: Select all
SELECT DATE_ADD(CURDATE(), INTERVAL 31 DAY)Thanx.
Mannan.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
SELECT DATE_ADD(CURDATE(), INTERVAL 31 DAY)i know it will work fine but i wanted to know that how to fetch value form it. i mean can u plz. tell me how to fetch date from this qry.n00b Saibot wrote:will work fine. use the query as-it-is in php.
Code: Select all
SELECT DATE_ADD(CURDATE(), INTERVAL 31 DAY) AS MyNewDateCode: Select all
$mynewdate = mysql_result($record_set, 0, 'MyNewDate');