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