MySQL error.

[3raser]

My code:

 

$extract = mysql_query("SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1");
while ($row = mysql_fetch_assoc($extract))
{
echo "<div class='right'><h2>".$row['title']."</h2><div class='articles'>".nl2br(stripslashes($row['message']))."</div></div>";
} 

 

Error:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/stonedms/public_html/justin/Toplist/index.php on line 29

 

I've double checked my database, and it seems like I've have everything correct.

[cssfreakie]

can you do

<?php
print_r ($extract); //and paste what you get?
//place at bottom of code below the query

?>

[3raser]

can you do

<?php
print_r ($extract); //and paste what you get?
//place at bottom of code below the query

?>

 

Tried that and it doesn't seem to print out anything.

 

<?php

$extract = mysql_query("SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1");
while ($row = mysql_fetch_assoc($extract))
{
echo "<div class='right'><h2>".$row['title']."</h2><div class='articles'>".nl2br(stripslashes($row['message']))."</div></div>";
}

print_r ($extract);

?>

[kenrbnsn]

Replace

<?php
$extract = mysql_query("SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1");
?>

with

<?php
$q = "SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1";
$rs = mysql_query($q) or die("problem with the query: $q<br>" . mysql_error());
$extract = mysql_query($rs);
?>

 

And see if you get an error printed.

 

Ken

[cssfreakie]

seems $extract is empty and certainbly not an array.

you can double check it by

doing

 

echo $extract; //it should Print  Array()

[3raser]

Replace

<?php
$extract = mysql_query("SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1");
?>

with

<?php
$q = "SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1";
$rs = mysql_query($q) or die("problem with the query: $q<br>" . mysql_error());
$extract = mysql_query($rs);
?>

 

And see if you get an error printed.

 

Ken

 

problem with the query: SELECT id,title,message FROM blog ORDER BY id DESC LIMIT 1

No database selected

 

Edit:

 

I do have the correct mysql connect information.

[kenrbnsn]

The error says "No Database Selected". Please show the code where you select the DB (remove any connection details like username/password).

 

Ken

[3raser]

The error says "No Database Selected". Please show the code where you select the DB (remove any connection details like username/password).

 

Ken

 

<?php

session_start();

 

$title = "MCTop";

$description = "The site to find your popular SMP needs!";

 

$mysql_host = "localhost";

$mysql_database = "";

$mysql_user = "";

$mysql_password = "";

 

mysql_connect("$mysql_host", "$mysql_user", "$mysql_password");

mysql_select_db("$mysql_database");

 

?>

[BlueSkyIS]

there is no need to put double-quotes around lone variables. i would also check for errors after executing mysql commands...

 

mysql_connect($mysql_host, $mysql_user, $mysql_password) or die(mysql_error());
mysql_select_db($mysql_database) or die(mysql_error());

 

[3raser]

I did the above, yet it still didn't work. The query seems to be hard headed.

[jcbones]

What error did mysql_select_db() return?

 

BTW

$extract = mysql_query($rs);
//should be:
$extract = mysql_fetch_assoc($rs);
//because mysql_query returns a resource result, and the fetch functions return array's