roondog Posted April 14, 2007 Share Posted April 14, 2007 I'm working through the php tutorials and am making a news script. In my table I have the articles numbered they also have a headline a timestamp and the story. What I want to do is only select stories from a certain month and then put them in order starting with the latest. I know i can use ORDER BY but how would only select those from a certain month.Another question, if i want each story in a new <div> so I can style them how to i do that? Do have to do a query for each story? Link to comment Share on other sites More sharing options...
Anders Moen Posted April 14, 2007 Share Posted April 14, 2007 Maybe you can use something like this: $d = date('M'); // In example it says "Apr" in the database, and the month now is Apr and then it shows those newsSELECT * FROM table WHERE date = '$d' ORDER BY id DESC The div thing, you want a different on each news or just make them valid? You can use class="" instead of id=""#something { } /* This is for id's */.something { } /* This is for classes */Hope this helps you a little Link to comment Share on other sites More sharing options...
roondog Posted April 14, 2007 Author Share Posted April 14, 2007 i should have explained the div thing a bit more clearly.I have this code. while($row = mysql_fetch_array($result)) { echo "#".$row['storynum'] . "<br /> " . $row['headline']."<br />".$row['published']."<br />".$row['story']; echo "<br />"; } i tried to do something like this while($row = mysql_fetch_array($result)) { echo <div id="news">"#".$row['storynum'] . "<br /> " . $row['headline']."<br />".$row['published']."<br />".$row['story']</div>; echo "<br />"; } but it wouldn't work. what should i do instead.I've solved this part now looked back over the tutorial and used the table example. Link to comment Share on other sites More sharing options...
roondog Posted April 14, 2007 Author Share Posted April 14, 2007 right i've got another question now. Every story has a number how do i get it to show just a certain amount of stories. Bearing in mind the top number is going to change so i cant just say between this number and this number. Link to comment Share on other sites More sharing options...
Matpatnik Posted April 14, 2007 Share Posted April 14, 2007 i tried to do something like thiswhile($row = mysql_fetch_array($result)) { echo <div id="news">"#".$row['storynum'] . "<br /> " . $row['headline']."<br />".$row['published']."<br />".$row['story']</div>; echo "<br />"; } but it wouldn't work. what should i do instead. you forgot to escape the double quote on the first echo it should look like this:while($row = mysql_fetch_array($result)){echo "<div id=\"news\">#".$row['storynum'] . "<br /> " . $row['headline']."<br />".$row['published']."<br />".$row['story'] . "</div>";echo "<br />";} and <div> tags need to be in between double quote too Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now