on 9/5/01 9:22 PM, Eric J Schwinder at [EMAIL PROTECTED] wrote:

> thanks so much, I've gotten a lot from that page of the mySQL
> documentation...

Here's another one for you:


<quote> A SELECT expression may be given an alias using AS. </quote>

So instead of:

> SELECT DATE_FORMAT(date,'%m/%d/%y') FROM ...

You could do this:

SELECT DATE_FORMAT(date,'%m/%d/%y') AS mydate FROM ...

> I tried using that query, but then I didn't know how to get the formatted
> date out of the array field in my PRINTF lines (what goes in the ["  "]?)

Using the above code, the value you're looking for is mydate, i.e.,

echo $myrow['mydate'];



Paul Burney

Paul Burney
Webmaster && Open Source Developer
(310) 825-8365

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to