On Tuesday 16 July 2002 22:40, Balaji Ankem wrote:
> Hi,
> I have an array of elements which are separated with the operator
> comma(,).
>
> ==================================================
> $array = implode(",", $checkb);
>
> echo $array.'\n';
>
> $result = mysql_query("DELETE FROM temp WHERE inv_tag IN
> ($array)") or die('Error in query'.mysql_error());
> ====================================================
>
>
> PTX526_P_1,SIM_1
>
> Error in query Unknown column 'PTX526_P_1' in 'where clause'.
Well I can't see what this has to do with PHP let alone the implode()
function.
The error quite clearly says "unknown column ..."
The proper use of IN requires that string values must be enclosed in either
single-quotes or double-quotes. Thus you need to make $array look like:
'PTX526_P_1','SIM_1'
or
"PTX526_P_1","SIM_1"
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
It is the wisdom of crocodiles, that shed tears when they would devour.
-- Francis Bacon
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
