SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Sep 2006
    Posts
    219
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PDO ORDER BY weirdness

    Hi,

    Has anyone had issues with PDO and ORDER BY not working??

    This is strange, because it works perfectly on my home machine but not on my hosting server.

    My Query is:

    Code:
    SELECT * FROM articles ORDER BY :sortColumn ASC LIMIT 0,15
    I then use bindParam to bind the sortColumn which has absolutely no affect on my hosting account, but works fine on my home setup.

    The DB is an absolute replica (MySQL with InnoDB storage engine).

    Any ideas?

    Thanks, Dan

  2. #2
    SitePoint Evangelist ClickHeRe's Avatar
    Join Date
    Mar 2005
    Location
    Ottawa, Canada
    Posts
    580
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    maybe check the differences in PHP version between home and hosting?
    David


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
  •