mysql query not working??

[martinb7]

hi, I am geting news out of a db and putting it on a webpage. the table structure:

uid | show | title | news | subBy | subDate

::code::

 <?php

include (&quot;config.php&quot;);

$conn = mysql_connect($host, $user, $pass);
mysql_select_db($db, $conn);
$queryNewsMain = mysql_query(&quot;SELECT * FROM wnews where show= '1' ORDER by subDate DESC&quot;) or die(mysql_error());

while ($r = mysql_fetch_array($queryNewsMain)) {
  		$title = $r[&quot;title&quot;];
		$news = $r[&quot;news&quot;];
		$dp = $r[&quot;subDate&quot;];
		$sb = $r[&quot;subBy&quot;];
		

	echo(&quot;<font size=2>
<table width=400 border=0 cellspacing=0 cellpadding=0>
  <tr> 
    <td background=$midtop>
<div align=center><font color=$txtcolor size=2><b>-</b> $title <b>-</b></font></div></td>
  </tr>
  <tr> 
    <td background=$mid> 
      <div align=center><font color=$txtcolor size=2>$news</font></div></td>
  </tr>
  <tr> 
    <td background=$midbot>
<div align=center><font color=$txtcolor size=2>Submitted: $dp by $sb</font></div></td>
  </tr>
</table></font>&quot;).&quot;<br><br>&quot;;
}
echo(&quot;<font size=2><a href=archive.php>News Archive</a></font>&quot;);
?>

the query doesn't like the show = '1' bit.

what im trying to do is: if in the table its got 1 in the show colum, it will show the post else if its got '0' it wont.

Any ideas??

http://webrevolt.tycooneden.com/test/

^^ link 4 query thats wrong ^^

thanx

Martin

http://webrevolt.tycooneden.com

also,is there a better way of listing data out of a db other than the while() loop? or anyother ways of using the while loop?

 

[martinb7]

the link for the page not working is:

http://webrevolt.tycooneden.com

 

[sleipnir214]

"Show" is a MySQL reserved word. Change the name of your table column.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[martinb7]

thanx that really helped

do u no of somewhere with all the reserved words for php and mysql??

thanx again

Martin

http://webrevolt.tycooneden.com

 

[dkdude]

Reserved words for MySQL can be found

here:

http://www.mysql.com/doc/en/Reserved_words.html

... and for PHP

here:

http://dk.php.net/manual/en/reserved.php

Good luck §;O)


Jakob