Wrong datatype in call to extract()

[Silverado4x4]

How do I fix this?

http://www.jokeuniversity.com/links/database.php

<?
$dbcnx = mysql_connect('localhost','db','pass');
mysql_select_db('db');

$sql = mysql_query("SELECT url, sitename, description, email FROM links ORDER BY sitename ASC") or die(mysql_error());
$result = mysql_fetch_array($sql);
extract($result);

function listlinks() {
    //make table
    echo "<table>\">";
            echo "<tr>";
            echo "<td><a href=\"$url\" alt=\"$description\"><font color=\"#000000\" face=\"Arial\" size=\"2\">$sitename</a></td>";
            echo "</tr>";
    echo "</table></center>";
}

?>

     <?



     listlinks();

     ?>

[Defender1]

try this for mysql_select_db

mysql_select_db("dbname", $dbcnx); 

[Paul S]

mm, maybe mysql is returning an empty set (ie, not data). Have you checked this?

You can check if $result is an array with,

 if (is_array($result))
    extract($result);     
 else 
     echo 'Empty set, no data found'; 

[Silverado4x4]

Yes, that is the problem Paul.

Come to find out, another section of my script wasn't inserting anything at all.

Here is the code...

<?
if ($submit) {
$connect = mysql_connect ("localhost", "jokeun", "pass")
        or die ("Could not connect");
    print ("Connected successfully");
    mysql_db_query("jokeun","INSERT INTO links (url, sitename, description, email)
                                  values ('$url', '$sitename', '$description', '$email')" )
    or die("Error! " . mysql_error());
}
$result=mysql_db_query("jokeun", "SELECT * FROM links ORDER BY sitename ASC") or die ("Couldn't open \"jokeun\" database. Please inform [email]webmaster@jokeuniversity.com[/email]: ".mysql_error());
$row = mysql_fetch_array($result); 
$url = $row["url"];
$sitename = $row["sitename"];
$description = $row["description"];
$email = $row["email"];
echo "$url<br>$sitename<br>$description<br>$email";
?>

Yet, I get this result:
Couldn't open "jokeun" database. Please inform webmaster@jokeuniversity.com: Access denied for user: '@localhost' to database 'jokeun'

[Paul S]

when $submit is false, the bracket part is skipped and mysql_conect() is not called.
Try this,

 $connect = mysql_connect('localhost', 'jokeun', 'pass')
        or die ('Could not connect');

 if ($submit) { .... 

[peanuts]

Nice site...!!!!!!!!!

A bit to much on the popup screens to join the school but for the rest is a nice site

[Silverado4x4]

Well...thanks

It'll be even nicer when I get my new site design tomorrow (see the trading post)!