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