2. PHPRunner General questions
  3. Blank Tables to Run Complex Queries
This topic is locked

Blank Tables to Run Complex Queries

 		4/15/2005 21:10:10
PHPRunner General questions
J
 jasonm author

Very Very Impressive Software....
One feature i would like to see a query builder that was built in and that you could see results from
Guess i would put it before step 3.
OK i have an interesting one here..
I have written some very complex queries that work... and I would like to use them with your software.
Question is Can i Create a Blank table on mysql server.
When I get to Step 4 Edit SQL can I Plant my sql in there

to get it to work..
And yes i do use all the tables i select
I'm trying to Create Pages special Pages...
Example

Different Pages with there data and price based on special queries

would need to create about 10 of them that are query based.
Thanks in Advance
501169 4/15/2005

OK I tried it and it doesnt work......
Do you have a workaround for it?
Sergey Kornilov admin 4/16/2005

Hi,
if you use custom SQL query make sure syntax is correct before copy&paste it into PHPRunner.
If this doesn't help you can post your query here.
Also I need to know what is the error that you getting.
J
 		jasonm author 4/17/2005

OK Here is a Simple Script i am trying to use
SELECT DISTINCT

`end users`.CustomerName,

assets.MasterCusID,

assets.VOIDED,

assets.EOM,

assets.`Care EOM`

FROM

`end users`

INNER JOIN assets ON (`end users`.MasterCuSID = assets.MasterCusID)

WHERE

(assets.VOIDED = 0) AND

(assets.EOM <= (Now() + 30)) AND

(assets.`Care EOM` <= (Now() + 30))

ORDER BY

assets.`Care EOM`
This Works...
Now i would like to build

the other various of this i would add a couple of more fields from 2 or 3 more tables.
I dont get an error... I just dont see the fields...

Only the 1 Field in a blank database... Not the Fields from the query..
Thanks for your help
Sergey Kornilov admin 4/26/2005

Jason,
please send SQL query that works in MySQL but doesn't work in PHPRunner.