problem with a mysql query with data from a form
| From: | Vincent Fievet | Date: | Fri, 29 Aug 2003 06:25:27 +0000 |
| Subject: | problem with a mysql query with data from a form | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-161111@lists.php.net to get a copy of this message | ||
-----Message d'origine-----
De : Vincent Fievet
Envoyé : mercredi 27 août 2003 10:44
À : 'php-general@lists.php.net'
Objet : problem with a mysql query with data from a form
hi,
i am a newbie to php and mysql, i run the easyphp kit ( php 4.2.0, Mysql 3.23.49 and phpmyadmin
2.2.6 )
i would like to use a select * from mytable where my variable like '%$mystring%'
where $mystring come from a form
<form action="show.php" method="post" name="form1"
target="_blank">
<table align="left">
<tr> '%Mike %
<td width="98"><h3>Communication Impliquant :</h3></td>
<td width="144" valign="middle"> <font
color="#FFFFCC">
<select name="det" size="5" id="det">
<option value="PC" selected>PC</option>
<option value="echo">echo</option>
...
<option value="H10 Tango">H10 Tango</option>
</select>
<select name="den" size="1" id="den">
<option value=" " selected> </option>
<option value="1">1</option>
...
<option value="10">10</option>
</select>
</font></td>
<td width="153"> <input name="delibre" type="text"
id="delibre" maxlength="20"></td>
<td width="39"> <input type="submit" name="Submit"
value="Ok"> </td>
so ,after choosing "PC" in the form, in show.php i do a
$sql="SELECT * FROM journal WHERE a like '% $det%' OR de like '%$det%'
order by dateheure desc";
echo $sql;
and what i get is :
SELECT * FROM journal WHERE a like '%PC %' OR de like '%PC %' order by dateheure
desc
( note the blank space at the end of PC )
whitch doesnt get any record since the word i am looking is "PC" and not "PC "
i used a "like" because the request should be used to find record with "PC 1"
"PC" "PC 9" "PC12" ...
any ideas ?
Thanx
Vincent Fievet