searching...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
sguy
Forum Commoner
Posts: 61
Joined: Sun Aug 10, 2003 2:44 am

searching...

Post by sguy »

i have 2 list menus, named lowage & highage in search.php, i want to find the age between 2 list menu...

i don't store the age into database, i use current year to minus year of birth of someone, when i do searching, i can't use ("select age from `table` where age >= '$lowage' and age <= '$highage'");

how to solve it???

thanks...

searching.php

Code: Select all

<?php
echo"<table border=0 cellspacing=0 width=80% align=center>";
    echo "</td><td height="12" align="right" bgcolor="lightcyan" width="100%"><font size=2>";

    echo "<center>Database record returned<font color = blue> $max </font>
          items.</center>";
    echo "</td></tr></form></table><br>";

    $maxresult = 10;
    $sql_text = ("SELECT * from ".$DBprefix."signup WHERE username like '%$search%' and fullname like'%$name%' and state like'%$state%' and gender like'$gender%' and '$age' >= '%$lowage%' and '$age' >= '%$highage%'");

    if (!$page) {
    $page = 1;
    } 
    $backpage = $page - 1;
    $nextpage = $page + 1;
    $query = mysql_query($sql_text);
    $start = ($maxresult * $page) - $maxresult; 
    $num_rows = mysql_num_rows($query); 
    if ($num_rows <= $maxresult) {
    $num_pages = 1; 
    } else if (($num_rows % $maxresult) == 0) {
      $num_pages = ($num_rows / $maxresult);
    } else {
    $num_pages = ($num_rows / $maxresult) + 1;
    } 
    $num_pages = (int) $num_pages;
    if (($page > $num_pages) || ($page < 0)) {
    error("You have specified an invalid page number");
    }
    $sql_text = $sql_text . " LIMIT $start, $maxresult";
    $query = mysql_query($sql_text);
    
    if ($max>$maxresult)
    {
    echo "<center>- ";
    if ($backpage) { 
    echo "<a href="searching.php?search=$search&page=$backpage">Prev</a>";
    } else {
    echo "Prev";
    }
    for ($i = 1; $i <= $num_pages; $i++) {
    if ($i != $page) { 
    echo " <a href="searching.php?search=$search&page=$i">$i</a> ";
    } else { 
    echo " $i "; 
    } 
    }
    if ($page != $num_pages) {
    echo "<a href="searching.php?search=$search&page=$nextpage">Next</a> -";
    } else {
    echo "Next -";
    }
    echo "</center>";
    }
    ?>
<?php 
$a = $start + 1; 
    print"<TABLE CELLSPACING="2" CELLPADDING="2" BORDER="0" align=center width="80%">"; 
    print "  <TR bgcolor=slateblue><TD font size=2 align=center height="26"><font font size=2 color=white><b>Nickname</TD><TD align=center><font size=2 color=white><b>Gender</TD><TD align=center><font size=2 color=white><b>Age</TD><TD align=center><font size=2 color=white><b>Location</TD><TD align=center><font size=2 color=white><b>Country</TD><TD align=center><font size=2 color=white><b>Headline</TD></TR>\n"; 

$res = mysql_query("SELECT * FROM ".$DBprefix."signup WHERE username like '%$search%' and fullname like'%$name%' and state like'%$state%' and gender like'$gender%' and '.$age.' >= '%$lowage%' and '.$age.' >= '%$highage%'");  

if(mysql_num_rows($res) > 0) {  
   while($row = mysql_fetch_array($res)) {  
      echo"<tr>"; 
	 $pic = strtolower(substr($row['gender'], 0, 1)); 
   	 $color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
      	 echo '<td bgcolor="'.$color.'"><font size=2>&nbsp;&nbsp;<b><a class=hq href="viewuser.php?name='.$row['username'].'" target="_blank">'.$row['username'].'</a>';  
         if($row['image'] == 1) {   
         echo '&nbsp;&nbsp;<img src="image/camera.gif" alt="camera" />';  
         }  
          echo '</td>'."\n";  		  
	  $pic = strtolower(substr($row['gender'], 0, 1)); 
   	  $color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
    	  "$row[gender]\n";
		  
	  $currentyear=strftime("%Y");
	  $currentdate=strftime("%d-%m-%Y");
	  $age = $currentyear - $row[dobyear];

		$pic = strtolower(substr($row['gender'], 0, 1)); 
   		$color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
		echo'<td align=center bgcolor="'.$color.'">';
    		"$row[gender]\n";
		if($row['gender'] == 'male') {
		echo '<img src="image/'.substr($row['gender'], 0, 1).'.jpg" alt="'.$row['gender'].'" />';
		}
		else {
		echo '<img src="image/'.substr($row['gender'], 0, 1).'.jpg" alt="'.$row['gender'].'" />';
		}		

$pic = strtolower(substr($row['gender'], 0, 1)); 
   		$color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
		echo'<td align=center bgcolor="'.$color.'">';
		echo"<font size=2>$age";
    		"$row[gender]\n";

$pic = strtolower(substr($row['gender'], 0, 1)); 
   		$color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
		echo'<td align=center bgcolor="'.$color.'">';
		echo"<font size=2>$row[location]";
    		"$row[gender]\n";

$pic = strtolower(substr($row['gender'], 0, 1)); 
   		$color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
		echo'<td align=center bgcolor="'.$color.'">';
		echo"<font size=2>$row[country]";
    		"$row[gender]\n";
			
$pic1 = strtolower(substr($row['gender'], 0, 1)); 
   		$color1 = ($pic1 == 'm') ? 'blue' : 'red';
		echo'<font color="'.$color1.'">';
$pic = strtolower(substr($row['gender'], 0, 1)); 
   		$color = ($pic == 'm') ? 'aliceblue' : '#fff0ff';
		$color1 = ($pic1 == 'm') ? 'blue' : 'red';
		echo'<td bgcolor="'.$color.'"><font color="'.$color1.'">';
		echo"<font size=2>$row[headline]";
    		"$row[gender]\n";
$a++; 
   }  
}  
else {  
   echo 'No users found';  
} 
?>
Post Reply