richarddddd

I would like to have a mechanism that I can show records by using a pull down menu. I created this script (and probably there a lot of mistakes in it and therefore I need the help from you): $query="SELECT answer_date, category, countryb, question, answer FROM faqhcch WHERE $zoekcat LIKE 'categoryb' ORDER BY answer_date DESC LIMIT 0,7"; $result=mysql_query($query); $num=mysql_num_rows($result); mysql_close(); ?> <form name="form1" method="post" action="<? echo $PHP_SELF; ?>"> <select name="zoekcat"> <option>Select Member State</option> <option>Albania</option> <option>Argentina</option> <option>Australia</option> <option>Austria</option> <option>Belarus</option> <option>Belgium</option> <option>Bosnia and Herzegovina</option> <option>Brazil</option> <option>Bulgaria</option> <option>Canada</option> <option>Chile</option> <option>China, Peoples Republic of</option> <option>Croatia</option> <option>Cyprus</option> <option>Czech Republic</option> <option>Denmark</option> <option>Egypt</option> <option>Estonia</option> <option>Finland</option> <option>France</option> <option>Georgia</option> <option>Germany</option> <option>Greece</option> <option>Hungary</option> <option>Iceland</option> <option>Ireland</option> <option>Israel</option> <option>Italy</option> <option>Japan</option> <option>Jordan</option> <option>Korea, Republic of</option> <option>Latvia</option> <option>Lithuania</option> <option>Luxembourg</option> <option>Malaysia</option> <option>Malta</option> <option>Mexico</option> <option>Monaco</option> <option>Morocco</option> <option>Netherlands</option> <option>New Zealand</option> <option>Norway</option> <option>Panama</option> <option>Paraguay</option> <option>Peru</option> <option>Poland</option> <option>Portugal</option> <option>Romania</option> <option>Russian Federation</option> <option>Serbia and Montenegro</option> <option>Slovakia</option> <option>Slovenia</option> <option>South Africa</option> <option>Spain</option> <option>Sri Lanka</option> <option>Suriname</option> <option>Sweden</option> <option>Switzerland</option> <option>The former Yugoslav Republic of Macedonia</option> <option>Turkey</option> <option>Ukraine</option> <option>United Kingdom of Great Britain and Northern Ireland</option> <option>United States of America</option> <option>Uruguay</option> <option>Venezuela</option> </select> </form> <hr> <? $i=0; while ($i < $num) { $answerdate=mysql_result($result,$i,"answer_date"); $category=mysql_result($result,$i,"category"); $countryb=mysql_result($result,$i,"countryb"); $question=mysql_result($result,$i,"question"); $answer=mysql_result($result,$i,"answer"); ?> <table width='97%' border='0'> <tr bgcolor="#330066"> <td width="14%"><font color="#FFFFFF">&nbsp;</font></td> <td width="86%"><strong><font color="#FFFFFF" size='2' face='Arial, Helvetica, sans-serif'><? echo $countryb; ?></font></strong></td> </tr> <tr> <td bgcolor="#00CCCC"><div align='right'></div> <div align='right'></div></td> <td><font size='3' face='Arial, Helvetica, sans-serif'><b>&nbsp;<? echo $category; ?></b></font></td> </tr> <tr> <td bgcolor="#00CCCC"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><em><strong>QUESTION:</strong></em></font></div></td> <td><font size='2' face='Arial, Helvetica, sans-serif'><? echo $question; ?> </font></td> </tr> <tr> <td bgcolor="#00CCCC"><div align='right'><em><font size='2' face='Arial, Helvetica, sans-serif'><strong>ANSWER:</strong></font></em></div></td> <td><font size='2' face='Arial, Helvetica, sans-serif'><? echo $answer; ?></font></td> </tr> <tr> <td bgcolor="#00CCCC"><div align='right'><em><font size='2' face='Arial, Helvetica, sans-serif'><strong>Date:</strong></font></em></div></td> <td><font size='2' face='Arial, Helvetica, sans-serif'><? echo $answer_date; ?></font></td> </tr> </table> <hr> <? ++$i; } echo "</table>"; ?> </body> </html>

Dear all, I need your help!!!! I think my problem is not hard to solve, but I am a newbie and I am designing my first PHP MySQL website. I would like to know how I can make a loop so that PHP is retrieving all the data that is in the MySQL database. Right now, It is looping, but it publish the same content in each field. Please could you help me? This is the PHP file: <?php $query = "SELECT postdate, title, newstextshort, newstextlong, source, sourcehyperlink, category FROM news ORDER BY postdate DESC"; $result= mysql_query($query) or die("unable to find selected job number"); $postdate=mysql_result($result,$i,"postdate"); $title=mysql_result($result,$i,"title"); $newstextshort=mysql_result($result,$i,"newstextshort"); $newstextlong=mysql_result($result,$i,"newstextlong"); $source=mysql_result($result,$i,"source"); $sourcehyperlink=mysql_result($result,$i, "sourcehyperlink"); $category=mysql_result($result,$i,"category"); while ($row = mysql_fetch_array($result)) { $extract($row); echo "<table width='75%' border='0'>\n"; echo "<tr>\n"; echo "<td width='15%'><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'>Date:</font></div></td>\n"; echo "<td colspan='2'><font size='2' face='Arial, Helvetica, sans-serif'>$postdate</font></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'><font face='Arial, Helvetica, sans-serif'><font size='2'></font></font></font></div></td>\n"; echo "<td colspan='2'><font size='2' face='Arial, Helvetica, sans-serif'><b>$title</b></font></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'></font></div></td>\n"; echo "<td colspan='2'><font size='2' face='Arial, Helvetica, sans-serif'>$newstextshort [<a href='$sourcehyperlink'><i>more</i></a>]</font></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'>Published by:</font></div></td>\n"; echo "<td width='55%'><font size='2' face='Arial, Helvetica, sans-serif'>$source</font></td>\n"; echo "<td width='30%'><font size='2' face='Arial, Helvetica, sans-serif'>Click <a href='$sourcehyperlink'><b>here</b></a> to enter website</font></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'><font face='Arial, Helvetica, sans-serif'><font size='2'>Category:</font></font></font></div></td>\n"; echo "<td colspan='2'><font size='2' face='Arial, Helvetica, sans-serif'>$category</font></td>\n"; echo "</tr>\n"; echo "</table>\n"; echo "<hr>\n"; } ?>