recordset and strings

[metrostars]

Hey,

I have this query in a recordset

SELECT DATE_FORMAT(NOW(),'%d/%m/%Y %I:%i %p') FROM users

When i click OK it appears as normal, but then when i try to echo this in the page, it changes to DATE_FORMAT(NOW() AND another variable called string.

How do I either stop string appearing or get string and the 1st variable to echo on the page?

Thanks.

[kenrbnsn]

Please post the code you're having problems with. And try to explain your problem better.

Ken