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

PHP/PKI
I am trying to set up a web application that uses pki. does anyone have a good tutorial to set this

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so

PHP, Arrays & A Lot Of Confusion
I've been doing basic PHP work on sites for a few years now, but I've never been tempted to learn ho

Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorad

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

Calculus Help (and by help I mean homework)
Hrmmm, I hate posting about math homework, partly because it's homework, and partly because I hate w

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther