Try SELECT my_table WHERE ident1 = $id1, ident2='$id2';
Note the single quotes around $id2
Clive
Mon PC wrote:
>
> I'm sending variables in an HTML request such as
> http://localhost/connexion.php?ID1=<value1>&ID2=<value2>
>
> When the variable ID2 is numeric, everything is OK and the query made by
> PHP (such as SELECT my_table WHERE ident1 = $id1, ident2=$id2;) works very
> well.
> The column ident2 in mySQL is defined as a VARCHAR(30).
> When I give in HTML an alphanumerical value to ID2, (ie ABC) I get an
> error from MySQL.
> It seems that PHP only accepts to receive numeric variables, and that he
> creates various errors (in MySQL) as soon as a variable is not numeric : my
> PHP scripts work fine as long as the value are numeric and seem not to
> accept alphanumeric values
> Do I have to indicate to PHP that a variable is alphanumeric (and not
> numeric) ?
>
> Thanks for your help.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread86498@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-clive=hardrive.co.za@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
