Evasive Error

Bailz

Can someone PLEASE tell me what is wrong with the following code:

<head>
</head>
<?php

function mysql_die($error = "unknown")
{
echo "<h1>Error:". $error."</h1>";
  exit;
}

$db = mysql_connect("localhost","bornrun","") or mysql_die("Unable to Connect");
mysql_select_db("bornrun_uk_db",$db) or mysql_die("Unable to Select");

$request = "SELECT * FROM 'news' WHERE id=".$db or mysql_die("Unable to request");
$result = mysql_query($request,$db) or mysql_die("Unable to get result");
$news = mysql_fetch_object($result) or mysql_die("Unable to fetch object");
mysql_free_result($result) or mysql_die("Unable to free result");

?>
</head>
<body background="art/bground.JPG">
<?php echo $news->date ?>
<br />
<?php echo $news->author ?>
<br />
<?php echo $news->news ?>
</body>
</html>

Thanks,
Bailz.

stolzyboy

what's this tell you, and also i marked that you need the id somewhere, not sure where you have it coming from, but you had it equal to the $db, obviously not what you wanted

<head> 
</head> 
<?php 


$db = mysql_connect("localhost","bornrun","") or die(mysql_error()); 
mysql_select_db("bornrun_uk_db",$db) or die(mysql_error()); 

$request = "SELECT * FROM 'news' WHERE id='$id';"; //you need to put something in for id
$result = mysql_query($request,$db) or die(mysql_error()); 
$news = mysql_fetch_object($result) or die(mysql_error()); 
?> 
</head> 
<body background="art/bground.JPG"> 
<?php echo $news->date; ?> 
<br /> 
<?php echo $news->author; ?> 
<br /> 
<?php echo $news->news; ?> 
</body> 
</html>

Bailz

I followed the Lycos tutorial and that is the code that I ended up with.

I was under the impression that that code would display all of the records held in the database.

I guess I'm wrong though.

I am getting the error that corresponds with the line:

$result = mysql_query($request,$db);

The entire code for reference is:

<head>
</head>
<?php

function mysql_die($error = "unknown")
{
echo "<h1>Error:". $error."</h1>";
  exit;
}

$db = mysql_connect("localhost","bornrun","") or mysql_die("Unable to Connect");
mysql_select_db("bornrun_uk_db",$db) or mysql_die("Unable to Select");

$request = "SELECT * FROM 'news' WHERE id=1".$id or mysql_die("Unable to request");
$result = mysql_query($request) or mysql_die("Unable to get result");
$news = mysql_fetch_object($result) or mysql_die("Unable to fetch object");
mysql_free_result($result) or mysql_die("Unable to free result");

?>
</head>
<body background="art/bground.JPG">
<?php echo $news->date ?>
<br />
<?php echo $news->author ?>
<br />
<?php echo $news->news ?>
</body>
</html>

Please show me where I am going wrong!!!

Thanks,
Bailz.

stolzyboy

that means that your query isn't correct, or you aren't connected correctly to mysql, or your db

Bailz

But surely the function mysql_die would catch it if wasn't connecting and I'd get the error "Unable to Connect", and if my query wasn't right I'd get the "Unable to Query". That is my understanding of it but I'm guessing you'll tell me otherwise.

So what is wrong with my queries if they are wrong?

I have created my database correctly(i think) and have stated all of the correct entites etc.

Where am I going wrong?

Thanks,

Bailz.

This is all Lycos' fault!!! :mad: