Hi, i created a page with some radio buttons that each of them contains a certain number which i send them to action page for searching among the numbers that i inserted inside my table in data base.

but the question is here that i wanna select with some different methods like these samples below :

include "../db.php"; $search=$_POST['radio']; //this is my radio value
<?php $sql2=mysql_query("SELECT * FROM `table1` where price1<='$search' ");  

//price1 is one of the columns in my table that contains some different numbers 

$row=mysql_fetch_array($sql2); $product=$row['key']; if($product=='') { echo "404"; } else { ?>
$imgRow = '<tr>';
$idRow = '<tr>';
$nn=6; //Number of items, we split this later
$s=mysql_query("SELECT * FROM `table1` where  price1 <= '$search' ");
//$cc : Number of pages
$ss=@$_REQUEST['ss']; //Start position (eg: 6)
$other_tables = "";
if($ss=="" || $ss==null){
	$ss = 0; //Set to zero because it is incremented later
echo "<table border=\"0\" align=\"center\" style=\"text-align:center;\">";
$sql=mysql_query("SELECT * FROM `table1` where price1 <= '$search' ORDER BY `id` DESC LIMIT $ss,$nn");
$inc = 0;
	if($inc == 0){
		$imgRow .= "<tr>";
		$idRow .= "<tr>";
	$imgRow .= "<td title=\"مشاهده جزئیات محصول\"><a href=\"showproducts1-details.php?id=$key\" target=\"_self\" ><img src=\"../admin/products/productimages1/$img\" width=\"270\" height=\"330\" border=\"1\" /></a></td>";
	$idRow .= "<td><a href=\"showproducts1-details.php?id=$key\">$id</a></td>";
	if($inc == 3 || $inc == 6 || $inc == mysql_num_rows($sql)){
		//Display Table
		echo $imgRow."</tr>";
		echo $idRow."</tr>";
		echo "</table>";
        echo "<br>";echo "<br>";echo "<br>";
		//To remove extra table
		if(mysql_num_rows($sql) <= 3){
			$inc = 7;
		if($inc == 3){
			echo "<table border=\"0\" align=\"center\" style=\"text-align:center;\">";
			$imgRow = "<tr>";
			$idRow = "<tr>";
echo "</table>";
echo "<br>";
?>  </td>

<table width="820" border="0" align="center" cellpadding="0" cellspacing="0">
echo"page numbers : ";
	echo"<a href=\"searchproducts1-details.php?ss=$j\">$i</a>";

so, i don't know what i missed in my query ?

$sql2=mysql_query("SELECT * FROM `table1` where price1<='$search' ");

i should mentioned that i inserted correct numbers for testing.

and what about the query if i m going to search among the 100000 and 200000 ?

$s=mysql_query("SELECT * FROM `table1` where  price1>200000&&price1<300000 ");

$s=mysql_query("SELECT * FROM `table1` where  price1>=300000 ");
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.