[PHP-DB] PHP on Pear

2009-10-15 Thread Vinay Kannan
Hello, I've been programming on PHP for almost a year now, many examples that I've gone through or some of the reference books that I've read and many websites which show examples of PHP pgramming seem to be using PEAR package, and I've never used PEAR or any other Package, I was wondering whats

Re: [PHP-DB] PHP on Pear

2009-10-15 Thread Chris
Vinay Kannan wrote: Hello, I've been programming on PHP for almost a year now, many examples that I've gone through or some of the reference books that I've read and many websites which show examples of PHP pgramming seem to be using PEAR package, and I've never used PEAR or any other Package,

[PHP-DB] Search

2009-10-15 Thread Emiliano Boragina
Hello I’m using this code to a search: $sql = SELECT empresas.id, empresas.nombre, rubros.id, rubros.nombre, cupones.empresa, cupones.rubro, cupones.titulo, cupones.descripcion FROM cupones INNER JOIN empresas INNER JOIN rubros ON (empresas.id = cupones.empresa OR rubros.id = cupones.rubro) WHERE

[PHP-DB] to Vinay Kannan

2009-10-15 Thread E本万利
pear supports lots of strong classes for you . for example , pear mdb2 class can connect to and work with several different types of databases easily, as same as pecl pdo extension. but i prefer writing class myself (some simple classes), it is very interesting ! BitPart I've been

Re: [PHP-DB] Search

2009-10-15 Thread Jack van Zanen
For starters try this FROM cupones INNER JOIN empresas ON (empresas.id =cupones.empresa) INNER JOIN rubros ON (rubros.id = cupones.rubro) I am not sure about the join criteria you have given us, they look a bit suss to me. What is the field/are the fields that join the tables? I would imagine