Edit form

[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

[Calon]

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

[Decode]

Use this-

<?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-


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

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

[Johnnikins]

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