search issue

terryo · #1 08-22-2006, 12:42 PM

Hi

When my users register they fill out the county they live in. They can then go and search for suppliers in that county, or (for flexibility) search on other counties. The problem I have is that I can get my drop down to display the county that the user lives in but then I need to search for suppliers against that who are obviously in a different table. It is the code that searches for the supplier that is not working (no errors).

My code look slike so:

PHP Code:
$id = $_SESSION['username'];
$query1 = "select * from users where username='$id'";

//now we pass the query to the database
$result1=mysql_query($query1) or die("Could not get data.".mysql_error());

//get the first (and only) row from the result
$row = mysql_fetch_array($result1, MYSQL_ASSOC);

$county=$row['county'];
?>

<html>
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

prestor · #2 08-22-2006, 12:45 PM

PHP Code:
$numrows=mysql_num_rows($numresults);
$row = mysql_fetch_array($numresults, MYSQL_ASSOC);

what is the logic behind this?

in first line you are fetching results as rows and in the second line as array.

i think you should remove one of them and your code will work. also check your $country is accessible in this query. Always print your queries to see their actual shape it helps to remove errors e.g blank variables without values or syntax errors and typos.. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --