Search
Search

Delete an entire row from a table, using MySQL

debugcn Published at Dev
12
Shane

I am trying to code for a row to be deleted in MySQL.

I am not sure how to do this so have picked some coding up from another website:

Syntax:

<?php
$personID=$_GET["q"];
if ($personID<="0"){echo( "<center><h3><a href=\"#\" onclick=\"window.close(); return false\">NO ID ERROR CLICK THIS TO RETRY CLOSE WINDOW</a></h3></center>"); 
 }
 else
 {
 $con = mysql_connect("mysql.XXX.com","XXX","XXX");

if (!$con) 
  {
   die('Could not connect: ' . mysql_error());
   }
  $myid=$_COOKIE["user"];

@mysql_select_db("u716720408_admin", $con)or die( "Unable to select database");
$result=mysql_query("DELETE * FROM users WHERE personID=$personID")or die(mysql_error());  

$cnt=1;

$row = mysql_fetch_array( $result );

$f1=$row['personID'];
$f2=$row['personFname'];
$f9=$row['llmail'];
$f14=$row['personSname'];
$f19=$row['password']; 

?>
mirkobrankovic

Use:

 DELETE FROM users WHERE personID=$personID

Make sure you read up about SQL Injection

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

What is the shortcut to delete entire row from table in Word 2007?

From Dev

Delete selected row from table in mysql

From Dev

Delete selected row from table in mysql

From Dev

jQuery onclick delete row from mysql table

From Dev

Delete an entire string from mySql table containing random characters

From Dev

how to delete the specified row from html table and also in mysql table using php

From Dev

unable to delete row from table using jquery?

From Dev

unable to delete row from table using jquery?

From Dev

To delete a row dynamically from a table using javascript

From Dev

PHP form delete from MYSQL table dont delete the right row

From Dev

delete rows from a table using MySQL Scheduler

From Dev

Delete from MySql table using aggregate functions?

From Dev

How to select an entire DataGrid Table Row and delete it with a button click using WPF?

From Dev

Mysql DELETE from table using information from another table

From Dev

Beginner: Delete row from Table and Database PHP/HTML/MySQL

From Dev

Mysql table replace or delete row

From Dev

Mysql table replace or delete row

From Dev

Delete a row from a JavaFX table using context menu

From Dev

How to delete a row from table using SPSS Modeler

From Dev

using jQuery drag + drop to delete a row from an SQL table

From Dev

Unable to delete row from html table using jquery

From Dev

Delete a row from table view using custom button - Swift 3

From Dev

bug removing an entire row in a table using addEventListener

From Dev

Delete Table row using javascript

From Dev

Delete row of the table using javascript

From Dev

Delete a row from Parse Table

From Dev

Delete a row from sqlite table

From Dev

Delete row from dynamic table

From Dev

SELECT FOR UPDATE holding entire table in MySQL rather than row by row

Related Related

  1. 1

    What is the shortcut to delete entire row from table in Word 2007?

  2. 2

    Delete selected row from table in mysql

  3. 3

    Delete selected row from table in mysql

  4. 4

    jQuery onclick delete row from mysql table

  5. 5

    Delete an entire string from mySql table containing random characters

  6. 6

    how to delete the specified row from html table and also in mysql table using php

  7. 7

    unable to delete row from table using jquery?

  8. 8

    unable to delete row from table using jquery?

  9. 9

    To delete a row dynamically from a table using javascript

  10. 10

    PHP form delete from MYSQL table dont delete the right row

  11. 11

    delete rows from a table using MySQL Scheduler

  12. 12

    Delete from MySql table using aggregate functions?

  13. 13

    How to select an entire DataGrid Table Row and delete it with a button click using WPF?

  14. 14

    Mysql DELETE from table using information from another table

  15. 15

    Beginner: Delete row from Table and Database PHP/HTML/MySQL

  16. 16

    Mysql table replace or delete row

  17. 17

    Mysql table replace or delete row

  18. 18

    Delete a row from a JavaFX table using context menu

  19. 19

    How to delete a row from table using SPSS Modeler

  20. 20

    using jQuery drag + drop to delete a row from an SQL table

  21. 21

    Unable to delete row from html table using jquery

  22. 22

    Delete a row from table view using custom button - Swift 3

  23. 23

    bug removing an entire row in a table using addEventListener

  24. 24

    Delete Table row using javascript

  25. 25

    Delete row of the table using javascript

  26. 26

    Delete a row from Parse Table

  27. 27

    Delete a row from sqlite table

  28. 28

    Delete row from dynamic table

  29. 29

    SELECT FOR UPDATE holding entire table in MySQL rather than row by row

HotTag

Archive