count only commas outside parenteses

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

I have a sql table containing
id - query - query name
the first page contains a drop down menu of all the query names. When chosen the user is sent to a page that prints the result of the query in a html table.

Now i nees to find how many rows the table should have.

This counts how many rows i need in the table:

$parts=explode(' FROM ',$query);
$count=explode(",", $parts[0]);
$result=count($count);

But the problem is that here i explode by commas but the query also contains commas like this: substring (***,19,10) as Part1

My question is how do i count only commas outside these parenteses.

something like this:

$var=0;
start counting commas in parts[0],
when ( accures increase $var to 1,
if $var = 1 dont count commas,
but when ) accures set $var to 0,
and start counting again

The reason why im making it this way is that it's suppose to be possible to just add a query to the sql table no matter how many rows this query needs in output.

Any ideas?

Your Answer:

Login to answer

Other forums

Facebook status update API
Hello,

So, I'm trying to create my first Facebook application with PHP.

Basic ideas fo

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H

Ajax Issues - Update Panel / Timer. Intellisense doesn't know about them
Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'. That is wha

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext