Select certain columns...

[evo4ever]

Hey. I have an article system which pulls out articles from the db, but the obsticle ive bumped into is some rows may have not be published. My table...

id | article | author | pub
1 test me No
2 test2 me2 Yes

I only want to get rows out which are published (with pub = Yes). How do I do this in a mysql query? Thanks,

[djKale]

SELECT * FROM (TABLE NAME) WHERE pub = 'yes'

The asterisk designates that you want to select all fields.

Kale

[Tristan_Wells]

I think this will work

<?php
mysql_query("SELECT id,article,author FROM table WHERE `pub`='yes'");
?>

EDIT: A bit late :p

[evo4ever]

Yeah I found that out about 10mins ago :rolleyes: It's stupid really, because I've been using scripts which get certain columns by ID, getting by pub is just the same... how stupid of me lol

"SELECT * FROM articles WHERE id=1 AND pub='Yes'";

🙂