check how many commas the variable containing the query has between [i]select[/i

Posted on 16th Feb 2014 07:03 pm by admin

Hi...

iv made an sql table that contains id number - name of sql query and an sql query.
The problem is that the table contains very different querys.

On the first page you choose a query from a drop down menu.
When this is done i check if the query contains date as a parametre. if yes a date picker is desplayed.
When a date is picked the report runs when submited.

i want the results of the query to be displayed in a html table and need help to figure out how many rows the sql query output needs.
For example
select firstname, lastname from users
needs two rows and
select firstname, lastname, birthdate from users
needs three rows.

my solution is maybe to check how many commas the variable containing the query has between select and from
any one know how this can be done in php or maybe have a simpler way of solving this?

Your Answer:

Login to answer

Other forums

How to use Ajax to verify data on a DB ?
Hello everyone, well i want to know how to check a value if it exists or not on a Data base and capt

does anyone know a php script to send mail using gmails/googles free smtp server
cause i heard u can do that but i dont know how

How to return to a previous page after running a PHP script
I'm having a bit of a melt down here because I think this should be really easy but can't work it ou

Standard DES encryption script?
Can anybody point me to a tutorial or a short script that shows how to encrypt some text with salt i

Career Change into SAP
Hai
I am sajesh ,did my diploma in Mechatronics i have a 4 years of experience in

DBCA Templates
Hi all,

I'm working on creating a template for DBCA, but can't find any documentation on the

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

Credit card verification
I have a client who wants to process credit card transactions from his web site rather than the goin