simple variable grabbing.

[kpdvx]

here is my current code:
$sql_date = '2002-10-10';

$query = "SELECT dayname($sql_date) AS day_name";
$result = mysql_query($query);
@extract(mysql_fetch_array($result));

echo $day_name;

However, this doesnt return anything. Have any ideas as to why?

 

[sleipnir214]

Try it this way:

$query = "SELECT dayname('$sql_date') AS day_name"; ______________________________________________________________________
Perfection in engineering does not happen when there is nothing more to add.
Rather it happens when there is nothing more to take away.

 

[KarveR]

Your date should be pulled from a field WITHIN the mysql database.

$query = "SELECT dayname(date_field) AS day_name";
***************************************
Party on, dudes!

 

[kpdvx]

hmm.. what i am trying to do is take the mysql datetime, 2002-10-10 and format it to say "Tuesday, October 10th, 2002" or whatver the datetime is. I can grab "Octover 10th, 2002" by using this:
// DATETIME STRING FORMAT FUNCTION.
function format_date($sql_date) {
$arr = explode("-", $sql_date);
return date("F j, Y", mktime(0,0,0, $arr[1], $arr[2], $arr[0]));
}

but i want to format it like i mentioned above. Any ideas?

 

[KarveR]

yes, select it straight from mysql as you want it using date_format(date_field, blah

http://www.mysql.com/doc/D/A/DATETIME.html

***************************************
Party on, dudes!