0

Buds!

How to code so php forces mysql to show only the final row of the column ?
The followings are how I coded (2 copied youtube tuts) to show all rows to allow user to delete multiple rows:

SAMPLE 1

[php]
<?php
session_start();
require "conn.php";
require "site_details.php"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Follow Users</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form name="form" action="" method="post"> <table border=1 cellpadding=1 cellspacing=1> <tr> <th>Id</th> <th>Username</th> <th>Password</th> <th>Email</th> <th>Delete</th> </tr> <?php
$res=mysqli_query($conn,"SELECT * FROM users");
while($row=mysqli_fetch_array($res))
{
    echo "<tr>";
    echo "<td>"; ?> <input type="checkbox" name="num[]" class="other" value="<?php echo $row["id"]; ?>" /> <?php echo "</td>";
    echo "<td>"; echo $row["ids"]; echo "</td>";
    echo "<td>"; echo $row["usernames"]; echo "</td>";
    echo "<td>"; echo $row["passwords"]; echo "</td>";
    echo "<td>"; echo $row["emails"]; echo "</td>";
    echo "</tr>";
}
?> </table> <input type="submit" name="submit" value="delete selected"> </form> <?php
if(isset($_POST["submit"]))
{
   $box=$_POST['num'];
   while (list ($key,$val) = @each ($box))
    {
      mysqli_query($conn,"DELETE FROM users WHERE id='$val'");
    }
?> <script type="text/javascript">
       window.location.href=window.location.href;
       </script> <?php
}
?> </body> </html>

[/php]

SAMPLE 2:

[php]
<?php
session_start();
require "conn.php";
require "site_details.php"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Follow Users</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form name="form" action="" method="post"> <table border=1 cellpadding=1 cellspacing=1> <tr> <th>Id</th> <th>Username</th> <th>Password</th> <th>Email</th> <th>Delete</th> </tr> <?php
$res=mysqli_query($conn,"SELECT * FROM users");
while($row=mysqli_fetch_array($res))
{
    echo "<tr>";
    echo "<td>"; ?> <input type="checkbox" name="num[]" class="other" value="<?php echo $row["id"]; ?>" /> <?php echo "</td>";
    echo "<td>"; echo $row["ids"]; echo "</td>";
    echo "<td>"; echo $row["usernames"]; echo "</td>";
    echo "<td>"; echo $row["passwords"]; echo "</td>";
    echo "<td>"; echo $row["emails"]; echo "</td>";
    echo "</tr>";
}
?> </table> <input type="submit" name="submit" value="delete selected"> </form> <?php
if(isset($_POST["submit"]))
{
   $box=$_POST['num'];
   while (list ($key,$val) = @each ($box))
    {
      mysqli_query($conn,"DELETE FROM users WHERE id='$val'");
    }
?> <script type="text/javascript">
       window.location.href=window.location.href;
       </script> <?php
}
?> </body> </html>

[/php]
3
Contributors
2
Replies
23
Views
6 Months
Discussion Span
Last Post by diafol
1

Don.t think mysql does last and top. Just do an order by desc and limit 1.

Votes + Comments
That's why I supplied the link so we can see syntax for various SQLs.
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.