[Resolved] Invalid mySQL Result Source

[Reality15]

Can anyone help me figure out what the problem in my script is?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /path/to/newsarticles.php on line 12

<?php

//CONNECT TO THE DATABASE
$link=mysql_connect('HOST','USERNAME','PASSWORD')
or die('Could not connect: ' . mysql_error());
mysql_select_db('DATABASE') or die('Could not select database');

$id = $_GET['id'] ;

//GET ALL OF THE ENTRIES FROM ONE CATEGORY IN A DIFFERENT ORDER
$result = mysql_query("SELECT * FROM 'news' WHERE 1 AND 'id' = ' $id ' LIMIT 0 , 1");
while ($array = mysql_fetch_array($result)) {
$year = $array['year'];
$mo = $array['month'];
$date = $array['date'];
$author = $array['author'];
$full = $array['full'];
$headline = $array['headline'];

switch($mo) {
	case '01':
$month = "January";
	break;
	case '02':
$month = "February";
	break;
	case '03':
$month = "March";
	break;
	case '04':
$month = "April";
	break;
	case '05':
$month = "May";
	break;
	case '06':
$month = "June";
	break;
	case '07':
$month = "July";
	break;
	case '08':
$month = "August";
	break;
	case '09':
$month = "September";
	break;
	case '10':
$month = "October";
	break;
	case '11':
$month = "November";
	break;
	case '12':
$month = "December";
	break;
	}
}

//DISCONNECT FROM THE DATABASE
mysql_close($link);
?>

Thanks!

~ Reality

[drew010]

most likely the query is bad.
try

if (!$result) {
  echo mysql_error();
  exit;
}

right after your query.

[bradgrafelman]

Debugging 101

[Reality15]

Originally posted by drew010
most likely the query is bad.
try

if (!$result) {
  echo mysql_error();
  exit;
}

right after your query. [/B]

It gave me this:
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 1 AND 'id' = ' 1 ' LIMIT 0 , 1' at line 1

What I had to do was take the quotes out from around news.

[drew010]

i think the query will work best as
SELECT * FROM news WHERE id = '$id'

having WHERE 1 is always going to be true, and LIMIT 0,1 is kinda repetitive since it should do that automatically if the ids are unique

[Reality15]

Ah, yes, that's even better. Thank you.