Getting Certain Parts Of A Record The character data

[FirefoxRocks 0]

There are no such functions in PHP5, or at least according to http://php.net/.

There are date and time functions here on dev.mysql.com, exact url is http://forums.xisto.com/no_longer_exists/.

[TavoxPeru 0]

There are no such functions in PHP5, or at least according to http://php.net/.

That's correct, but you can obtain the month name easily using the strftime(), strtotime(), date() and time() php functions together or directly with the MONTHNAME() MySql function:

<?php// php functions$monthname=strftime("%B",strtotime(date("d-m-Y",time())));// MySql function$sql="SELECT MONTHNAME('2007-10-26') as mname";$rs=mysql_query($sql) or die('Error...');$row=mysql_fetch_array($rs);$mname=$row["mname"];echo "Month Name with Php: " . $monthname;echo "<br />Month Name with MySql: " . $mname;?>

Best regards,

[pyost 0]

There are date and time functions here on dev.mysql.com, exact url is http://forums.xisto.com/no_longer_exists/.

Heh, didn't think of checking MySQL functions