Hi i have this code that i tried to make to send some info from one page to aother with lots of ppls help and it works ok but when i have multiple files it doesnt send the correct info. What im tryin to get is the Num_Pages to another page it works fine if its just one file in the db but when its multiple and i select a file in the middle of the table or somewhere else i dont get tht info i get the last file info. Can anyone help if I didnt confuse u? Thank You Code: <?php // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB");
$sql = "SELECT * FROM files where username = '".$_SESSION['myusername']."' ORDER BY id ASC "; //$sql = "ORDER BY id ASC"; $result = mysql_query($sql); $rows = mysql_num_rows($result);