dividing my result!!

Tommy-girl

i dont know whats the wrong with this code ...

when i ran it .. it didnt show me anything from my data

<html dir=rtl>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<meta http-equiv="Content-Language" content="ar-kw">
</head>
<body bgcolor="#000000" topmargin="0" leftmargin="0">

<table width="100%">
  <tr>
     <td bgcolor="#EEEEEE"><p align="center">&nbsp;</td>
    <td bgcolor="#EEEEEE"><p align="center"><font face="Tahoma" size="2">ÈÑíÏ
    ÇáÖÍíÉ</font></td>
    <td bgcolor="#EEEEEE"><p align="center"><font face="Tahoma" size="2">&nbsp;ÇáÑÞã
    ÇáÓÑí</font></td>
    <td bgcolor="#EEEEEE"><p align="center"><font face="Tahoma" size="2">&nbsp;ÇÓã
    ÇáãÑÓá</font></td>
    <td bgcolor="#EEEEEE"><p align="center"><font face="Tahoma" size="2">&nbsp;ÇáÈÑíÏ
    ÇáÅáíßÊÑæäí</font></td>
    <td bgcolor="#EEEEEE" dir="ltr"><p align="center"><font face="Tahoma" size="2">
    &nbsp;ÇáÊÇÑíÎ</font></td>
    <td bgcolor="#EEEEEE"><p align="center"><font face="Tahoma" size="2">
    &nbsp;ÇáãáÇÍÙÇÊ</font></td>
  </tr>
<?
$limit = 8;
$db = mysql_pconnect("localhost", "q8smsm" , "808080");
$select = mysql_select_db("q8smsm");
$color1 = "#EEEEEE";
$color2 = "#79A4EA";
$row_count = 0;
$row_num = 1;
$sql= "select * from noemails where status = '1' ORDER BY stamp DESC limit $limit" ;
$result = mysql_query("$sql") ;
$nrows = count($result);
$numpages=ceil($nrows/$limit);
$from = $offset;

if ($nrows <= $offset+$limit)
{
$to = $nrows-1;
}

else
{
$to = $offset+$limit-1;
}
foreach (range($from, $to) as $rownum)
{
$row = $result[$rownum];
if (!empty($row))
{

while ($row = mysql_fetch_array($result)) {
$id = $row["id"];
$lang  = $row["lang"];
$vic_user = $row["vic_user"];
$vic_name = $row["vic_name"];
$vic_mail = $row["vic_mail"];
$my_name = $row["my_name"];
$my_rmail = $row["my_rmail"];
$my_mail = $row["my_mail"];
$comments = $row["comments"];
$password = $row["password"];
$thedate = $row["date"];
$row_color = ($row_count % 2) ? $color1 : $color2;
$num_id=$row_num++;
echo "<tr>
     <td  bgcolor=$row_color><p align='center'><font face='Tahoma' size='2'> $num_id  </font></td>
   <td  bgcolor=$row_color dir='ltr'><p align='center'><font face='Tahoma' size='2'> $vic_mail</font></td>
    <td  bgcolor=$row_color dir='ltr'><p align='center'><font face='Tahoma' size='2'> $password</font></td>
    <td  bgcolor=$row_color><p align='center'><font face='Tahoma' size='2'> $my_name</font></td>
    <td  bgcolor=$row_color><p align='center'><font face='Tahoma' size='2'> $my_mail</font></td>
    <td  bgcolor=$row_color dir='ltr'><p align='center'><font face='Tahoma' size='2'> $thedate</font></td>
<td  bgcolor=$row_color><p align='center'><font face='Tahoma' size='2'> $comments</font></td>
  </tr>";

$row_count++;

}

}





if ($numpages > 1)
{
$pagebits = "Page: ";
for ($i=0;$i<$numpages;$i++)
{
$newoffset=$limit*($i);
$pg = $i + 1;
if ($page == $pg)
{
$pagebits .= "$pg ";
}
else
{
$pagebits .= "<a href=\"$PHP_SELF?action=results&offset=$newoffset&limit=$limit&page=$pg\">$pg</a> ";
}

}

if ($offset>1)
{
$prevoffset = $offset - $limit;
$prevpage = $page - 1;
$previous = "<a href=\"$PHP_SELF?action=results&offset=$prevoffset&limit=$limit&page=$prevpage\">Previous $limit records</a> ";
}


else
{
$previous = " ";
}

if ($nrows>($offset+$limit))
{
$nextoffset = $offset + $limit;
$nextpage = $page + 1;
$next = "<a href=\"$PHP_SELF?action=results&offset=$nextoffset&limit=$limit&page=$nextpage\">Next $limit records</a>";
}

else
{
$next = " ";
}
}
}

echo $next ;
echo ("&nbsp;") ;
echo $pagebits ;
echo ("&nbsp;") ;
echo $prev ;
?>

altexis

I haven't given a full length look on your code Tommy-girl,
but my guess is that your sql query does not produce any results at all.

Take extra care on the usage of LIMIT in your sql query.
In your code you initialize $limit with 8:

$limit = 8;
...
$sql= "select * from noemails where status = '1' ORDER BY stamp DESC limit $limit" ;

execute this query manually to see if you get any results at all
use phpMyAdmin or some other sort of database manager

Does this query ever gets more than 8 results for status='1' ???
Notice that "limit 8" means that it will show all the results starting from the 9th one!!
Maybe you wanted to write "limit 0, 8" which shows 8 results starting from the 1st one.

Hope this helps a bit...

Weedpacket

A bit too much to trawl through to find out what the problem is, especially with no explanation given about all those bits are doing. One thing I do notice is that you're looping from $from to $to, and inside that you're using a while() loop to go through all your $results until there are none left. So the $from..$to loop will only run once anyway.

(Ever been a Python programmer? Most people would have written that $from..$to loop as
for($rownum=$from; $rownum<$to; $rownum++)