visa versa

quintin

i use this line to match customer with product

$query = "SELECT * FROM product WHERE price BETWEEN '".$_POST['minprice']."' AND '".$_POST['maxprice']."'";
$result = mysql_query($query);

how can i match the product with customer? Bearing in mind the customer has a min range and a max range and product a set price.so for example if a book cost $20 i want to pull all the customer that have $20 in their price range.

leatherback

Unsure what you are asking for & without any idea of how you have structured your tables.. retty much impossible to answer your question.

What have you tried, and what is the error you are getting?

quintin

i have a table called customers and one called products. the customer has to insert a minprice and a maxprice (so customers.minprice and customers.maxprice). The product table contains all products. what i want to do is if i click on a product i want to query the database so that all the customers that have that product price in their range comes up. i can do it the other way around when i have the client and search for all products in his price range. no error messages.

leatherback

So...
select * from customers where minpricce < $value and maxprice > $value

quintin

this returns nothing
$query = "SELECT * FROM customers WHERE price_min < '".$POST['price']."' AND price_max > '".$POST['price']."'";

bpat1434

If you're looking for users who have a price of $20, and you input 20, your SQL would look like:

SELECT *
FROM customers
WHERE price_min < '20'
  AND price_max > '20'

Notice something wrong? I think you should be doing:

$query = "SELECT *
FROM `customers`
WHERE `price_min` <= '" . $_POST['price'] . "'
  AND `price_max` >= '" . $_POST['price'] . "'";

Notice how 20 is now included in the result? So if someone has 20 as their min price, and 50 as their max, it should bring a result back.

As for not returning any results, are you 100% sure there are people listed at that price range you specify?

quintin

// some code $link= 
$query = "SELECT * FROM `customers` WHERE `price_min` <= '" . $_POST['price'] . "' 
  AND `price_max` >= '" . $_POST['price'] . "'"; 
  $result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";
mysql_free_result($result);
mysql_close($link);
?>

sql dump:
/*!40000 ALTER TABLE customers DISABLE KEYS /;
INSERT INTO contacts (username,price_max,price_min) VALUES
('quintin','100','10');
/!40000 ALTER TABLE customers ENABLE KEYS */;

this returns nothing why??

bpat1434

What is $_POST['price']? Is it $20.00, or 20, or 20.00?

quintin

20
i use this
<a href="matchclient.php?price=<?php echo urlencode($price); ?>" title="Match client">Match client</a> </td>

leatherback

Are the values in your table numbers (flt, int, double) or text (string) type? They should be numbers.
In your query you might need to remove the single quotes around values to ensure they are interpreted as numeric?

quintin

thanks