[PHP] PHP SQL Builder with JOIN support

2006-12-06 Thread Kris Leech
Does anyone know of a PHP class/function(s) which will generate SQL with support for JOIN's to other tables. I have used SQL Query Builder by David Regla Demaree, which is great for simple SQL but lacks support for JOIN's. Many thanks in advance, Kris. -- PHP General Mailing List (http://www

[PHP] Join table with clashing fieldnames

2006-11-08 Thread Kris Leech
I have an SQL query which has a simple join, this works and is fine the fields from the secondary table are added to the returned array. But what happens if I add another JOIN to a table which has fields which are the same name? Is there any way to have PHP prefix the key's (fieldnames) of the

Re: [PHP] 301 redirect returning 302 instead

2006-11-01 Thread Kris Leech
I think Stut is right, you only need the one header! Stut wrote: [EMAIL PROTECTED] wrote: Having a problem here trying to redirect some old pages. I've recently noticed using a server header check that my 301 redirects in PHP are returning 302 instead. I'm using the following code: header(