Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 2 of 2

Thread: MySQL query

  1. #1
    Senior Member
    Join Date
    Apr 2005
    Location
    Hatfield, England
    Posts
    855
    Member #
    9790
    I want to delete 2 rows from 2 tables from 2 tables using a single query.

    I want to delete from news the row where id='$id'
    I also want to delete from news_comments the row where news_id='$id'

    I made this query but its making an error. Where am i going wrong?

    PHP Code:
    DELETE FROM newsnews_comments WHERE news.id='$id' AND news_comments.news_id='$id' 

  2.  

  3. #2
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    Code:
    DELETE news.id, news_comments.news_id FROM news, news_comments WHERE news.id = $id AND news_comments.news_id = $id
    Two other points:
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:40 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com