[PHP] Re: SQL Hell

2004-04-22 Thread Lester Caine
Marc Greenstock wrote: I just downloaded and installed fire bird, looks interesting. But it's not for this current development. Perhaps later, not the project is 3/4 complete. Depends how you are accessing MySQL ;) Tell me how do you interface firebird with PHP? Interbase module - Firebird is a t

[PHP] Re: SQL Hell

2004-04-21 Thread Marc Greenstock
> Alternatively, use a better database :) > Firebird has had Triggers and Stored Procedures from the start. Using > these with PHP gives the power needed to update cross references without > having to build complex PHP code. > http://www.firebirdsql.org/ I just downloaded and installed fire bird,

[PHP] Re: SQL Hell

2004-04-21 Thread Red Wingate
Guess some guys don't get the point of this posting or have no idea what foreign keys are about. This problem can easily be solved using JOINs -- red Lester Caine wrote: Jason Barnett wrote: So far I've made multiple statements pulling out all the data and using PHP to formulate the informatio

[PHP] Re: SQL Hell

2004-04-21 Thread Lester Caine
Jason Barnett wrote: So far I've made multiple statements pulling out all the data and using PHP to formulate the information. But I know there is a better way using mysql. Only thing is I haven't got the faintest idea how to do it in one query and keep overheads low. I start to get lost when I

[PHP] Re: SQL Hell

2004-04-21 Thread Jason Barnett
So far I've made multiple statements pulling out all the data and using PHP to formulate the information. But I know there is a better way using mysql. Only thing is I haven't got the faintest idea how to do it in one query and keep overheads low. I start to get lost when I'm doing select statement