Re: [PHP] what the hell in this sql

2003-03-12 Thread CPT John W. Holmes
> Nevertheless the $ looks weard ... Yeah, it looks weird, too. :) You're probably getting an error because $cont_id doesn't have a value. Show the SQL in context and do some debugging... ---John Holmes... > > This isn't a php question and should be directed at a sql list or to php-db > > > > H

Re: [PHP] what the hell in this sql

2003-03-12 Thread Martin Mandl
Nevertheless the $ looks weard ... George Pitcher wrote: Firstly, This isn't a php question and should be directed at a sql list or to php-db Have you lokked at erro 1064 in the manual? What does it say? There are several things that you should do before coming to the list with a problem. Witho

RE: [PHP] what the hell in this sql

2003-03-12 Thread George Pitcher
Firstly, This isn't a php question and should be directed at a sql list or to php-db Have you lokked at erro 1064 in the manual? What does it say? There are several things that you should do before coming to the list with a problem. Without checking I suspect that you need to specify a 'JOIN' i