Page 1 of 1

Editing through row id

Posted: Sat Apr 18, 2009 3:13 am
by max_power
Hi,

First things first, I am creating a current events page, where as an admin I can go in there and add more events, edit them and delete them. Now my problem is in the editting part of it. What I want to do is first view all the events and edit them. What I have got is, as each event is displayed in a row I have attached an edit button to each row, so what I want to do is, when I click a particular edit button on a particular row, it only edits that row's events, I am having trouble with my SQL query, as right now when I click the edit button I can edit all the events.

My sql query along with the form code is:

Code: Select all

 
$sql = "SELECT id,author,last_updated,category,event,summary FROM events WHERE `id` = '".$row['id']."'";
$rs = @mysql_query($sql,$conn);
    if (!$rs)
     {exit("Error in SQL");}
 
while ($row = mysql_fetch_array($rs))
{
    {
  
  ?>
  <tr>
        <td valign="top">
        <table>
                    <table border="0" rules="none" cellpadding="1" cellspacing="2" bgcolor="lightgrey" align="center" width="760" height="100">
                    <tr>
                        <td colspan="30" bgcolor="#696969" valign="middle"  height="35" align="center">
                            <font size="4"><b>Current Events</b></font>
                        </td>
                    </tr>
  <td><form name="EditDetails" method="post" form action="manage-viewevents.php">
<input type="submit" value="Edit">
<input type="hidden" name="SaveChanges" value="1">
<input type="hidden" name="EditDetails" value="0">
<tr height="50">
                        <td>
                            Event ID:
                        </td>
                    
                        <td><input type="number" name="id" value="<? echo $row['id']; ?>"size="10"></td>
                        
                    </tr>
                    <tr height="50">
                        <td>
                            Author:
                        </td>
                    
                        <td><input type="text" name="author" value="<? echo $row['author']; ?>"size="20"></td>
                        
                    </tr>
                    <tr height="50">
                        <td>
                            Last updated:
                        </td>
                    
                        <td><input type="text" name="last_updated" value="<? echo $row['last_updated']; ?>"size="20"></td>
                        
                    </tr>
                    <tr>
                        <td width="130">
                            Category:
                        </td>
                                
                        <td>
                            <select name="category" value="<? echo $row['category']; ?>">
                            <option value="category1">category1</option>
                            <option value="category2">category2</option>
                            <option value="category3">category3</option>
                            <option value="category4">category4</option>
                            </select>
 
                        </td>
                    </tr>
                    <tr height="50">
                        <td>
                            Event:
                        </td>
                    
                        <td>
                            <textarea name="event" value="<? echo $row['event']; ?>" rows="12" cols="25"></textarea>
                        </td>
                        
                    </tr>   
                    </tr>
                    <tr height="50">
                        <td>
                            Summary:
                        </td>
                    
                        <td>
                            <textarea name="summary" value="<? echo $row['summary']; ?>" rows="5" cols="25"></textarea>
                        </td><br><br>
                        </tr>
                        <tr> 
           <td width="150"></td>
           <td width="200">
           <img src="images/bold.gif" alt="Bold" border="0" onClick="addsmiley(\'<b>Your Text Here</b>\')" style="cursor: pointer;">
           <img src="images/italic.gif" alt="Italic" border="0" onClick="addsmiley(\'<i>Your Text Here</i>\')" style="cursor: pointer;">
           <img src="images/underline.gif" alt="Underline" border="0" onClick="addsmiley(\'<u>Your Text Here</u>\')" style="cursor: pointer;">
           <img src="images/link.gif" alt="Insert Link" border="0" onClick="addsmiley(\'<a href="http://www.somesite.com" target="_blank">Your Link</a>\')" style="cursor: pointer;">
           <img src="images/newline.gif" alt="New Line" border="0" onClick="addsmiley(\'<br>\')" style="cursor: pointer;">
           </td>
           </tr>
            <tr> 
           <td>&nbsp;</td>
           <td><div align="right">
           <input type="submit" name="submit" value="SaveChanges">
           </div></td></tr></form></table></td></tr>
</form><td></tr><?
  }
 
}
@mysql_close($conn);
echo "</table></td></tr>";
 
But this comes up with nothing all. Just a note, I havent set up the update query yet as I have got it working, just waiting for this particular part to work and I am set.

Any ideas?

Thanks.