[PHP] Get data from 5 tables

[Osman Omar]

Hi,

How do I query to get data from 5 tables with same id. (id=1).

eg,

table1
id  data
1   blue
2   green

table2
id  data
1   yellow
3   green

table3
id  data
1   black
4   white

etc.

thanks


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Get data from 5 tables

[Osman Omar]

ok,

how do I know which data come from which table?



On Wed, 5 Mar 2003, olinux wrote:

> SELECT * FROM table1, table2, table3, table4
> WHERE id = 1 AND
> table1.id=table2.id AND
> table2.id=table3.id AND
> table3.id=table4.id AND
> etc.
> 
> 
> or you can use a JOIN
> http://www.mysql.com/doc/en/JOIN.html
> 
> 
> --- Osman Omar <[EMAIL PROTECTED]> wrote:
> > Hi,
> > 
> > How do I query to get data from 5 tables with same
> > id. (id=1).
> > 
> > eg,
> > 
> > table1
> > id  data
> > 1   blue
> > 2   green
> > 
> > table2
> > id  data
> > 1   yellow
> > 3   green
> > 
> > table3
> > id  data
> > 1   black
> > 4   white
> > 
> > etc.
> > 
> > thanks
> > 
> > 
> > -- 
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Compiling PHP on Linux

[Osman Omar]

Hi 

I try to compile php and got error message 
any idea? 


system: 
  Redhat 7.2 
  Apache 2.0.39 (for redhat 7.0 from apache website) 
  php 4.2.2 

error messages 
--- 
/bin/sh /usr/tmp/php-4.2.2/libtool --silent --mode=compile gcc  -I.
-I/usr/tmp/php-4.2.2/sapi/apache2filter -I/usr/tmp/php-4.2.2/main
-I/usr/tmp/php-4.2.2 -I/usr/local/apache2-39/include
-I/usr/tmp/php-4.2.2/Zend -I/usr/include/freetype2/freetype
-I/usr/tmp/gd-2.0.1/ -I/usr/tmp/php-4.2.2/ext/mysql/libmysql
-I/usr/tmp/php-4.2.2/ext/xml/expat  -D_REENTRANT
-I/usr/tmp/php-4.2.2/TSRM -DTHREAD=1 -g -O2 -pthread -DZTS -prefer-pic 
-c php_functions.c 
php_functions.c:93:27: missing binary operator before '!' 
make[3]: *** [php_functions.lo] Error 1 
make[3]: Leaving directory `/var/tmp/php-4.2.2/sapi/apache2filter' 
make[2]: *** [all-recursive] Error 1 
make[2]: Leaving directory `/var/tmp/php-4.2.2/sapi/apache2filter' 
make[1]: *** [all-recursive] Error 1 
make[1]: Leaving directory `/var/tmp/php-4.2.2/sapi' 
make: *** [all-recursive] Error 1 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php