Select from

Databases
1

Hello,

I have a database named ‘panel’, and i am trying to select from a table named announcements to display what is in that table. I am not sure how to do this.

I have:

	<?
$query == mysql_query("SELECT * FROM `announcements`")
		?>

but I do not think that is right… Can someone help?

2

$query = mysql_query(“SELECT * FROM announcements”)

use a single = to assing the result of the query to the $query variable

And of course, like Ibazz said, try not to use the *

3 

select 
     col1
   , col2
   , col3 
from table

Try not to use the star selector coz it will more often than not, give you real headaches.