RE: [PHP] what the hell in this sql
| From: | George Pitcher | Date: | Wed, 12 Mar 2003 11:14:13 +0000 |
| Subject: | RE: [PHP] what the hell in this sql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-139256@lists.php.net to get a copy of this message | ||
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' 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
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online