<?PHP
// $reqlevel sets the accesslevel a user needs to hace
// use 0 (zero) if you want to make it an admin only page.
// and 1 (one)  is default for an new user. 
// this makes the page an member only page.
include("config.php");
$search = $HTTP_GET_VARS["search"];
$searchname = $HTTP_POST_VARS["searchname"];
$name = $HTTP_POST_VARS["name"];
$gender = $HTTP_POST_VARS["gender"];
$state = $HTTP_POST_VARS["state"];
$lowage = $HTTP_POST_VARS["lowage"];
$highage = $HTTP_POST_VARS["highage"];
$image = $HTTP_POST_VARS["image"];
$page = $HTTP_POST_VARS["page"];

?>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK href="help.css" rel=stylesheet type=text/css>

</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>
      <?
$currentyear=$currentyear=strftime("%Y");
?>
    </td>
  </tr>
  <tr> 
    <td> 
      <?php

mysql_select_db($database, $conn);
if(!$conn)
{
   echo "Couldn't make a connection!!!";
   exit;
}

$db = mysql_select_db($database,$conn);
if(!$db)
{
  echo "The database disapeared!";
  mysql_close($conn);
  exit;
}

$image="";
if(isset($_POST['image']) && $_POST['image'] == 1) { 
$image .= ' AND image = 1 ';  

}
    $max = 0;
    $bmax = mysql_query("SELECT * from ".$DBprefix."signup WHERE username like '%$searchname%' and fullname like'%$name%' and state like'%$state%' and gender like'$gender%' and userlevel='1' and actnum='0' and '$currentyear'-dobyear >= $lowage and '$currentyear'-dobyear <= '$highage' {$image}");
    while ($row = mysql_fetch_array($bmax))
    {
      $max++;
    }
    ?>
	<font size="2">
      <?php
	  $image="";
if(isset($_POST['image']) && $_POST['image'] == 1) { 
$image .= ' AND image = 1 ';  

} 
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 = 30;
$sql_text = ("SELECT * from ".$DBprefix."signup WHERE username like '%$searchname%' and fullname like'%$name%' and state like'%$state%' and gender like'$gender%' and userlevel='1' and actnum='0' and '$currentyear'-dobyear >= $lowage and '$currentyear'-dobyear <= '$highage' {$image}");

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>";
}
?><CENTER>
<table CELLSPACING="2" CELLPADDING="2" BORDER="0" width="70%"> 
<font size=2>
<?php 
$a = $start + 1; 
     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"; 
while ($row = mysql_fetch_array($query)) {
?>
<?php
$image="";
if(isset($_POST['image']) && $_POST['image'] == 1) { 
$image .= ' AND image = 1 ';  

}
$res = mysql_query("SELECT * FROM ".$DBprefix."signup WHERE username like '%$searchname%' and fullname like'%$name%' and state like'%$state%' and gender like'$gender%' and userlevel='1' and actnum='0' and '$currentyear'-dobyear >= $lowage and '$currentyear'-dobyear <= '$highage' {$image}");  

if(mysql_num_rows($res) > 0) {  

      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="members/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="members/image/'.substr($row['gender'], 0, 1).'.jpg" alt="'.$row['gender'].'" />';
		}
		else {
		echo '<img src="members/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';  

} 
?>
</body>
</html>
<?php
    }
    echo "</table>";
    if ($max>$maxresult)
    {
    echo "<br><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>";
    }
?></font>

skyloon

when i put "or die('error: '. mysql_error());", it shows this error message:

error: You have an error in your SQL syntax near 'and '2004'-dobyear <= '' ' at line 1

bretticus

Just do a bit more debugging...

Make sure all your querys (especially the dynamically created ones) are set to a variable (such as $sqltext = "....)

then insert that into your die statement.

die('query: $sqltext - error: '. mysql_error())

And you see where it's going wrong.

I am including an old script of mine that works to demonstrate what I did to accomplish basically the same thing:

//...edited for brevity.
$rows_per_page = 10;
$curr_page = (isset($_GET['page'])) ? $_GET['page'] : 1;
$ub = $curr_page*$rows_per_page;
$start = $ub - $rows_per_page;
// Get Count.
$sql = "SELECT COUNT(*) FROM events WHERE http_host = '$domain'";
$result = mysql_query($sql) or die(alertadmin($err_email,$err_subject,"Invalid query: $sql"));
$num_rows = mysql_result($result,0);
// Calc total pages.
$pages = $num_rows/$rows_per_page;
$sql = "SELECT id, title, UNIX_TIMESTAMP(startdate) AS startdate, UNIX_TIMESTAMP(enddate) AS enddate FROM events WHERE http_host = '$domain'";
//...edited for brevity.
	$sql .= " ORDER BY title, startdate, enddate";
	$sql .= " LIMIT $start,$rows_per_page";
}
// edited for brevity...
for ($i=1;$i<=$pages;$i++){
	echo " <a class=\"link\" href=\"{$_SERVER['PHP_SELF']}?mode=$mode&page=$i\">[page-$i]</a>\n";
	if ($i%7==0){echo "<br>";}
}
// Looks like some half-cocked way to spit out a residual page when I might have used a ceil() function etc.
if ($num_rows%$rows_per_page){
	echo " <a class=\"link\" href=\"{$_SERVER['PHP_SELF']}?mode=$mode&page=$i\">[page-$i]</a>\n";
}
// Would do this all a bit cleaner and smarter these days, but I hope it helps.

also, from the PHP manual, tac writes something I didn't know until tonight...

tac at smokescreen dot org (14-Jan-2002 05:58)

MySQL 4.0 supports a fabulous new feature that allows you to get the number of rows that would have been returned if the query did not have a LIMIT clause. To use it, you need to add SQL_CALC_FOUND_ROWS to the query, e.g.
$sql = "Select SQL_CALC_FOUND_ROWS * from table where state='CA' limit 50";
$result = mysql_query($sql);
$sql = "Select FOUND_ROWS()";
$count_result = mysql_query($sql);
You now have the total number of rows in table that match the criteria. This is great for knowing the total number of records when browsing through a list.

skyloon

too complicated, not very understand.... :bemused:

skyloon

until now, the problem hvn't fixed..... 🙁

Weedpacket

Originally posted by bretticus

I am including an old script of mine that works to demonstrate what I did to accomplish basically the same thing:

I think you've gone over into the realm of "too much information" bretticus, and now skyloon is confused.

skyloon, the error message you're getting from MySQL suggests that "$highage" is empty (so that an empty string goes in the query, so that the comparsion against a number fails). Either that or it's some sort of number->string conversion failure (you're converting it to a string for some reason, despite wanting to make an integer comparison).

See also the Debugging 101 thread in the Echo Lounge.