Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: excelsior9
  • Content: Threads
  • Order by date
  1. excelsior9

    Problem using date_format() and CONVERT_TZ() together

    Hi guys, I have this code on a page: $query = "SELECT id,title,author,summary,published,subsection,frontpage,topstory,image1,postdate,date_format(CONVERT_TZ(postdate,'MDT','GMT'),'%d/%m/%y (%T)') AS readable_date FROM content WHERE section='News' ORDER BY postdate DESC"; $result =...
  2. excelsior9

    Using ORDER BY with a UNION query

    Ok, So I've got this UNION query running: $query = "SELECT id,title,authorcomments,author,keywords,date_format(postdate, '%W %M %D, %Y') AS readable_date FROM artwork WHERE authorcomments LIKE '%$trimmed%' OR title LIKE '%$trimmed%' OR keywords LIKE '%$trimmed%' UNION SELECT...
  3. excelsior9

    Dealing with a mysql UNION query

    Ok, I'm not sure what's wrong here. Basically, I'm executing this UNION query: $query = "SELECT id,title,authorcomments,author,keywords,date_format(postdate, '%W %M %D, %Y') AS readable_date FROM artwork WHERE authorcomments LIKE '%$trimmed%' OR title LIKE '%$trimmed%' OR keywords LIKE...
  4. excelsior9

    REALLY weird CSS problem - need urgent help!!

    Ok, this is freaking me out. I have no idea what's going on. Head over to http://www.littleheadlines.com/etcetera2/index.php In Firefox, the styles have stopped loading after the navigation bar and some styles seem not to work in IE also. I have no idea what's caused this because everything...
  5. excelsior9

    Making a WYSIWYG Editor

    Ok, I'm about to go insane with this one. I'm developing a website where users can upload poetry and creative writing. I want to have a form where they can type in their poem and the line breaks and paragraph breaks are recognised by a wysiwyg editor. I've basically got this far on my own - but...

Part and Inventory Search

Back
Top