Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-12 Thread John Lim
Hi Hans, The case-changing code for postgresql is in the postgres7 driver. Regards, John "Hans Lellelid" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi John, > > John Lim wrote: >>>/abstract/ stuff. For example, ADOdb would completely fail to be >>>portable accross database

Re: [PHP-DB] One to Many Select Statement

2004-09-12 Thread Gerard Samuel
John Holmes wrote: Gerard Samuel wrote: Looking for clarification... Say that I have a user table and group table -> -- user table -- id username 1 foo -- group table -- id user_id group_name 1 1group_1 2 1group_2 Would this be the proper way to construct a select statement

Re: [PHP-DB] One to Many Select Statement

2004-09-12 Thread John Holmes
Gerard Samuel wrote: Looking for clarification... Say that I have a user table and group table -> -- user table -- id username 1 foo -- group table -- id user_id group_name 1 1group_1 2 1group_2 Would this be the proper way to construct a select statement for this -> select

[PHP-DB] One to Many Select Statement

2004-09-12 Thread Gerard Samuel
Looking for clarification... Say that I have a user table and group table -> -- user table -- id username 1 foo -- group table -- id user_id group_name 1 1group_1 2 1group_2 Would this be the proper way to construct a select statement for this -> select u.username, g.group_

[PHP-DB] Data sorting with Turkish character

2004-09-12 Thread Mazhar Bilen
Hi everybody, I want to select all data from a mysql table ordered by baslik as ascending. It is ok for English alphabet. But I want to sort this data according to Turkish alphabet. mysql_query("SELECT id, baslik FROM makaletb WHERE kategori='K' and onay='e' ORDER BY baslik ASC"); What need to d