Pulling information from a database

[Collegeboox]

I am creating a music blogging site however the main page will only show one video the code is below anyone have any ideas?

 

"

<?php

//open database

$connect = mysql_connect("******","username","password") or die("Not connected");

mysql_select_db("collegebooxboox") or die("could not log in");

 

$query = "SELECT * FROM boox ORDER BY date DESC";

$result = mysql_query($query);

 

// Get the page number, if none is set - it is 0

if( isset($_GET['page']) )

{

$page =$_GET['page'];

}

else

{

$page  = 0;

}

 

$resultsPerPage = 15;

$num = mysql_num_rows($result); // amount of rows

$loops = $page*$resultsPerPage; // starting loops at..

 

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )

{

$link = mysql_result($result,$loops,"link"); // get result from the 'Title' field in the table

$username = mysql_result($result,$loops,"username"); // get result from the 'Content' field in the table

$messsage = mysql_result($result,$loops,"message");

$date = mysql_result($result,$loops,"date");

if ($pagelimit == 0)

{

$pagelimit == 1;

}

if ($pagelimit <= 15)

// echo stuff here

$loopz = $loops + 1;

echo "  &nbsp

</br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>

  <tr>

<td>$loopz. $link

            </br>

$message

</br>

Posted By: $username $date

</td>

  </tr>

</table></br><br>";

$count++ ;

$pagelimit++;

$loops++;

}

 

if ( $page!=0 ) // Show 'Previous' link

{

$page--;

$prevpage = ($page +  1);

echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage     </a>";

$page++;

}

if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link

{

$page++;

$nextpage = ($page + 1);

echo "<a href='index.php?page=$page'>  Next $nextpage</a>";

}

 

?>

"

[sunfighter]

Your doing your query outside of your while loop and trying to get the query information inside the loop. You will only get one line as you know.

How to do it:

<?php
//open database
$connect = mysql_connect("******","username","password") or die("Not connected");
mysql_select_db("collegebooxboox") or die("could not log in");
require ('./inc/DB_connect.php');

$query = "SELECT * FROM boox ORDER BY date DESC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){

$link = $row['link'];
$username = $row['username'];
$messsage = $row['messsage'];
$date = $row['date'];

echo $link, '<br>';        // This you replace with your table
echo $username, '<br>';
echo $messsage, '<br>';
echo $date, '<br>';
echo '=====================================<br>';  // a seperater
}
?>