Script problem

Anon

Hi all,
Here is my script:

<?
$link = mysql_connect('localhost', 'username', 'password');
mysql_select_db('typh_ent');
$query = <<< EOF
SELECT name, picture, biography, profile FROM bands
WHERE band_id = $id
EOF;
$row = mysql_fetch_array(mysql_query($query));

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

Here
it is, a modified version. 
 
<?=$row['profile']?>
</body>

Why won't this display on my local server. The error message is:

Warning: Supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\cart\album_details.php on line 15

Is it a configuration problem....does anyone know?

Cheers,
alan

[deleted]

Your query was invalid.

use error checking to find out what is wrong:

if (!$result = mysql_query($sQuery))
{
echo mysql_error();
}
else
{
if (!$row = mysql_fetch_array($result))
{
echo 'No record to fetch';
}
else
{
//print record.
}
}

PS: you can create the query like this:

$query = "
SELECT name, picture, biography, profile FROM bands
WHERE band_id = ".$id."
";

.. and don't compact your code, it makes it un-debuggable.

Anon

try this:
--- cut here ---
<?php
$link=mysql_connect('localhost','username','password');
mysql_select_db('typh_ent');
$query="SELECT name,picture,biography,profile FROM bands WHERE band_id = $id";
$result=mysql_query($query);
$row=mysql_fetch_array($result));
?>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
 
 
Here
it is, a modified version. 
 
<?=$row['profile']?>
</body>
--- cut here ---

if this doesnt work, check your sql query syntax, there is probably a mistake (spelling maybe?)

nikos