PHP Dynamic Pages using the ID

Im trying to create a list of titles I have in my database and also create a clickable link of each entry in the database. An error is saying there are no titles in the DB but I have a good few in there. I want the user to be redirected to a different page depending on the link they press

Any help ??

require('connection.php');

mysql_select_db('trackdb');
//Run the query which selects the column link from table table, if there is an error, kill the       
//program and display it.

$query = mysql_query("SELECT * FROM tracks WHERE id='".$_GET['id']."'") or die("Error:    
".mysql_error()."!");

//Check if any results were returned

if(mysql_num_rows($query)>0){

//If so, display itresults

$row = mysql_fetch_array($query);

//Display the info

echo"$row[track_title]<br>

//If it no results were found...

}else{

//Tell them

echo"No titles found";

} 



?> 

Answers


Need Your Help

Draw an NSView into an NSGraphicsContext?

objective-c cocoa osx nsview

I have a CGContext, which I can turn into an NSGraphicsContext.

jQuery mobile page link not working

html5 jquery-mobile hyperlink

In my jQuery mobile (v 1.2) web site, I have several separate pages (i.e. each page has one header, content and footer). The problem is I can't link the pages. The following line is not working.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.