Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Unanswered: SQL Query help (urgent pls)

    Hi,

    I need some urgent help on how to create an SQL query to update table, Please look at the link below, it explains a new way of storing heirarcy data in DB, parent - child relationship, I am trying to see how to fire a query through which I do a re-ordering of a node.

    I can do delete/edit/add, confused on shift. And i am not good in sql , I have attached my php program.

    http://www.sitepoint.com/print/hiera...-data-database
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i'm surprised you didn't post this on the sitepoint forums
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oops, sorry, i do see your post now

    perhaps you could try re-posting it in the php forum over there

    use the [code]...[/code] tags to show your code, don't attach a zip
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •