Re: Strings between HTML, PHP and MySQL

2001-09-27 Thread Clive Smart
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=&ID2= > > When the variable ID2 is numeric, everything is OK and the query made by > PHP (su

Strings between HTML, PHP and MySQL

2001-09-27 Thread Mon PC
I'm sending variables in an HTML request such as http://localhost/connexion.php?ID1=&ID2= 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(