Member Avatar for reco21

can someone help me with this pls..

DELETE FROM site_post, site_comments WHERE site_post.id=$id AND site_comments.matchid=$id

needing to delete two rows one from each table.

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

IIRC, this only works if the column names are the same in both tables.

Another option would be to create a foreign key between the two columns with ON DELETE CASCADE.

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.