I have a MYSQL-database.
Table: album with columns: albumname, albumid
Table: track with columns: trackname, trackid, genreid
Table: genre with columns: genrename, genreid
Table: albumtrack with columns: albumid, trackid
Table: albumgenre with columns: albumid, genreid
I made a search from like this:
<body>
<h2>Search for album</h2>
<form name="form" action="displaysearchalbum.php" method="get">
<input type="text" name="getsearch" />
<input type="submit" name="Submit" value="search album" />
</form>
<br />
<h2>Search for track</h2>
<form name="form" action="displaysearchtrack.php" method="get">
<input type="text" name="getsearch2" />
<input type="submit" name="submit2" value="search track" />
</form>
</body>
I am a bit new to php and mysql and have problem getting displaysearchalbum.php to work.
The first part of the code seems fine but I'm not sure how to display the result of the SQL-query. Any tips?
<?php
// Get the search variable from URL
$var = @$_GET['getsearch'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
// rows to return
$limit=20;
// check for an empty string and display a message.
if ($trimmed == "")
{
echo "<p>Please enter a search...</p>";
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
//connect to your database
mysql_connect("x","x","x"); //(host, username, password)
//specify database
mysql_select_db("cpm08010") or die("Unable to select database");
// Build SQL Query
$query = "SELECT albumname FROM album WHERE albumname='$trimmed'";
Best Regards