time,date...???...help...confused...

[vaska]

ok...i've to the date in mysql table...but i can't get it properly...its in this format...

0000-00-00 (or 2003-01-27)

but i just can't get the DATE_FORMAT to work...driving me nuts...is this wrong?

<? SELECT DATE_FORMAT(pdate, '%D %M %Y') AS date ?>

pdate is the column it's coming out of...

thanks...jv

[Mce]

A few examples to mabye help...

for date range

<? $stmt = "select date_format(pdate, '%d-%m-%Y') where date between 2002-02-11 and 2003-01-15"; ?>

between now and a future date (replace "somenumber" with a actualy number)

<? $stmt = "select date_format(pdate, '%d-%m-%Y') where date between now() and date_add(now(), interval somenumber day)"; ?>

between now and a past date (replace "somenumber" with a actualy number)

<? $stmt = "select date_format(pdate, '%d-%m-%Y') where date between now() and date_subtract(now(), interval somenumber day)"; ?>

-Mce

[vaska]

yep...i was confused...that's alot of work just to convert a date...how about if i just use what i have...???

but...how would i write this with "\" slashes...i can't get this to function...

<input type=\"hidden\" name=\"cdate\" value=\"echo strftime(\"%m.%d.%Y\" ,time())\"> 

?...jv

[Mce]

it's more efficent to have the DB give you the date already formatted, however...

echo '<input type="hidden" name="cdate" value="' . strftime('%m.%d.%Y' ,time()) . '">';

Originally posted by vaska
yep...i was confused...that's alot of work just to convert a date...how about if i just use what i have...???

but...how would i write this with "\" slashes...i can't get this to function...

<input type=\"hidden\" name=\"cdate\" value=\"echo strftime(\"%m.%d.%Y\" ,time())\"> 

?...jv [/B]

[vaska]

with slashes...with...jv

[Mce]

oops...sorry...Mabye I should learn to read eh? you're missing the first slash right before hidden.

echo "<input type=\"hidden\" name=\"cdate\" value=\"echo strftime(\"%m.%d.%Y\" ,time())\">";

-Mce

Originally posted by Mce
it's more efficent to have the DB give you the date already formatted, however...

echo '<input type="hidden" name="cdate" value="' . strftime('%m.%d.%Y' ,time()) . '">';

[/B]

[vaska]

i'm a little frustrated because i can't make this work with the slashes...

is that really correct (the previous post)?

when the page comes up in the browser it's just coming up as text...

?...jv

[Mce]

Sounds like you have the line outside of the

<? ?>

tags

-Mce

[vaska]

for some reason i was under the impression that i couldn't use "echo" inside of slashes like...nor do i need the <? or ?>...this is what i have...and it doesn't work...

<input type=\"hidden\" name=\"cdate\" value=\"<? echo strftime(\"%m.%d.%Y\" ,time()) ?>\">

need some advice please...jv

[Mce]

<?
echo "<input type=\"hidden\"name=\"cdate\" value=\"' . strftime(\"%m.%d.%Y\" ,time()) .'\">";
?>

or

<input type="hidden" name="cdate" value="<? strftime("%m.%d.%Y",time()); ?>">

Originally posted by vaska
for some reason i was under the impression that i couldn't use "echo" inside of slashes like...nor do i need the <? or ?>...this is what i have...and it doesn't work...

<input type=\"hidden\" name=\"cdate\" value=\"<? echo strftime(\"%m.%d.%Y\" ,time()) ?>\">

need some advice please...jv

[feldon23]

Originally posted by vaska
for some reason i was under the impression that i couldn't use "echo" inside of slashes like...
nor do i need the <? or ?>...this is what i have...and it doesn't work...

<input type=\"hidden\" name=\"cdate\" value=\"<? echo strftime(\"%m.%d.%Y\" ,time()) ?>\">

need some advice please...jv

The problem is, you are escaping the " marks in your HTML and you are
embedding PHP in there. Also you are escaping " both in PHP and out of PHP.

First, when you are in a PHP construct, then everything must be echoed.
If you drop out of PHP construct, then you can put normal HTML.

This:

<?php
echo "hello there\n";
echo "<font face=\"Arial\" size=\"10\"><b><br>\n";
echo "I was talking to ".$tom." the other day.<br>\n";
?>

is equivalent to this:

hello there
<font face="Arial" size="10"<b><br>
I was talking to <? echo $tom; ?> the other day.<br>

When echoing/printing, you need to escape " marks. When issuing a PHP command,
you don't escape " marks. I know it is confusing at first.

For instance:
echo "elvis was \"here\".";
Not:
echo \"elvis was \"here\".\";

As for your solution,
EITHER (inside a PHP construct):

echo "<input type=\"hidden\" name=\"cdate\" value=\"".strftime("%m.%d.%Y" ,time())."\">";

OR (outside a PHP construct):

<input type="hidden" name="cdate" value="<? echo strftime("%m.%d.%Y" ,time()); ?>">