Member Avatar for hwoarang69

so i have a table called image: ->image_id, user_id, img, name

and i want to del one row where image_id = 3;

$del = mysql_query("DELETE  image WHERE image_id = '$image_id_g'");

i want to del whole row not just image_id.

iam not sure if this will del whole row

Edited by hwoarang69
  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 46 Minutes Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for JorgeM

The SQL Delete syntax is not correct. it should be:

DELETE FROM image WHERE image_id = '$image_id_g'

This will delete all rows that match the image_id value. If this field has unique data, then only one row will be deleted.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.