Edit form

I have an ad management script already, i have a working form, but i am wanting to make this form

http://www.habboxforum.com/showthread.php?t=508217

into a edit form, so when i go to say

http://mysite.com/edit.php?RefNum=124515125

it would come up so that i can edit the information

Any help

Thanks, John

Quote:

---

Originally Posted by Johnnikins

I have an ad management script already, i have a working form, but i am wanting to make this form

http://www.habboxforum.com/showthread.php?t=508217

into a edit form, so when i go to say

http://mysite.com/edit.php?RefNum=124515125

it would come up so that i can edit the information

Any help

Thanks, John

---

You can easily do it with $_GET

Use this-

PHP Code:

---

<?php
$refnum = addslashes ( $_GET['RefNum'] );
$query = mysql_query (" SELECT * FROM $db_table WHERE RefNum = '$refnum' ");
if ( $mysql_affected_rows == "1" ) {
   $data = mysql_fetch_assoc ( $query );
   echo "Site: " .  $data['Site'] . "<br \>";
   echo "Contact: " .  $data['Contact'] . "<br \>";
}
else {
   echo $refnum . "doesn't exist";
}
?>

---

Where is says-

PHP Code:

---

echo "Site: " .  $data['Site'] . "<br \>"; 


---

-you can change it to any col name to show the data from it.

thanks for that, i've tried and tried to get this working but it will not work :(

it keeps saying refnum not found although it is there, and my db info is correct