Postgres Pro
Downloads
Home   >   mailing lists

Thread: multiple queries using PHP

multiple queries using PHP

From
Kevin Heflin
Date:
My original problem began with.. I have a category table
cat_id (unique id)
cat_title (category title)
mastercat (0 indicates a main category, otherwise points to another cat_id
       which indicates this category to be a subcategory)



I want to select cat_id and cat_title where mastercat=0
and at the same time would like to know whether these categories have any
other categories assigned to them via the mastercat.



I thought possibly my solution would be to select cat_id, cat_title into
temporary table where mastercat=0

then continue from there somehow.

Which lead me to my next question, which was how could I execute multiple
queries from within PHP ?





--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Production         | 333 Texas St #175    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

Re: multiple queries using PHP

From
"Bryan White"
Date:
>
> My original problem began with.. I have a category table
> cat_id (unique id)
> cat_title (category title)
> mastercat (0 indicates a main category, otherwise points to another cat_id
>    which indicates this category to be a subcategory)
>
>
>
> I want to select cat_id and cat_title where mastercat=0
> and at the same time would like to know whether these categories have any
> other categories assigned to them via the mastercat.
>
>
>
> I thought possibly my solution would be to select cat_id, cat_title into
> temporary table where mastercat=0
>
> then continue from there somehow.
>
> Which lead me to my next question, which was how could I execute multiple
> queries from within PHP ?

Its been a while since I worked with PHP but to my recolection it works like
all the other interfaces.  When you execute a statement it returns an object
that contains the result set.  Accessing that result set remains valid until
destroyed even if other results are returned in the interim.  If you keep
assinging the result object to the same variable then the assignment
implicitly destroys the previous result object.