SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 30 of 30
  1. #26
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    i am having a great deal of difficulty matching "element [0][4][1] and [0][14][1] both have value 2" to my query

    perhaps you could restate the question using english, with proper field names

    also, are you referring to my UNION query in post #19?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  2. #27
    SitePoint Evangelist Scheisskopf's Avatar
    Join Date
    Nov 2004
    Location
    Southampton, UK
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    not to worry about my latest question - it's been sorted. i have another problem though - the following query will not run - what is the meatter with it?

    Code:
    ( SELECT message_board.`date` , admin.* 
    FROM message_board INNER JOIN admin ON 
    message_board.id = admin.id WHERE message_board.name = 'david' )
     UNION ( SELECT time_spent.`date` , admin.* FROM time_spent 
    INNER JOIN admin ON time_spent.id = admin.id WHERE time_spent.name
     = 'david' ) order by 1
    thanks.

  3. #28
    SitePoint Evangelist Scheisskopf's Avatar
    Join Date
    Nov 2004
    Location
    Southampton, UK
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the code above works fine locally, but i think the problem is because of ther server version on my website. it is 3.23.56. locally i am using 4. something.

    what part of the code does this server version not like then?

    thanks.

  4. #29
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It doesn't like the UNION since UNION is only available from MySQL 4.0.0 and newer.

  5. #30
    SitePoint Evangelist Scheisskopf's Avatar
    Join Date
    Nov 2004
    Location
    Southampton, UK
    Posts
    537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    crikey that was quick - thanks - any work around code?


Bookmarks

Posting Permissions

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