Unknown column ??

poppy28

I uploaded a script for displaying information I've entered into my mysql database, and I'm getting the following error: Unknown column 'title' in 'field list'

I've double, triple checked the script to make sure that title exists and is spelled correctly. Does anyone know why this would happen?

Here's my script:

<?
$host="localhost";
$user="username";
$password="password";
$dbname="dbname";
$dbtable="news";

$dbh=mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("dbname");
?>

<body>

<?
$sql = "select title, news, author, date;";
$result = mysql_query($sql, $dbh) or die( mysql_error() );

$title= mysql_result($result, 0, "title");
$news= mysql_result($result, 0, "news");
$author= mysql_result($result, 0, "author");
$date= mysql_result($result, 0, "date");
?>

<table width="100%">
<tr>
<td colspan="8">Basic Informantion</td>
</tr>
<tr>
<td>Name:</td>
<td><? print "$title" ?></td>
<td>Weight:</td>
<td><? print "$news" ?></td>
<td>Day:</td>
<td><? print "$author" ?></td>
<td>Date:</td>
<td><? print "$day" ?></td>
</tr>
</table>
</body>
</html>

devinemke

your query is incomplete. you need to specify a table:

$sql = "SELECT title, news, author, date FROM tablename";