2. PHPRunner General questions
  3. Query Designer Unavailable
This topic is locked

Query Designer Unavailable

 		10/7/2008 11:12:23 AM
PHPRunner General questions
L
 larsonsc author

I was wondering if anyone else has seen this and if you know what might be flawed in my query to resolve it. The query returns the right results on the "Results" tab so it would seem that the query is structured correctly. The issue started when I added the "DATEDIFF" statement into the query. Perhaps PHPR is not a fan of the DATEDIFF? I'm at a loss on this, although I can work around it so if there is no solution, it's not a showstopper for my project.
Thanks for any help anyone can offer.
T
 		tototoo 10/7/2008

SELECT is part of the SQL language. DATEDIFF is PHP. You can't just mix them.
L
 		larsonsc author 10/7/2008

I got the DATEDIFF function from the MySQL site, so I figured it was fair game.
http://dev.mysql.com/doc/refman/5.0/en/dat...nction_datediff
T
 		tototoo 10/7/2008

I got the DATEDIFF function from the MySQL site, so I figured it was fair game.

http://dev.mysql.com/doc/refman/5.0/en/dat...nction_datediff


You're right. I stand corrected.
Sergey Kornilov admin 10/7/2008

larsonsc,
please send your database and project file to support@xlinesoft.com