Script help

[Anon]

Hi Guys,
I recieved this script....but it brings up a warning.

<?
$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));
?>

Can anyone fix it?

[rrijnders]

What's the warning?

[Anon]

Warning: Supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\typh_ent\typhoon entertainment_b.htm on line 8

[Anon]

Try:

<?
$Host="localhost";// Your host.
$User="root"; //or whatever user you are.
$Pass=""; // or password you are using.
$DBName="typh_ent";

$link = mysql_connect($Host,$User,$Pass) or die ("Could not Connect to DB");

mysql_select_db($DBName,$link);

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

$result=mysql_query($query);

$row = mysql_fetch_array($result);

while ($Row=mysql_fetch_array($Result)) {

echo $Row["name"]." | ".$Row["picture"]." | ".$Row["biography"]."<br>";

}

mysql_close($link);
?>

-j
PHP FOREVER!