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
4 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.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.