Alright, I'm using mySQL to retrieve one row of results. The row is already in the database named 'reviews' and the database is running fine (phpbb works perfectly). So no problems there.
So, it must be a problem with the code. But what's wrong with this code that it won't return any results? It's not a php error (I get the page layout, it's embedded in HTML that I have omitted). But... what is it? Help please!
<php
$id = $_GET['id']
$username="removed";
$password="removed";
$database="removed";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT * FROM reviews WHERE id='$id'";
$result=mysql_query($sql) or die ("Error: " .mysql_error()." with query $query");
$array = mysql_fetch_array($result);
$artist = $array['artist'];
$album = $array['album'];
$text = $array['text'];
$rating = $array['rating'];
$tracks = $array['tracks'];
$albumart = $array['albumart'];
echo $artist;
echo $album;
echo $text;
echo $rating;
echo $tracks;
echo $albumart;
?>