Re: joining tables in postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



At 04:13 PM 9/29/2005, redhat wrote:
anyone know of any good tutorials on simple joining of tables in
Postgres using PHP?  I did some Googling and didn't find anything
satisfactory.
thanks,
Doug

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

You mean like this, after establishing the connection ...

$sql = "SELECT childname, childinitial, surname FROM children, parent WHERE children.familykey = parent.familykey";

$result = pg_query( $sql);

and then process the results using the appropriate pg_ commands. See the manual.

But the join is done with the SQL.

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux