Search results for query: *

Hi, thanks for the reply. That won't work because the TIMESTAMP field isn't the NULL item in question. The TIMESTAMP is never NULL. What might not exist within a date range is something with the STATUS_ID of 10 or 20. There are many statuses. So, for those dates without an item with the...

I have a query that simply counts how many items exist for a particular status within a given data range. The query works... SELECT DATE(MY_TIMESTAMP) AS DATE, SUM(CASE WHEN STATUS_ID=10 THEN 1 ELSE 0 END) AS STATUS10, SUM(CASE WHEN STATUS_ID=20 THEN 1 ELSE 0 END) AS STATUS20 FROM...

The question is not just about how to parse log files. There are tons of tools and scripts available to do that. That was more of an example to illustrate my question.

I have a very large ASCII text file. It's an Apache webserver log. It contains 4,783,012 lines and is 1.66GB. I need to look at each line of the file independently. This makes using "java.nio" a bit more difficult because I'll have to parse out a line from a buffer by looping through the buffer...

Thank you for posting thenewa2x.

You know those sites out there such as pricegrabber.com and bestbookbuys.com. You know, the ones that pull information such as prices and shipping and availability etc from other websites and then compare them against each other to find the best price etc. I’m wondering how this is done? Now, I...

Thank you. Just migrating to a new server and "magic_quotes_gpc" was ON so that did it. I was unaware of that setting. Ah, the joys of migrating.

Quick question, after I insert a block of text into my database after running it through "mysql_real_escape_string" it contains \' and \". Now, when I display the text back on a page somewhere it also contains those "\" slash characters. How should I deal with this? I do not want to do...

It's always underneath (that's not the problem). The problem is that I would like "text3" to stay immediately under "text1" all the time. If you shrink the browser window or something, or add more text to "text2" you'll notice that "text3" will start to move down as the browser moves the cells...

Here's a simple example to illustrate my question. Say you have this table... <table border=1> <tr> <td valign=top>text1</td> <td rowspan=2>text2 text2 text2 text2 text2 text2 text2 text2 text2 text2 text2 text2 text2 text2 text 2 text2 text2 text2 text2 text2 text2 text2</td> </tr> <tr> <td...

Thank you Vragabond, that fixed the problem.

I have a simple problem I hope someone has a CSS solution for. I have a table with a width of 100% - no problems there. Inside that table I have a row with a text box: <tr><td> <input type='text' class='textSubject' name='subject' value='My Text'> </td></tr> FYI, the CSS class "textSubject"...

Thank you r937! I knew deep down I needed to do a subquery, but since I'm a bit out of practice using SQL I just couldn't quite get my mind to work it out. That's it though. Thanks again!

I'm implementing a basic forum. My database contains a FORUM table, a TOPICS table, and a POSTS table. Basically, a "forum" contains "topics" and a topic contains "posts". Pretty standard. When I want to display a forum with all its topics I obviously want to order the topics by the one that...

Gotcha. Thanks!

Hey jpadie, so by saying it is "better", are you saying it is more secure, or are you saying it is better for another reason? I really am just trying to understand so that I can switch over to the "better" (i.e. more secure method) before I get too far entrenched into my current method. If it is...

Thanks for the response guys. feherke, that's what I am doing now. Works great. Just wanted to see if there was a better method to use. That is the best method I have seen so far. Hey jpadie, all my login code is in one file, and at the top of every other file I check for a valid login and then...

This isn't a new topic, and I've read what some people do, but if you don't mind, I would like to get some best practices around this from others. On all my secured pages near the top of the file I do something equivalent to this: <?php if(!login) { header("Location: /login/"); } ?> Let's...

Ok, thanks jpadie. I will just look at the known element directly. Thank you for installing IE7 and testing. I think this might be a bug in IE7. I mean, I can't imagine this is the desired behavior, but whatever, it is what it is. Thanks again.

I understand that it's not a php issue. I know this. However, PHP programmers deal with this kind of thing all the time so I thought it was relevant to post to this forum. Nevertheless, the bottom line is this: Mozilla and IE both submit forms when the enter key is pressed in an input...