Problems getting data from while function

[Anon]

Hi my problem still is that how can I specify data from while procedure
generated table.

user_show displays me users and data but how can i can't get data from this table
when i push button it gives me correct value into the address bar http://192.168.0.98/gl/delete_user.php?2=Delete
but I need it use into procedure delete_user to ask Are you sure or something like and then delete user using Id

$connect_db = mysql_connect("localhost", "webuser", "");
if(!isset($Kustuta)) {
user_show();
}
if(isset($Kustuta)) {
echo "$Ide nimi $Nimi";
}
function user_show() {
$all_users_query = "SELECT * FROM personal";
$all_users = mysql_db_query("galvi",$all_users_query);
if ($all_users) {

echo " user name is: $Nimi";
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>";
//chek data from table
while ($r = mysql_fetch_array($all_users))
{ $i++;
$Ide = $r["id"];
$Nimi = $r["nimi"];
$Amet = $r["amet"];
$elukoht = $r["elukoht"];
$isikukood = $r["isikukood"];
$aktiivne = $r["aktiivne"];
$Iden = $Ide;
echo "<tr>";
echo "<td>$i</td><td>$Nimi</td><td>$Amet</td><td>$elukoht</td><td>$isikukood</td><td>$aktiivne</td><td><input type=\"submit\" name=\"$Ide\" size=\"20\" value=\"Delete\"></td>";
//HERE IS THE PROBLEM
echo "</tr>";
}
echo "</table></form>";
echo " Person is: $Ide ja $kustuta";
}
else { echo "Error couldn't get any data"; }
}
function user_delete() {
$delete_user_query = "SELECT * FROM personal WHERE id='$Ide'";
$delete_user = mysql_db_query("galvi",$delete_user_query);
if($delete_user) {
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>";

    while ($d = mysql_fetch_array($delete_user))    {
    $Idd = $d["id"];
    $Nimid = $d["nimi"];
    $Ametd = $d["amet"];
    $elukohtd = $d["elukoht"];
    $isikukoodd = $d["isikukood"];
    $aktiivned = $d["aktiivne"];

     echo "<tr>";
            echo "<td>$Idd</td><td>$Nimid</td><td>$Ametd</td><td>$elukohtd</td><td>$isikukoodd</td><td>$aktiivned</td><td><input type=\"submit\" name=\"$Ide\" size=\"20\" value=\"Kustuta\"></td><td><input type=\"submit\" name=\"Mitte\" size=\"20\" value=\"Ei kustuta\"></td>";

            echo "</tr>";													!!!! I need here get from this button data like echo

    }
    echo "</table></form>";
}

}

[Anon]

though I tried, it is virtualy impossible to read your first 10 lines (I stopped afterwards). Try making some real sentences instead of that crap, maybe we can answer you then...

[Anon]

Yes and thanks anyway to trying helping me with the problem. I think my syntax was to messed up beacause when I programming I use lot of estonian language not english. sorry about that.🙂

[Anon]

major isssue are the sentences above your code :

"user_show displays me users and data but how can i can't get data from this table "

no matter how bad your english is (i am not a native english speaker myself), you can surely avoid the "how can I can't" ...

[Anon]

to answer your question (that's the purpose of this board):

you use the wrong url-format:

the first part after the ? is the name of the variable (in your example this is 2). whenever the id changes, your name changes too.

you need to form an url like

blablabla?id=$ide&submit=delete

you can do so by adding a hidden vield, named id with the value of $ide to your form.
call the submit-button whatever you like, this will become the value name, the value content will always be delete.

hope I helped you out...