Database with Column "Approved"

[onestopplay]

So I have a database,
id | title | approved
1 | title1 | yes
2 | title2 | yes
3 | title3 | no

Then I have this PHP script:


<?php
//opens connection to mysql server
$dbc = mysql_connect("localhost", "username", "password");
if (!$dbc)
{
die('Not connected :' . mysql_error());
}
//select database
$db_selected = mysql_select_db("mydatabase", $dbc);
if (!$db_selected)
{
die("cant connect :" . mysql_error());
}

$result = mysql_query("SELECT * FROM mytable ORDER BY title");

while($row = mysql_fetch_array($result))
{
echo "" . $row['title'] . "";
echo "<BR>";
}
mysql_close($dbc);
?>

That displays each Title. How do I make it so that only approved=yes titles show? Thanks in advanced for any help.

[SChaput]

Try this...


$result = mysql_query("SELECT * FROM mytable ORDER BY title WHERE approved='yes'");

[onestopplay]

One more thing...
what if I want to say
WHERE approved='yes'

AND somethingelse='something'

Can I say AND?

[SChaput]

Yes you can.



$result = mysql_query("SELECT * FROM mytable ORDER BY title WHERE approved='yes' AND another='no'");

[heavensgate15]

ei.. w8 a minute... I think it's not possible that in your query, the order by will be put first then the where clause... Because there is a sequence which clause will be put first.... I think the complete (not a complete one, complete only in the clause part) syntax of the select statement is:

Select * from Table_name
[where clause]
[group by]
[having]
[order by]
[limit];

You must follow the sequence else it will generate an error.. though you can omit some of the clauses, like I will only use the [order by] clause, But if you use the [order by] clause, make sure that the [where],[group by],and [having] clause is not put in the same select statement afterward.

[onestopplay]

So I was working on my site today and I kept getting this error message that was really annoying me on most of my scripts. Finally, I fixed it by doing WHERE first, then ORDER BY. Thanks for your help.