Re: MySQL

[Wiggins d'Anconia]

This should have been interpolated, and you shouldn't see the join?? Maybe spaces are needed between the dots.

$query = "SELECT ad_id FROM help_wanted WHERE ad_id
in(" . join(',', @id_set) . ")";

Should print to be:

SELECT ad_id FROM help_wanted WHERE ad_id in(24, 23, 22)

Where the list inside of the 'in' will be the numbers from the @id_set.

http://danconia.org

Mariusz wrote:

Thank you for a reply.
I did as you advised, my printed statement after executing the script looked
like this:
SELECT ad_id FROM help_wanted WHERE ad_id in(".join(',', 24 23 22).")

but it didn't select any records. I got the result as 0E0 for number of
found ones??

Mariusz

----- Original Message -----
From: "George Schlossnagle" <[EMAIL PROTECTED]>
To: "Mariusz" <[EMAIL PROTECTED]>
Cc: "perl" <[EMAIL PROTECTED]>
Sent: Saturday, November 23, 2002 9:00 PM
Subject: Re: MySQL

the list in your statement needs commas


$query = "SELECT ad_id, text_extra, life FROM help_wanted WHERE ad_id
in(".join(',', @id_set).")";


On Saturday, November 23, 2002, at 08:30 PM, Mariusz wrote:

I sent the following mysql query and got an error:(

SELECT ad_id, text_extra, life FROM help_wanted WHERE ad_id in(@id_set)

It prints correctly as:
SELECT ad_id, text_extra, life FROM help_wanted WHERE ad_id in(20 19
14)

but the whole idea doesn't work; what am I missing?

Mariusz

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]