Jump to content

ninimac

New Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Everything posted by ninimac

  1. Hi hope someone can help me. I'm creating a form which allows a use to update a record in an SQL database. I want to populate the form with the current data in that record. I've got it working fine for the input boxes and text areas but don't know how to do it for the drop down box (first in the form). Any help is greatly appreciated! :-\ $query1 = "SELECT * FROM articles where id=".$rowid.""; $getvals = mysql_query($query1); while($row = mysql_fetch_array($getvals, MYSQL_ASSOC)){ ?> <form method="post"> <table width="400" border="0" cellspacing="1" cellpadding="2"> <tr> <td width="100">Section:</td> <td> <select name="a_section" id="a_section"> <option value="gw">Global Warming</option> <option value="ol">Ozone Layer</option> <option value="ae">Alternative Energy</option> </select> </td> </tr> <tr> <td width="100">Title:</td> <td><input name="a_title" type="text" id="a_title" value= "<?php echo htmlentities($row['a_title']); ?>"> </td> </tr> <tr> <td width="100">Synopsis:</td> <td><TEXTAREA name="a_synopsis" type="text" id="a_synopsis" rows="6" cols="32" value=""><?php echo htmlentities($row['a_synopsis']);?></TEXTAREA></td> </tr> <tr> <td width="100">Article Text:</td> <td><TEXTAREA name="a_text" type="text" id="a_text" rows="6" cols="32" value=""><?php echo htmlentities($row['a_text']);?></TEXTAREA></td> </tr> <tr> <td width="100">Image:</td> <td><input name="a_image" type="text" id="a_image" value="<?php echo $row['a_image'];?>"></td> </tr> <tr> <td width="100">Thumbnail Image:</td> <td><input name="a_thumb_image" type="text" id="a_thumb_image" value="<?php echo $row['a_thumb_image'];?>"></td> </tr> <tr> <td width="100">Author Name:</td> <td><input name="a_author" type="text" id="a_author" value="<?php echo $row['a_author'];?>"></td> </tr> <tr> <td width="100"> </td> <td><input name="add" type="submit" id="add" value="Add Article"></td> </tr> </table> </form> <?php }
  2. Oh my god....I think I love you! Thanks a million!
  3. Hi there hope somebody can help me. I'm new to PHP and MySQL so forgive me! I'm trying to retrieve articles from a database. The following code works fine but I only want to display one record. When I change the select statement to $query = "SELECT TOP 1 * FROM articles WHERE a_section='ae' order by id DESC"; It goes belly up and I get this error message: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource. <?php $query = "SELECT * FROM articles WHERE a_section='ae' order by id DESC"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ echo "<table><tr><td class='arthead'>$row[a_title]</td></tr>". "<tr><td>". "<img src='images/$row[a_image]'>$row[a_text]". "</td></tr>". "<tr><td class='artfoot'>". "Published by $row[a_author] on "; $upload_date=date("d-m-Y g:i",strtotime($row[a_date_stamp])); echo $upload_date; echo "</td></tr></table>"; } ?> Any help would be greatly appreciated!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.