jcink

Sorry to be annoying, I HATE bumping support threads, but I tried googling around for help on what you mean but nothing...

Hi, What do you mean by ascending? Are you saying it's indexed for an ASC query, but not a DESC query?

Hi, SQL version: 4.1.21 This query: SELECT t.tid, t.title, t.starter_name, t.starter_id, p.post_date, p.post, p.pid FROM freeto_topics t LEFT JOIN freeto_posts p ON (p.new_topic = 1 AND p.topic_id = t.tid) WHERE t.forum_id IN (7,3,26) AND t.approved=1 ORDER BY t.tid DESC LIMIT 0, 15 is used on a forum. it seems to be doing a filesort. here is the EXPLAIN for this query: How can I get rid of this...? forum_id has an index on tid so I dont understand why it's doing a file sort. More info can be posted if needed, I'm confused with this index stuff and I've read the manuals, but I need some help. Thanks in advance.

hmm thanks, but Nope, not working. I tried those \ns in the sys_tem(); command too, not working.

Hi, I currently have an issue with the sys_tem(); command. My problem is that I need system to be able to "reply" to the response of this command: sys_tem("pure-pw useradd username -u ftpuser -g ftpgroup -d /var/www/s/host/username -N 200"); What this is, exactly, is a Pure-FTPd command line that adds a user in. The issue that when you do it, it then asks for password to be typed twice before adding. "Passwrd: " is outputted on the page. I don't know of a way to reply to that. I tried after that: sys_tem("testpassword"); sys_tem("testpassword"); The next two sys_tems seem to just open up brand new windows, doing nothing. Is there any way to continue the sys_tem(); if you get what I mean? Thanks in advance, jcink edit: I know it isn't called sys_tem but if you try to post with that word in your post you get blocked!!!! >=(

Hi I'm having some trouble with windows. Lets say i have on page 1: <a href='test.html' target='_blank'> And on the test.html page, i want to target the window that launched it. <a href='javascrip:document.blahblaha' target='_parent'> edit: i know its supposed to say J A V A S C R I P T but every time i type the full word i get 406 not acceptable error O_o but this does not seem to work. is there a way to do this? Thanks, Jcink