:
Code:
:
CREATE TABLE `post` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `****` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `email` varchar(65) NOT NULL default '', `status` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=46 ;
status int 0
post
!!!
PHP:
select * from post where status = 1 order by ID DESC
:
select >>>> from >>>> post >>>> where >>>> status >>>> = >>>> 1 >>>>>