limiting query

[deadlydemon]

Hello

Im trying to get my site to display all the records on the homepage that hav the catogory home.

when i display all the records in a table using

$query="SELECT * FROM news ORDER BY id DESC";
$result=mysql_query($query);

It works.

But when i try to limit using :

$page=home
$query="SELECT * FROM news WHERE category='$page' ORDER BY id DESC";
$result=mysql_query($query);

I get a blank screen.
I really dont get why it is not working.
My full script is bellow. Any help really apreciated.

<?
include("db/db.php");
$page=home
$query="SELECT * FROM news WHERE category='$page' ORDER BY id DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$subject=mysql_result($result,$i,"subject");
$user=mysql_result($result,$i,"user");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$message=mysql_result($result,$i,"message");

?>

<div class="byline">
<h1><?php echo "$subject"; ?> </h1>
<div id="main-text">
<h2><?php echo "$user on $date"; ?></h2>
</div>
<div id="main-text">
<p class="style1"><?php echo "$message"; ?></p>
</div>
</div><br><br><div id="top"><br><br>
<?
$i++;
}
?>

[michaelkenneth]

Hi,
after
$page=home
$query="SELECT * FROM news WHERE category='$page' ORDER BY id DESC";
$result=mysql_query($query);

type in:
die(mysql_error());

There should be an error outputed, post that error back here if you can't figure it out.

[deadlydemon]

LoL, it not displaying any errors still

[mourisj]

$page="home";

[Atron_Seige]

I agree with mourisj, setting it to a string value is bound to help.

^_

Otherwise, test the value to $page by using
echo("Page Name: $page");

Try echo(count($result)); to give you a number on the amount of records returned. This helps you realize when you are doing something wrong later on in the code 🙂

Atron Seige

[Roger_Ramjet]

Use the following syntax ALWAYS, it will print the query and the error message whenever you have a problem, makes debugging much easier.

$sql = "SELECT * FROM news WHERE category='" . $page . "' ORDER BY id DESC"; 
$result = mysql_query($sql) or die($sql . '<br />' . mysql_error());

And forget the lazy $var without escaping from the string, use " . $ var . "

You will avoid several problems and make your code much more human-friendly, especially if you are using a decent editor that formats indents and colour code for you (eg UltraEdit).