?Multiple SQL Selects

Joined: 12 Oct 2005 Posts: 42

It would be nice if you could define multiple sql selects and call the sql you wihs to run in your script call.

IE: In the config define- SQL_1="Select name from table a...."
SQL_2="Select number from table b"

Then call the script and pass the sql you want executed like:
........&sql_exec=SQL_1

Make sense? Any plans?

Joined: 24 Feb 2005 Posts: 1569

phpdev wrote:

It would be nice if you could define multiple sql selects and call the sql you wihs to run in your script call.

IE: In the config define- SQL_1="Select name from table a...."
SQL_2="Select number from table b"

Then call the script and pass the sql you want executed like:
........&sql_exec=SQL_1

Make sense? Any plans?

No it doesn't make sense. Can you give an exact example and reasons why using JOIN or UNION won't work.

Jim

Joined: 12 Oct 2005 Posts: 42

Because not all tables are relational for one. Two, what if you are running multiple databses, and want a feed from each? That help?

Joined: 24 Feb 2005 Posts: 1569

phpdev wrote:

Because not all tables are relational for one. Two, what if you are running multiple databses, and want a feed from each? That help?

If the two tables are not relational how do you properly use the items from the different tables so they match up properly?

As far as multiple databases, you could create a feed from each and then merge them using rssMesh.php

Jim

Joined: 12 Oct 2005 Posts: 42

Thanks Jim for the reply. I guess what I was thinking is, let's say you want to pull data for:

- Total number of users on your site
- Total number of X on your site (x being something else)

Assuming the data is in 2 different tables, and the tables are not relational in the databse they are stored or the tables are in different databases, I just see value in being able to define multiple selects and telling the script which one to run, so the feed will display only the data you want from the config file where they would be kept.