Re: MySQL subdate function

On 21 Aug, Mark Polsen wrote: > Hi all, > > I need to display a result using MySQL's subdate function. I have the following but need > to know to display it in php. > > $date = $row[date]; > $date_diff = 'subdate($date, interval 3 day)'; > $dte_result = mysql_query("select $date_diff from db_name where key_number = > '$eventno'"); > > Thank, > Mark Can you use an alias? select $date_diff AS diff from db_name where key_number = '$eventno' Cheers -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA