erorr with my own function

Tommy-girl

My proplem is when i made this function ... i want to use Dynamic HTML Tags .. so i dont want to define it in my function
so when i ran the while loop .. there aren't result .....
so please any one can help me ????


 <table width="100%" border="2" style="border-collapse: collapse" bordercolor="#000000" cellpadding="0" cellspacing="0">
  <tr>
         <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></td>


<?
include "db.php";

function page_div($sql, $pagelimit, $color1, $color2){ 

global $pagenums, $totalrows, $start, $starting_no, $end_count, $space, $query, $strSQL, $var2, $i, $row_color, $row_count, $page, $contine;


$query = mysql_query($sql);

$totalrows = mysql_num_rows($query);

$pagenums = ceil ($totalrows/$pagelimit);

if ($page=='') {
    $page='1';
}


$start = ($page-1) * $pagelimit;


$starting_no = $start + 1;

if ($totalrows - $start < $pagelimit) {
   $end_count = $totalrows;
} elseif ($totalrows - $start >= $pagelimit) {
   $end_count = $start + $pagelimit;
}



if ($totalrows - $end_count > $pagelimit) {
   $var2 = $pagelimit;
} elseif ($totalrows - $end_count <= $pagelimit) {
   $var2 = $totalrows - $end_count;
}

$space = "&nbsp;";



// run query again using LIMIT
$strSQL = mysql_query("$sql  LIMIT $start,$pagelimit");

$contine = True ;
     if (mysql_num_rows($strSQL) == '0') {
         echo("Nothing to Display Or You choosed wrong number of pages !");
        $contine = false ;
     } elseif ($contine = True) {




// row colors
      $row_color="$color1";
      $count_rows = "0";



while ($row = mysql_fetch_array($strSQL)) {

       $count_rows++;
             if ($count_rows%2==0)
                 { $row_color="$color1"; } // Even-numbered rows
             else
                 { $row_color="$color2"; } // Odd-numbered rows

echo "<tr>
<td bgcolor=\"$row_color\" dir=\"ltr\"> $row[vic_mail]</td>
<td bgcolor=\"$row_color\" dir=\"ltr\"> $row[PASSWORD]</td>
<td bgcolor=\"$row_color\"> $row[my_name]</td>
<td bgcolor=\"$row_color\"> $row[my_mail] $my_rmail</td>
<td bgcolor=\"$row_color\" dir=\"ltr\"> $row[date]</td>
<td bgcolor=\"$row_color\"> $row[comments]</td>
</tr>";
}



echo "</table>";
echo "</tr>";
echo "</table>";
}

// next link

if ($page<$pagenums) {
    echo (" <a href='$PHP_SELF?page=".($page+1)."' class=main>ÇáÊÇáí" . $space ." </a>");
}


// dynamic page number links

for ($i=1; $i<=$pagenums; $i++) {
    if ($i!=$page) {
        echo " <a dir='rtl' href='$PHP_SELF?page=$i' class=main>$i</a>";
    }
    else {
        echo " <b class='red'>$i</b>";
    }
}

//previous link

if ($page>1) {
echo "" . $space ." <a href='$PHP_SELF?page=".($page-1)."' class=main>ÇáÓÇÈÞ</a>";
    }
else () {
echo "There Was an erorr in choosing the pages" ;
}
}


page_div("SELECT * FROM noemails WHERE status='1' ORDER BY stamp DESC", "5", "#FFFFFF", "#E9E9E9") ;

Tommy-girl

any one can help!!!!!!!

adamgeorge

Dude, I dunno... lol. Would it hurt to be more specific?

What's dynamic HTML tags? there's only one kind of html tags.. and that's the html kind lol. Although I guess technically different browsers have their own small subset... but that's neither here nor there. I believe dynamic html refers to using javascript or similar client side code to make HTML behave dynamically.

I don't think there are any new magic tags just yet.

anyway... I still don't get what your problem is... like.. most web developers at some stage code up a simple reporting thing like you have which splits sql results onto multiple pages. If you're stuck... check out one of the squillions available on the net.

Here's an idea for you... try and modify that code so that it will print out the results for any query... ie. You have $row[comments] and such in your while loop... you could modify that so you do another for loop in there, and simply loop through each field in $row. I.e.

echo "<tr>";

for($i=0; $i<count($row); $i++)
    echo "<td>" . $row[$i] . "</td>";

echo "</tr>";

that will print out all the fields for that row... so you could then pass in any query and the function would still work. (you might want to use mysql_fetch_rows instead though for performance reasons)

anyway thats just an idea... you'll have to be more specific with your problem though... I'm not really too sure what was really wrong.

-Adam 🙂