php doesn't load dynamic pagination

[contra10]

<?php 
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error()); 

echo "var commentsbook={\n"; //Dynamically output javascript variable 
$commentids=mysql_query("SELECT * from `users`"); //get IDs to last 5 comment pages 

$idarray=array(); 
while ($theid=mysql_fetch_array($commentids)){ 
  array_push($idarray, "'" . $theid[username] . "'");
}

echo "pages: [" . implode(",",$idarray) . "],\n"; //output: pages: [filepath1, filepath2, file
echo "selectedpage: 0\n}"; 

?>

that will echo the usernames but how about the pagination and limits to what is viewed on a page...thanks for the help btw

[Nile]

Is that what you wanted?

Or do you still need help?

[contra10]

still need help...i was trying to do this but with the username...echo 5 users then move to next page...
http://www.dynamicdrive.com/dynamici...nate/index.htm

[Nile]

Please post a link to the page on your site that contains the problematic script so we can check it out.

Also, can you provide all the code, including what's on index.php.

[contra10]

sry...how do i do that...kinda new...do i just post the link and all coding... here even though im on localhost?

[Nile]

If you on localhost, go ahead and make an account on Freehostia and upload your files there. You can just post all the coding too. Use the [ php ], [ html ], or [ code ] tag.

[contra10]

all my files ar ethere
http://localhost/test/

[Nile]

Since your using a localhost you cannot share the link. It will simply go to my localhost. As I said before make an acount on Freehostia.

[contra10]

the takes forever to send registration email

[contra10]

ok i have the code working at least aalittle bit...i can echo my results inbetween the pages...thing is now how do i link my pages to the results...i changed the variables to post as this was suppose to be for post origally

<div id="paginate-top"> </div>
<div id="bookcontent">
<?php 
	
if(is_numeric($_GET['page'])){

 $page = $_GET['page'];
	}

			mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error());


	$da = "SELECT * FROM post_profile WHERE userid = '1' ORDER BY ppid DESC LIMIT 10";
$usposts = mysql_query($da) or die(mysql_error()); 

//This is where you display your query results
while($infoif = mysql_fetch_array($usposts)) 
{ 
	$post= "{$infoif['post']}";
	echo"$post<br>";
	
}

?>
FINALLY ECHOING SOMETHING</div>
<div id="paginate-bottom"> </div>


<script type="text/javascript">

<?php 
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error()); 

echo "var commentsbook={\n"; //Dynamically output javascript variable 
$commentids=mysql_query("SELECT `ppid` from `post_profile` LIMIT 2"); //get IDs to last 5 comment pages 

$idarray=array(); 
while ($theid=mysql_fetch_array($commentids)){ 
  array_push($idarray, "'" . $theid[ppid] . "'");
}
echo "pages: [" . implode(",",$idarray) . "],\n"; //output: pages: [filepath1, filepath2, file
echo "selectedpage: 0\n}"; 

?>



var comments=new ajaxpageclass.createBook(commentsbook, "bookdiv", ["paginate-top", "paginate-bottom"])
</script>
</body>