[Sportznow]

Hello,
I created a database where I can put news for my site. It has 4 fields, the nid which is auto increment, the headline, the body, and teams (baseball teams) to which it pertains. This way on the team pages I can have the latest news (or highest news id, nid). I have everything good so far except when I try to pick the latest news for only that team. Here is the code I am using:
<?
$hostname = "localhost";
$username = "******";
$password = "******";
$dbName = "*******";

mysql_connect($hostname, $username, $password) or die("DB connection unavailable");
mysql_select_db( "$dbName") or die( "Unable to select database");

$sql = "SELECT * FROM news WHERE teams LIKE '%Atl%' ";
$sql .= "ORDER BY nid ASC ";

$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$variable1=$row["nid"];
$variable2=$row["stitle"];
$variable4=$row["body"];
}
?>

When I try this I get this error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY nid ASC LIMIT 0, 30' at line 1. If I run the sql statement just how it is in phpmyadmin it works good. If I take that line out I get query is empy. Help is greatly appreciated. Oh and just so you know...the variables are all used later embedded in html.

[brendandonhu]

I didn't test this, but I think you need to change those two lines to

$sql = "SELECT * FROM 'news' WHERE 'teams' LIKE '%Atl%' ";
$sql .= "ORDER BY 'nid' ASC ";

[Sportznow]

When I switch to that I get: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''news' WHERE 'teams' LIKE '%Atl%' ORDER BY 'nid' ASC' at line 1

[deuce868]

take out the quotes around the table name and field name

[Sportznow]

Then it will go back to what I originally had: $sql = "SELECT * FROM news WHERE teams LIKE '%Atl%' ";

[deuce868]

in the line after you set the $sql variable output the final SQL string with echo( $sql ); and post it here.

[punjabian263]

run you code step by step and printing error message along.

$hostname = "localhost"; 
$username = "******"; 
$password = "******"; 
$dbName = "*******"; 
$id=mysql_connect($hostname, $username, $password)
if($id)echo"successfully connectd";else die("DB connection unavailable"); 
$select=mysql_select_db( "$dbName")
if($select)echo "database successfully selected";else die( "Unable to select database"); 

$sql = "SELECT * FROM news WHERE teams LIKE '%Atl%' ";
$sql .= "ORDER BY nid ASC ";
echo $sql;  //check the right syntax of the query, and check this query also on mysql prompt;
$result = mysql_query($sql) or die(mysql_error());
if($result) echo "records successfully retrieved";

[Sportznow]

Hmm, very, very weird. All of a sudden it is working on one of the pages but if I copy paste the same code, it isn't working on another...