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> <b><a class=hq href="viewuser.php?name='.$row['username'].'" target="_blank">'.$row['username'].'</a>';
if($row['image'] == 1) {
echo ' <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';
}
?>