Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

[PHP-DB] Random select -- Where am I going wrong? From: Ronald \ (sesel <email protected>)
Date: 07/04/04

Here is my code.... I keep on getting a Resource id #2 ......whatever that
means....any help would be appreciated!

<html>

<head>

<title>Top Frame</title>

</head>

<body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080"
alink="#ff0000">
<EMBED SRC="" autostart="true" hidden="true" loop="true" volume="100%">
<?

$db_host = '######;
$db_user = '######';
$db_pass = '######';
$db_name = '######';

$conn = mysql_connect($db_host,$db_user,$db_pass);

if ($conn == true) {

// Select the database.
  mysql_select_db($db_name,$conn);

$db_table = 'music';
$music = mysql_query ("Select * from $db_table ORDER BY RAND() Limit 1");

if(!$music) die("Query Failed.");

while($row = mysql_fetch_row($music))

print "$music";
}
?>

</body>

</html> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php