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 Chriss Miller 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: *

  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

    Thanks - Turned out the SELECT queries have to access the same number of columns (though this is a little odd, since the tables might be completely different, no?) Anyway, I can deal with that, but there is just one small problem that still occurs. If I include the ORDER BY postdate DESC clause...
  4. 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...
  5. excelsior9

    REALLY weird CSS problem - need urgent help!!

    Ahem... fixed it. Stupid me.
  6. 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...
  7. excelsior9

    Making a WYSIWYG Editor

    Thanks for that starsky but unfortunately it does nothing to alleviate the problem I'm having :(
  8. excelsior9

    Making a WYSIWYG Editor

    Ok, getting rid of the iframe, sounds great in principle - but have you looked at the page I'm working on? How else would I get that formatting to work without an iframe??? Like I said, it doesn't work with a normal textarea.
  9. excelsior9

    Making a WYSIWYG Editor

    But I have said that I already downloaded FCKEditor and had a look at the code, but couldn't work out the answer I wanted!!! Even if I installed FCKEditor I don't know how to make it pass the information (from its own iframe...) to a PHP handleform script. I couldn't work it out from the...
  10. excelsior9

    Making a WYSIWYG Editor

    Getting data from tinymce to a db is simple. Its as easy as subimitting a form and accessing it's value. In C# for example I a have control linked to my text box and just use the id of the control to reference the value" Ok, but however 'simple' it is, I don't know how to do it - that's why I'm...
  11. excelsior9

    Making a WYSIWYG Editor

    I'm using an iframe because I thought that's the only way you could affect the text with javascript - it wouldn't work with a normal textarea when I tried it. Basically, all I'm looking for is a way to take what's typed into the iframe to and send it to the database... is that possible? here is...
  12. excelsior9

    Making a WYSIWYG Editor

    *groan* I've had a look at both those editors - but they don't help me because A) I only want to provide users with a few options for formatting text (basically bold, italics and underline as well as the line breaks - that's it) and B) they don't explain how to solve my very specific problem of...
  13. 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