PHP - Searching A Range When Only High/low In Database

I have read that i can search for a number within a mysql database using BETWEEN

i.e: SELECT  * FROM `table_name` WHERE `field_name` BETWEEN 99 AND 200

How would i do this with the code below?


<?php
$salary = explode(":", $_GET['salary_to']);
 }
$types[] = (isset($_GET['salary_to']) && strlen(trim($_GET['salary_to'])) > 0) ?
     "`salary_from` LIKE '%". mysql_real_escape_string(trim($salary[0])) ."%' AND `salary_to` LIKE '%". mysql_real_escape_string(trim($salary[1])) ."%'" : ''; 
?>


Thanks for any help

i'm stuck with searching on age query

i let users register their date of birth (they give in DAY, MONTH, YEAR)  --> column 3

Name    CalcAge    Timestamp    Timestamp calculated for query
Person 1   21   659948401   642754801
Person 2   39   91954801                  83746801
Person 3   15   849337201   848991601
Person 4   33   281257201   281170801
Person 5   23   596876401   600850801
Person 6   87   -1422809999   -1422723599

I came up with the following query to search between a minimum and maximum age (using AJAX):

Code: [Select]
//user enters a minimum and/ or max age - getting the querystring from URL (ajax)
$minAge = $_GET['minAge'];
$maxAge = $_GET['maxAge'];

//age to unix timestamp
function agetostamp($age){
$gebjaar = date(Y) - $age;
$timestamp = mktime (0,0,1,0,0,$gebjaar);
return $timestamp;
}

//making getvariables timestamp in order to compare with database
if (isset ($minAge)){
$minAge = agetostamp($minAge);
}
if (isset ($maxAge)){
$maxAge = agetostamp($maxAge);
}

//building query
query = "SELECT * FROM respondenten WHERE geslacht = '$sex'";

if(is_numeric($minAge) && $minAge > 0)
$query .= " AND geboortedatum <= '$minAge'";
 else if (is_numeric($minAge))
$query .= " AND geboortedatum >= '$minAge'";

if(is_numeric($maxAge) && $maxAge > 0)
$query .= " AND geboortedatum <= '$maxAge'";
 else if (is_numeric($minAge))
$query .= " AND geboortedatum >= '$maxAge'";
I encouter a lot of troubles working like this:

1) if i leave out the part of maxAge (so i only allow to set a minimum age in the search box) it works except for the fact that if i set the minimum age to 23, person 5 will not be included since 596876401 < 600850801 even though she is 23 and should be included.

2) if i add the part of also searching on a max age, i don't get any results

I know that remark 1 probably has to do with the fact that im using date(Y) - $age and that people that are already born this year will have a timestamp higher than the one calculated in the query and visa versa.

conclusion: i don't think i'm going to get out of this so i'm hoping sombody can help me, telling me how to build a query for selecting on age range

so ik you cna get a search box to search items or text in a database, but what i want to know is how to manually insert text and images into it example

image (imagine its an image) text name - text price

how would i do this?

i'm working on a project that stores records of architecture and architects.

What i have to do is create a way for users to search the records in a simple way.

The user can search by Building name, Architect, Location, Date it was built, Building type and architecture style.

Currently i can only search properly by building name, date, type and style. If i add architect to the search query the records screw up when i try to search for the other fields individually..so for example if i add the architect to the query and try to only search by building name the results get screwed up and it displays more results that don't have nothing in comon rather than just display one result which would be the building name

Like i said this only happens if i add the "architect" to the query


Since the architect, location, date, type and style are stored in different tables i search for them first and get the id. Once i've grabbed the ID for those fields i do the actual search to get the buildings that match those records by ID

In the actual query i use the OR statement to search all 5 fields regardless if the user left them empty. So if th user only searches for a building name it the query will basically search for the buildingID OR the rest of the fields as well.

I hope someone here can help me figure out why when i add the architect field to the query the results get screwed up.

I have the code displayed below:

<?php

