Warning: mysql_fetch_assoc(): supplied argument

[flforlife]

Hi I'm a php novice and for some reason I keep getting an error like this:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in

C:\wamp\www\ccfnewsarticle\index.php on line 34


when I use a conditional statement to test the querys I get this error:

Could not successfully run query (SELECT id, name, posted, summary, author_name,

author_email FROM news_articles ORDER BY posted DESC LIMIT 0, 10 ) from DB: No database

selected


Here is the code

<?php

//verbus newsletter
// index.php - Displays summaries of the most recent articles

$hostname = 'localhost';
$username = 'vcounts';
$password = ''; //no password yet
$database = 'cffnews';

$mysql = mysql_connect($hostname, $username, $password);
mysql_select_db($database);

$sql = "SELECT id, name, posted, summary, author_name, author_email ";
$sql .= "FROM news_articles ";
$sql .= "ORDER BY posted DESC ";
$sql .= "LIMIT 0, 10 ";

$result = mysql_query($sql);

/*
if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
*/

?>

<h1>Fresh off the Press!</h1>

<?php

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$name = $row['name'];
$posted = $row['posted'];
$summary = $row['summary'];
$author_name = $row['author_name'];
$author_email = $row['author_email'];

$mail_link = "mailto:$author_email";
$read_link = "article.php?id=$id";

echo "<h2>$name</h2>";
echo "<p>Posted By <a href=\"$mail_link\">$author_name</a> on $posted</p>";
echo "<p>$summary</p>";
echo "<p>To read more <a href=\"$read_link\">Click Here</a></p>";
echo "<hr />";
}
?>

Here is the database code


CREATE TABLE news_articles (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(65) NOT NULL DEFAULT 'Untitled Article',
posted DATETIME NOT NULL,
summary TEXT NOT NULL,
content TEXT NOT NULL,
author_name VARCHAR(65) NOT NULL DEFAULT 'Anonymous Author',
author_email VARCHAR(128) DEFAULT NULL,
PRIMARY KEY(id)
);




CREATE TABLE images(
id INT NOT NULL AUTO_INCREMENT,
thumb VARCHAR(65) NOT NULL,
image VARCHAR(65) NOT NULL,
caption VARCHAR(128) NOT NULL,
PRIMARY KEY(id)
);

What is going on here HELP!!!!!!!

[hoopyfrood]

Hi flforlife,

quite an easy solution, looks like you have forgotten to specify the established connection to use when looking for the database to connect to. Just add a second argument to your mysql_select_db() and off should you go!

PHP Code:

//    connect to database
function connect_to_database()
{
    $database                            =    array();
    $database['path']                    =    'path';
    $database['password']                =    'password';
    $database['user_name']               =    'user_name';
    $database['name']                    =    'database';

    $connection                          =    mysql_connect($database['path'], $database['user_name'], $database['password']) or die('no');
    mysql_select_db($database['name'], $connection) or die(mysql_error());
} 


This is more or less my generic connect_to_database() function, handy if you need to esatblish one and only ever one connection to the same database throughout the lifetime of your application. Easy to modify, hard to hack/hijack...

Good luck with your development,
hoopyfrood