Search results for query: *

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 =...

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...

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...

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...

Ahem... fixed it. Stupid me.

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...

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

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.

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...

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...

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...

*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...

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...