Jump to content


Photo

search exsplination please cheers.


  • Please log in to reply
3 replies to this topic

#1 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 16 August 2006 - 09:32 AM

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.

<?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>



Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#2 tomfmason

tomfmason
  • Staff Alumni
  • Advanced Member
  • 1,696 posts
  • Locationstealing your wifi

Posted 16 August 2006 - 09:54 AM

Looks fine to me. Does it work?

Traveling East in search of instruction, and West to propagate the knowledge I have had gained.

current projects: pokersource

My Blog | My Pastebin | PHP Validation class | Backtrack linux


#3 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 16 August 2006 - 09:57 AM

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.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#4 tomfmason

tomfmason
  • Staff Alumni
  • Advanced Member
  • 1,696 posts
  • Locationstealing your wifi

Posted 16 August 2006 - 10:26 AM

I did this
$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 />';
}

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

$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 />';
}

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

Traveling East in search of instruction, and West to propagate the knowledge I have had gained.

current projects: pokersource

My Blog | My Pastebin | PHP Validation class | Backtrack linux





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users