Re: adding the results of a number of calls to mysql_query
| From: | Russ Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: adding the results of a number of calls to mysql_query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12671@lists.php.net to get a copy of this message | ||
If I have the right end of the stick you want:
SELECT * FROM table99_98,table00_01 WHERE table99_98.foo='$bar' AND
table00_01.foo='$bar';
Russ
On Mon, 24 Sep 2001 10:50:02 +0100 "Cable, Christian" <c.cable@lancaster.ac.uk>
wrote:
> system:
> win NT4 server (IIS4, php4)
>
> Problem:
> I'm writing a web front end to an old in house access database with tables
> split over years
> (rather than the row having what year it's in)
>
> i.e.
>
> table00_01 table 99_98 etc etc
>
> ideally I'd like to run the same query against each table and the fetch rows
> form it the result of
> all the queries.
>
> any ideas on how I can do this ?
>
> with thanks
>
> Christian
>
>
> Christian Cable
> ICT Assistant
> Careers Service; Lancaster University
> Tel: (01524) 594072 Fax: (01524) 592072
> http://www.lancs.ac.uk/staff/cable/
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: r.j.michell@apu.ac.uk
w: www.apu.ac.uk/webteam
www.theruss.com
#-------------------------------------------------------#