search exsplination please cheers.

[redarrow]

I have seen this a lot recently but i want to know is my way correct cheers.

All i need to know is it the correct way to format a search via the dropdown box.
[code]

<?php

database connnection

if(isset($_POST['submit'])){

$query="SELECT  * FROM album WHERE title like '%$titles%' and id='$id' ";
$result=mysql_quer($query);

while($record=mysql_fetch_assoc($result)){

echo $record['titles'];
}
}
?>
<form method="POST" action"">
<select name="titles">
<option value="hiphop">hiphop</option>
<option value="rb">r&b</option>
<option value="pop">pop</option>
<select>
<input type="submit" name="submit" value="seach titles">
<form>

[/code]

[tomfmason]

Looks fine to me. Does it work?

[redarrow]

cheers what i wont to know you see that i set the varable titles in the form.

know

you see the select statement where it says title like '%titles%' does that mean that tilte is know known as &titles& is that the concept please cheers.

[tomfmason]

I did this
[code=php:0]
$sql = mysql_query("SELECT * FROM `test` WHERE `email` LIKE '$email'") or die(mysql_error());
while ($rw = mysql_fetch_assoc($sql)) {
  echo 'The email address is <b>' . $rw['email'] . '</b><br />';
}[/code]

and it had the same result as this(which is like your example)

[code=php:0]
$sql = mysql_query("SELECT * FROM `test` WHERE `email` LIKE '%$email%'") or die(mysql_error());
while ($rw = mysql_fetch_assoc($sql)) {
  echo 'The email address is <b>' . $rw['email'] . '</b><br />';
}[/code]

So I guess it does work. I learn something new every day.