Re: what the hell in this sql

> 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 > > > > 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' in your > > statement - again refere to the manual for instructions. > > > > George > > > > > >>-----Original Message----- > >>From: Alawi [mailto:albaity@yahoo.com] > >>Sent: 12 March 2003 11:07 am > >>To: php-general@lists.php.net > >>Subject: [PHP] what the hell in this sql > >> > >> > >> > >> SELECT * FROM cont_types, cont_data, cont_cats > >> WHERE cont_data.cont_id = $cont_id > >> AND cont_types.type_id = cont_data.type_id > >> AND cont_cats.cat_id = cont_data.cat_id > >> > >> > >>its not work , give me 1064 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >