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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
