>  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'.
>

Use quotes around string..otherwise MySQL things your telling it a column
name.

$array = "'" . implode("','",$checkb) . "'";

---John Holmes...


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to