Posted by The Eclectic Electric on 12/06/06 11:46

"fedor" <fedo2@dds.nl> wrote in message
news:PfadneXQC55hFuvYnZ2dnUVZ8s6dnZ2d@fiberworld.nl...
> x.tardits@gmail.com wrote:
>
>> Hi,
>>
>> Firstly when you build a SQL query, You can update a NumberCasted
>> column using (column_name = 12345) but StringCasted column values in
>> update (and even in reading) must be quoted (column_name = 'abcd'). If
>> you don't do that your string ('b1' in your case) will be interpreted
>> as an expression that's probably the reason of your bug.
>>
>> secondly try to use $_POST with quoted indexes, in this case it seam to
>> work as you did but you will encounter furthers problems with that...
>>
>> Good Luck and sorry for my "frenchie english"
>>
>> Xabi
>>
>
> Xabi,
>
> Thank you very much for your answer.
> The nucleos of this problem is this peace of code
> where size_key = $_POST[size_key]";
>
> I tried it like
> where size_key = '$_POST[size_key]'";
> and like this
> where size_key = \"$_POST[size_key]\"";
> It generated only other errors.
>
> The last thing you wrote "use $_POST with quoted indexes" I do not
> understand.
>
> Your English is better than most foreigners,
> thank you again and good luck


Have you tried it this way?

$query = "SELECT * WHERE size_key = '".$_POST['size_key']."'";

+e

[Back to original message]