ERROR

[Mod-Jay]

Error:

Fatal error: Query Error: No database selected in /home/a5640714/public_html/school/aa/pages/news.php on line 38

 

Code:

	                <?php
include '../inc/connect.php';
		$result = mysql_query("SELECT * FROM blog ORDER BY id ASC") or trigger_error('Query Error: ' . mysql_error(), E_USER_ERROR);
		//the while loop
		while($r=mysql_fetch_array($result))
		{
$id=$r["ID"];
$name=$r["name"];
$desc=$r["descr"];
$date=$r["date"];
echo "
<tr>
<td>
News Name: $name
</td>
<td>
News Desc: $desc
</td>
<td>
Date Posted: $date
</td>
<td>
<a href='news.php?action=edit&id=$id'>Edit</a>
</td>
<td>
<a href='news.php?action=delete&id=$id'>Delete $name</a>
</td>
</tr>
";
}
?>

Line 38:

			$result = mysql_query("SELECT * FROM blog ORDER BY id ASC") or trigger_error('Query Error: ' . mysql_error(), E_USER_ERROR);

[Joshua F]

$id=$r["ID"];
$name=$r["name"];
$desc=$r["descr"];
$date=$r["date"];

Those aren't really needed, you can just use a php code to echo the stuff, but you can do it that way I guess.

[pornophobic]

Does connect.php have mysql_select_db in it with the database you're wanting to use? If not, you'll need to put it in there or your current file to tell php which database to use.

[wildteen88]

What is in inc/connect.php?

 

You need to be connected to mysql and have a database selected before you can start quering tables. You do not appear to have a database selected. That is why you are getting this error:

Fatal error: Query Error: No database selected in /home/a5640714/public_html/school/aa/pages/news.php on line 38

[Mod-Jay]

Fixed