Re: Using variables withing a mysql query

Is the SQL quoted with single or double quotes?

Comment on Re: Using variables withing a mysql query

Replies are listed 'Best First'.
Re^2: Using variables withing a mysql query by sulfericacid (Deacon) on May 11, 2008 at 17:16 UTC
The statement is actually `my $data = qq( mysql_here );` [download] "Age is nothing more than an inaccurate number bestowed upon us at birth as just another means for others to judge and classify us" sulfericacid	[reply] [d/l]
Re^3: Using variables withing a mysql query by psini (Deacon) on May 11, 2008 at 19:43 UTC
This should be equivalent to double quotes. What do you get from a `print $data;` after your statement above? If you get exactly the query (`SELECT id, name, location FROM book WHERE 1 ORDER BY id DESC`) and it doesn't work as expected, perhaps you should post more of the surrounding code...	[reply] [d/l] [select]