A suggestion. I don't know what language you're using but try printing
$quary to the screen before it is passed to mysql. If @inc_re is an array,
as you say, then in a lot of other languages, you're next line would be an
illegal statement. Even the first statement looks incorrect but I don't
know. Shouldn't the strings be quoted? Why do you want to create an array
in the first place? Isn't it easier with just a single string? As far as I
see it, your SQL statement is how I would see it and of course it would
result in an error. Check the manual for the language you're using for
correct syntax.
----- Original Message -----
From: "David Jacobowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 9:41
Subject: Having trouble to use array in SELECT statement.
> Hello,
>
> I have constructed an array using my table field names and trying to pass
> that array in the select statement.
>
> @inc_re = ( Hotels, Asian_Real_Estate, Smart_Buildings, Real_Estate,
> Senior_Living_Homes );
>
> $quary = "SELECT @inc_re FROM incu_real_estate LIMIT 1";
>
> But I am getting following error.
>
> ..]$./test.pl
> In string, @inc_sf now must be written as \@inc_sf at ./test.pl line 15,
> near "SELECT
> @inc_sf"
>
> I have added a \ infront of the array but the quary doesn't return any
> thing.
>
> Any suggestions?
>
> Thanks for any help.
>
> David.
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php