[PHP-DB] help width sql

hi I have a problem whith inforcing the result of a selekect query, here is my tables and the query: I create this 4 tables: CREATE TABLE a ( a_id SERIAL PRIMARY KEY, a_name text ); CREATE TABLE b ( b_id SERIAL PRIMARY KEY, b_price INT2 ); CREATE TABLE c ( c_id SERIAL PRIMARY KEY, a_id

[PHP-DB] help in sql - postgresql

Hi, I need some help in sql - postgresql: I create this 4 tables: CREATE TABLE a ( a_id SERIAL PRIMARY KEY, a_name text ); CREATE TABLE b ( b_id SERIAL PRIMARY KEY, b_price INT2 ); CREATE TABLE c ( c_id SERIAL PRIMARY KEY, a_id INT4 REFERENCES a ON UPDATE CASCADE ON DELETE CASCADE, b_id INT4

Re: [PHP-DB] help in sql - postgresql

suad wrote: Hi, I need some help in sql - postgresql: snip Yay a postgres question! :D hee hee *The question is* : how can I force that the result of the col payed to be zerro 0 insted of nothing (NULL) and the order will be in way that the zerro's values comes first. and the result will

Re: [PHP-DB] help in sql - postgresql

Hi, Thanks a lot, That exactly wat I need :) Suad Chris wrote: suad wrote: Hi, I need some help in sql - postgresql: snip Yay a postgres question! :D hee hee *The question is* : how can I force that the result of the col payed to be zerro 0 insted of nothing (NULL) and the order

RE: [PHP-DB] multi-table insert

Thanks Chris! Appreciate the help! Eustace -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Monday, May 01, 2006 3:23 AM To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Subject: Re: [PHP-DB] multi-table insert Eustace wrote: Hello everybody! I am very much a newbie in