[RESOLVED] Need help Fast! Weird ORDER BY problem.

[atokatim]

For some reason the code below returns dupilicate results on different pages.

$page = $_GET['page'];
			if($page == "" || $page <= 0){ $page = 1; }
			$startpage = ($page - 1) * $affperpage;
			include "_dbconnect.php";

		$nop=mysql_num_rows(mysql_query("SELECT id FROM affiliates"));
		$nop1=$nop / $affperpage;
		$nop1 = round($nop1, 2);
		$p = explode(".", $nop1);
		$pages = $p[0];
		if($p[1] > 0){ $pages = $pages + 1; }

		echo "Total Affiliates : ".$nop."<br>";
		$trefer = 0;
		$tclicks = 0;
		$sql=mysql_query("SELECT treferred, tclicks FROM affiliates");
		while($taff=mysql_fetch_object($sql)){
			$trefer=$trefer + $taff->treferred;
			$tclick=$tclick + $taff->tclicks;
		}
		echo "Total Clicks In : ". number_format($trefer, 0, '', ',')."<br>";
		echo "Total Clicks Out : ". number_format($tclick, 0, '', ',')."<br><br>";


		$affsql=mysql_query("SELECT * FROM affiliates ORDER BY referred LIMIT $startpage, $affperpage");
		while($aff=mysql_fetch_object($affsql)){
			$pname=explode("/", $aff->path);

                            // Display results...
                     }
                     mysql_close($db);

The table 'referred' is indexed and INT(99)

Any ideas?

[bpat1434]

I don't see a table "referred" referred to in your code clip.

Without seeing the results, and what your table looks like, it's difficult to say. Do you have working examples you can show us?

[atokatim]

Opps.... i mean the the row "referred" in the database is indexed and INT(99); The table is affiliates

[bpat1434]

have you tried specifying how to order it (ASC vs DESC)?

[atokatim]

yeah...that is what i did and it fixed it.