How to select field values from table

Anon

In my script I print out table of users and behind of them are buttons which
are pointing to the current field, all script working and listing me all users
and buttons but I can't get button value.
button value is in the address bar like: http://192.168.0.98/gl/delete_user.php?19=Delete
How can I get this 19 into my script ??
maybe I have use <a href ....> ?? but how ??

        echo "<form >";
        print "<table BORDER=1>";
        echo "<td><h3> Nr.</h3> </td><td><h3> Nimi</h3> </td> <td><h3>Amet</h3> </td> <td><h3>Elukoht</h3> </td><td><h3>Isikukood </h3></td><td><h3>Staatus </h3></td>";

//tabeli ridade kokku lugemine
while ($r = mysql_fetch_array($all_users))
{ $i++;
$Ide = $r["id"];
$Name = $r["nimi"];

            echo "<tr>";
            echo "<td>$i</td><td>$Name</td><td><input type=\"submit\" name=\"$Ide\" size=\"20\" value=\"Delete\"></td>";
            echo "</tr>";
        }
        echo "</table></form>";

thanx...

Anon

I would say he best thing to do is either create a form for each user and add a hidden input with the id in it, or like you said use and href and you can simply echo out the <a href="www.url.com/delete_user.php3?id=$Ide>Delete</a>

Anon

Yeah but browser goes then another page whitc
does not exist and gives me http://192.168.0.98/gl/delete_user.php3?id=2

but how I can get this "id=2" to use it in my
query???

Anon

Hi Lauri,

all vars which are defined in an <a href>-tag by using <a href="http://www.xxx.zzz/delete.php3?user=2> are implemented in the called documents automatically. They are converted into strings when the vars contain letters or in integer-values when the vars consist of numbers.
You can simply call 'em by typing in:

echo "You want to delete user $user";

For the var "$user" in this example the value 2 is printed.

But be careful with this method and always choose var names which aren't defined in the called document again. "Id" for example is often used in documents again - therefore be more precise.

Anon

If you are using PHp4 that may not work in whcih case you can access it through $HTTP_GET_VARS["varaiblename"] or $HTTP_POST_VARS["varaiblename"] depending on the method