Afficher un message
Vieux 01/10/2007, 12h33   #7
Captain Paralytic
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Variable in Select statement?

On 1 Oct, 11:59, GarryJones <mor...@algonet.se> wrote:
> That looks okay, but I can not get it working...
>
> The declaration
>
> $ml_collect_ind='SELECT * FROM ml_lopp WHERE scfmnum=$scfchknum AND
> " . ((in_array(loppnum, $arr_motlopp)) . " =TRUE) ORDER BY sank,
> loppnum';
>
> Gives me the following echo
>
> SELECT * FROM ml_lopp WHERE scfmnum=$scfchknum AND " .
> ((in_array(loppnum, $arr_motlopp)) . " =TRUE) ORDER BY sank, loppnum
>
> It fails to find anything valid when the first "where" condition is
> correct and the other value is in the array,
>
> Is there something in the wrong place?
>
> All appreciated
>
> Garry Jones
> Sweden


You have been told once already to use double quotes. My suggestion
used double quotes. Your test used single quotes.

  Réponse avec citation
 
Page generated in 0,04492 seconds with 9 queries