Yes i review manual many times without success
-----Messaggio originale-----
Da: Rick Emery [mailto:[EMAIL PROTECTED]]
Inviato: mercoledý 13 marzo 2002 16.52
A: 'Riccardi Moreno'; Php List; Mysql List
Oggetto: RE: [PHP-DB] Delete problem

MySQL does not currently support sub-selects.

The manual says:
    [WHERE where_definition]
    [ORDER BY ...]
    [LIMIT rows]

Did you review the manual first?

-----Original Message-----
From: Riccardi Moreno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9:48 AM
To: Php List; Mysql List
Subject: [PHP-DB] Delete problem

Hi all,

I'm trying to delete records with this query on php program:
delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
ID_GROUP = '$group')
I use it on MSSQL and work fine but on mysql don't work, there's some other
query that make the same result on mysql
Thank's all

- Moreno Riccardi


PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to