pets2soul

ahh....sorry that I messed up this topic....I extracted my new question to a new post....

and if I do that...all the entries from 2008-01-01 to 2008-12-31 would be shown....

Hello there, The more pages I'm working, more questions popped up...and since this one is similar to this subject, so I'm just posting it here.... What I'm trying to do now on another page, is to show only the article entries from the latest day...this is what I got in mind: $result=mysql_query("SELECT * FROM news WHERE date BETWEEN '2008-01-01' AND '2008-12-31' GROUP BY date ORDER BY fname DESC LIMIT 1"); I have "date" as one of my database column, in the format of yyyy-mm-dd. However, if I set the LIMIT to be 1, only the ONE last entry would be shown, but what do I do if I have more than one entries made in the same day? What I missed in the code?

Great! It's working now!! Thanks, sasa!

Don't know if this helps, but echo "<input type='radio' name='interest' value='$Category'\n"; is not closed... echo "<input type='radio' name='interest' value='$Category'>\n";

Wazzzup people, I'm trying to make a index sort of page, which will categorize the database entries into years, from 2006 to date("y")-1. Also I want to show the number of entries in each year. This is probably simple, but I'm jammed some where...below is my code, please kindly let me know how should I correct and improve it. Thank you belly machi! <?php echo "<table width='300' border='0' cellspacing='0' cellpadding='0'> <tr> <td colspan='3' height='38' align='left' valign='top'> <a href='dataentry.php'>Add</a> <a href='datalist.php'>List</a> <a href='annuallist.php'>Annual</a></td> </tr>"; $con=mysql_connect("servername","username","password") or die('Could not connect: '.mysql_error()); mysql_select_db("dbname",$con); $start_y='2006'; $end_y=date("y")-1; for($i=$start_y; $i<$end_y; i++){ $year="'$i-01-01' AND '$i-12-31'"; $q = "select count(*) as num_ent1 from table WHERE date BETWEEN $year"; $res = mysql_query($q) or die('Problem with query: ' . $q . '<br>' . mysql_error()); $rw = mysql_fetch_assoc($res); echo "<tr> <td width='100' height='28'>Year</td> <td width='100'># of Entries</td> <td width='100'>Enter</td> </tr>"; echo "<tr>"; echo "<td height='28'>".$i."</td>"; echo "<td>".$rw['num_ent1']."</td>"; echo "<td><a href=dataedit.php?".$i.">Go</a></td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?>

Ahhhhh.....you are absolutely right!!! It is working now! Thank you, thank you!

Hello everyone, I'm converting my plain html website into a php one, and I'm working on the backend now... I built a page to submit articles to MySQL, and another page to list all the entries in the database, from there I can link to the article editing page to call up article headline, body and date etc. into their own field in a form...However, the editing page is not working properly... I made some screen captures to describe the problem... 1. http://www.prophet-records.com/images/phpprob01.gif This is my article submitting page, I captured it to show you what supposed to be in the article... 2. http://www.prophet-records.com/images/phpprob02.gif This is the article editing page...as you can see...article headline and date showed up, but the textareas appear to be empty. 3. http://www.prophet-records.com/images/phpprob03.gif I checked its source code with my browser, the highlighted part is where the article body is, it seems alright there, but it just doesn't appear on the web page.... Below is the code for the article editing page.... <?php $con = mysql_connect("hostname","username","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("dbname", $con); $sql = mysql_query("SELECT * FROM table WHERE fname='$fname'") or die(mysql_error()); while ($rw = mysql_fetch_assoc($sql)) { //now we display a form with the users info in text boxes and areas. echo '<form action="update.php?fname='.$rw['fname'].'" method="post"> <table width="510" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="38" align="left" valign="top"><a href="dataentry.php">Add</a> | <a href="datalist.php">List</a> | <a href="annuallist.php">Annual</a></td> </tr> <tr> <td height="28" align="left">Title: <input name="headline" type="text" maxlength="40" value="'.$rw['headline'].'"> </td> </tr> <tr> <td align="left">Content:<br><textarea name="newscont" cols="70" rows="15" value="'.$rw['newscont'].'"></textarea> </td> </tr> <tr> <td align="left"><input name="date" value="'.$rw['date'].'"> </td> </tr> <tr> <td align="left">Brief:<br><textarea name="newsbrf" cols="70" rows="10" value="'.$rw['newsbrf'].'"></textarea> </td> </tr> <tr> <td height="28" align="left">File Name: <input name="fname" type="text" maxlength="30" value="'.$rw['fname'].'"> </td> </tr> <tr> <td height="32" align="center"><input type="submit"> </td> </tr> </table> </form>'; } mysql_close($con) ?> Would anyone tell me what went wrong?

Ouch...my question revealed how immature I'm in the PHP world.... Thanks to Vizor and abdbuet, the answers are very helpful!!

Hello everyone! I'm new to the PHP world, I'm trying to make a news archive type of web page. So far, I've done making an admin page, where I can submit articles to a MySQL database, I know how to have all the stored articles to be shown on one page, however, I don't know how to have only the latest 5 to be shown... ??? ??? The columns I have in my database are article title, article body and entry date. Would anyone give me some guidance? Appreciate!