How to search a databae from a javascript menu?

wannasub

Hi guys doe anyone know how i would go about searching my mysql database by the location of users from my javascript dropdown menu?

Please goto www.adultinfo4u.co.uk/new/index.php

goto the menu and hover over 'escorts' link then down to 'look for an escort' the menu will then open out with the locations of which the website covers how do i go about pulling out just the users/escorts for that area?

Thanks

Aaron

Arc

well in the link on that menu item you would point it to a php file and pass the arguments thru the URL

<a Href = "display.php?country=London">London</a>

Then in your php page you would do and sql statement like

SELECT * FROM tblUsers WHERE COuntry ='$country'

wannasub

hi thanks for your help its nearly working im just getting this error

Warning: Supplied argument is not a valid MySQL result resource...on line 15

ive added the code and marked line 15

<?php
include "common.php";
$link = mysql_connect("$server", "$username", "$password") 
or die("Could not connect"); 
mysql_select_db("$db") or die("Could not select database"); 
if (empty($page)) $page = "";
if (empty($search)) $search = "";
if ($page == search) {
if ($search == 1) {
$result = mysql_query("SELECT * FROM user WHERE location = '$location'");
} 
echo "Bad Search";
}
echo "<table align=center><tr><td><font face=arial size=2>Escort</td><td><font face=arial size=2></td><td><font face=arial size=2>City</td><td><font face=arial size=2>Age</td></tr>";
(line 15) while ($i = mysql_fetch_array($result)) {
echo "<tr><td><font face=arial size=2><a href=view.php?id=".$i[id].">".$i[user]."</a></td><td><font face=arial size=2>".$i[location]."</td><td><font face=arial size=2>".$i[city]."</td><td><font face=arial size=2>".$i[age]."</td></tr>";
}
echo "</table>";

?>