if(isset($_POST['search'])){

$building  = mysql_real_escape_string($_POST['building']);

$architect = stringForUrl($_POST['architect']);

$date = mysql_real_escape_string($_POST['date']);

$style = mysql_real_escape_string($_POST['style']);

$type = mysql_real_escape_string($_POST['type']);

$find_building = mysql_query("SELECT * FROM points WHERE name LIKE '$building'") or die(mysql_error());

$tmp_building = mysql_fetch_assoc($find_building);

$buildingID = $tmp_building['id'];

$find_architect = mysql_query("SELECT * FROM architects WHERE full_name LIKE '$architect'") or die(mysql_error());

$tmp_architect = mysql_fetch_assoc($find_architect);

$architectID = $tmp_architect['id'];

$find_style = mysql_query("SELECT * FROM styles WHERE name LIKE '$style'") or die(mysql_error());

$tmp_style = mysql_fetch_assoc($find_style);

$styleID = $tmp_style['id'];

$find_type = mysql_query("SELECT * FROM types WHERE name LIKE '$type'") or die(mysql_error());

$tmp_type = mysql_fetch_assoc($find_type);

$typeID = $tmp_type['id'];

}

?>
<?php

if(isset($_POST['search'])){

$session_arch_id = $_SESSION['architect_id'];
//query that does the actual search 
$get_search_points = mysql_query("SELECT * FROM points WHERE id='$buildingID' OR style_id='$styleID' OR type_id='$typeID'  OR architect_id='$architectID' OR date='$date' ORDER BY name") or die(mysql_error());

$num_search_points = mysql_num_rows($get_search_points);

print($get_search_points);

?>
                            <h3>Architecure on the map</h3>
                            <span id="num_buildings">Showing <?php echo $num_search_points; ?> buildings</span>
                            <table width="605" cellspacing="0" cellpadding="5" border="0" id="wam_results-tbl">
                            

<tr class="search_headings">
                                

<td width="156">Building Name</td>
                                    <td width="114">Architect</td>
                                    <td width="45">Date</td>
                                    <td width="144">Building Type</td>
                                    <td width="96">Style</td>
                                </tr>
                                <?php

while($points = mysql_fetch_assoc($get_search_points)){

$point_type_id = $points['type_id'];

$point_style_id = $points['style_id'];

$point_architect_id = $points['architect_id'];

$point_firm_id = $points['firm_id'];

?>
                                <tr>
                                

<td><?php echo $points['name']; ?></td>
                                    <td>
                                    <?php

if(!empty($point_architect_id)){

$get_architect = mysql_query("SELECT * FROM architects WHERE id='$point_architect_id'") or die(mysql_error());

$architect = mysql_fetch_assoc($get_architect);

echo ''.$architect['first_name'].' '.$architect['last_name'].'';

}elseif(empty($point_architect_id)){

$get_firm = mysql_query("SELECT * FROM firms WHERE id='$point_firm_id'") or die(mysql_error());

$firm = mysql_fetch_assoc($get_firm);

echo $firm['name'];

}

?>
                                    </td>
                                    <td><?php echo $points['date']; ?></td>
                                    <td>
                                    <?php

$get_types = mysql_query("SELECT * FROM types WHERE id='$point_type_id'") or die(mysql_error());

$type = mysql_fetch_assoc($get_types);

echo $type['name'];

?>
                                    </td>
                                    <td>
                                    <?php

$get_styles = mysql_query("SELECT * FROM styles WHERE id='$point_style_id'") or die(mysql_error());

$style = mysql_fetch_assoc($get_styles);

echo $style['name'];

?>
                                    </td>
                                </tr>
                                <?php

}

?>
                            </table>
                            <?php

}

?>

Hello,

I have this code running and I keep getting
"Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/.../search.php on line 10

Any help would be appreciated

   <table><tr><td>ID</td><td>SCHOOL NAME</td><td>TEACHER NAME</td></tr>
<?php 
  if(isset($_POST['submit'])){ 
  if(isset($_GET['go'])){ 
  if(preg_match("/^[  a-zA-Z]+/", $_POST['name'])){ 
  $name=$_POST['name']; 
  $db=mysql_connect  ("", "", "") or die ('I cannot connect to the database  because: ' . mysql_error()); 
  $mydb=mysql_select_db(""); 
  $sql="SELECT  ID, school_name, teacher_name FROM Project_Registration WHERE school_name LIKE '%" . $name .  "%'"; 
  $result=mysql_query($sql); 
  while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ 
      echo 
         "<tr><td> {$row['ID']}                           </td>" .
         "<td>     {$row['school_name']}             </td>" .
         "<td>     {$row['teacher_name']}    </td></tr>";}}}}
?> 
    </table>