PHP - Edit mySQL entries via webpage?

[adamFTW]

Thanks, but I don't understand how I can get the comment ID?

[adamFTW]

I can't edit, please merge.

select comment from comments where id = '$id'
If my database table was petitio, would I replace comment or comments with petition? I'm pretty sure i'd replace comments but I want to double check.

And, I would really appreciate if someone could tell me how to get the ID, as this is the only thing holding me back now.

[MrCraig]

Add a new field to your database, make it a primary key and auto-increment.

Then do

<?php
$get_id = mysql_fetch_array(mysql_query("select id from comments"));
$id = $get_id[id];
?>

And im presuming your using a while loop to display comments, so it should be in that..

[Dentafrice,]

Of course it is possible. Not very clean code, not on my PHPDesigner computer.

<?php
include "config.php";
 
$get_query = mysql_query("SELECT * FROM table ORDER BY id DESC");
while($row = mysql_fetch_array($get_query)) {
 
$field = $row["field"];
$id = $row["id"];
 
echo "$field - <a href=\"edit.php?id=$id\">Edit</a>";
 
}
?>

Then edit.php:

<?php
include "config.php";
 
$id = $_GET["id"]; // Be sure to use a good clean function to do it with. If you have one uncomment the next line
# $id = Clean($_GET["id"]);
 
if($_GET["action"] == "edit") {
 
$field = $_POST["field"];
# $field = clean($_POST["field"]);
 
mysql_query("UPDATE table SET field='$field' WHERE id='$id'") or die(mysql_error());
 
echo "Record updated!";
 
exit;
}
 
$get = mysql_query("SELECT * FROM table WHERE id='$id' LIMIT 0,1");
$row = mysql_fetch_array($get);
 
?>
<form action="?action=edit&id=<?php echo $_GET["id"]; ?>" method="post">
<table>
 
<tr><td>Field:</td> <td><input type="text" name="field" value="<?php echo $row["field"]; ?>"></tr>
<tr><td> </td> <td><input type"submit" name="submit" value="Edit"></td>
 
</table>
</form>

[Florx]

Whats special about your PHPDesigner computer?

Good luck with the editing

[Dentafrice,]

Whats special about your PHPDesigner computer?

Good luck with the editing

It has phpDesigner 2008 Enterprise edition, and it cleans and formats my code..

[adamFTW]

Add a new field to your database, make it a primary key and auto-increment.

Then do

<?php
$get_id = mysql_fetch_array(mysql_query("select id from comments"));
$id = $get_id[id];
?>

And im presuming your using a while loop to display comments, so it should be in that..

How do I make it auto increment?

AND, what would the link code be?

[Dentafrice,]

Read my post.. :p

[adamFTW]

I have, read my new thread pls.