1 reply to this topic

[Deathskin]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\display.php on line 10

<?php
//connect to mysql database
require ($_SERVER["DOCUMENT_ROOT"]."/Config/music.php");
$connection = mysql_connect($db_host, $db_user, $db_pw) or die(mysql_error());
mysql_select_db($db_name, $connection);

$sql = "SELECT * FROM songs";


while ($songs = mysql_fetch_array($sql)){
$ID = $songs[id];
$ARTIST = $songs[artist];
}
echo "$ID, $ARTIST";

?>

[rc69]

$sql = "SELECT * FROM songs";

while ($songs = mysql_fetch_array($sql)){

$sql = string... as in not a resource. You forgot to call the mysql_query() function.

$sql = mysql_query("SELECT * FROM songs") or die(mysql_error());

while ($songs = mysql_fetch_array($sql)){