Showing and Managing Mysql/PHP

fifthcore

I am a newbie so please be understanding. I am working on a huge Db site. When completed it will have thousands of entries. I need to be able to list and the contents of a MySQL table. For example lets say we have the fields (id, title, platform, year, publisher, developer, etc). I need a page that will show the title only for lets say 50 entries. Then I need to be able to click on a title and show a new page with all the info for that row in the MySQL table. It sounds easy, but I can't seem to figure it out. I just ordered Kevin Yanks MySQL/PHP book so I am hoping that will help. If anyone can help or get me some good URLs that would be great.

Anon

What you need to do is display the title to the page as a link and have the ID value placed within that link. For example

//have a loop that goes through all you rows

for ($i=0; $i < mysql_num_rows($QueryID); $i++)
{
echo "<a href='page.php?ID=". $ID ."'>$title</a>\n";
}

or something like that. The above code wont work but it should give you an idea.

Make sure the page.php knows what to do with the $ID it receives.

As for displaying 50 entries at a time lookup the LIMIT SQL command that mySQL has.

fifthcore

Thanks for the info, I will look that stuff up in the PHP manual. I was able to get a next and back thing working. http://www.ivgdb.com/beta4.php
Guess I need to read more of the PHP manual.

Thanks for the reply it really helps