date format mysql php

[robsgaming]

I have an existing piece of PHP code as follows:
$dateTime=MYSQL_RESULT($rs,$p,"orderDate")

I want the above statement to use mysql date format such as:
DATE_FORMAT(orderDate, '%m-%d-%Y %r')

How can I impliment this in the code above? Thanks in advance for any help.

[devinemke]

you have to do that in your query:

SELECT DATE_FORMAT(orderDate, '%m-%d-%Y %r') FROM table