Daniel0

The filename is idea.gif

Ah, yeah that makes sense (the error/issue that is).

Wouldn't it make sense to then make date_read a NULL field. Unless it has been read there is no valid value for the read_date.

Yeah well, there are no error log entries for your IP address, so unless you can give us some more information we'll have to regard it as a problem on your end.

Isn't a double just a float with double precision? How would that cause you an issue unless you have millions of entries and it you couldn't figure out why it used a lot more space than expected?

Much better.

Nobody said you were joking, but when the issue cannot be reproduced and you just say you "get an error" (that could mean a million different things) there is nothing we can do to fix/investigate it. What does "creating a topic the normal way" constitute? There is only one way to create a topic.

Make the status a tinyint instead and call it something like is_read. Integer comparisons are faster than string comparisons. Your relations table is redundant. Just put the FKs directly in the private_messages table.

Yeah maybe you should have

I think both a face palm and face wall (?) smiley would be good.

To be fair, it's reasonable to expect that doing something in a language you have a lot of experience with will be faster than doing the same thing in a language you don't have a lot of experience in. Whether or not something is in a DLL should be irrelevant. That would be the case in many of the PHP extensions you use as well. I have 0 experience with .NET and ASP though, so I cannot really comment on the quality and efficiency of it.

You "get an error". Okay, now I know exactly what's wrong... Anyway, how did you create this topic if you get an error on topic creation?

It's not a cursor like a mouse cursor. I don't think it's possible.

As it's also explained in this sticky (for the record: sticky post = read it!) Essentially we want you to verify that you are the owner of the website or are otherwise authorized to act on behalf of that owner. An easy way to do this is that you place a file whose content we dictate.

I love the face palm

But how would you then retrieve all dogs that are older than 2 years? That's why atomicity is a requirement for normalized database schemas. In the dog table, one row should already represent one dog, so having a dog inside the dog doesn't make sense. If you want to represent the dog as an object in PHP you could write a simple ORM (object-relational mapper) or use an existing one such as Doctrine.

What are you actually trying to do? As far as I know, the proper way to store values that contain the delimiter in a CSV file is to put the value in quotes. Something like: "Foo, bar, baz",test,hello

Maybe I should start reading the entire post before replying to it...

No, for a table to be even 1NF (1st normal form) in database normalization it's a requirement that each field is atomic, that's to say it contains only one thing and it cannot be broken down any further.

You should store the IP address as an unsigned integer, not as a string. You can use MySQL's INET_NTOA() and INET_ATON() functions or PHP's ip2long and long2ip functions. I would recommend MySQL's functions.

Oh well, I just thought he meant generating the text dynamically seeing as he referred to his signature. Also, we needn't necessarily use two separate images, but using a sprite and CSS we can probably use only one.

Instead of dynamically generating the image, wouldn't it be easier making it out of multiple images and then have the sign text being a <div>?

The idea is that if you want to request something like a security audit of a website, you must somehow prove ownership. The easiest way to do that is by placing a file whose contents we've chosen on your website. This is to prevent that someone requests something like "hack my site" and then posting another person's website. That has actually happened before. You don't want beta testing of a website, but a downloadable script, so it doesn't apply here.

Code is first and foremost for humans to read...

Or if you're a kind of DIY person: $string = 'aaa bbb ccc'; $words = array(); for ($i = 0, $j = 0, $length = strlen($string); $i < $length; ++$i) { if ($string[$i] == ' ') { $j++; continue; } if (!isset($words[$j])) { $words[$j] = $string[$i]; } else { $words[$j] .= $string[$i]; } } var_dump($words); Just for fun and because I had a little extra time this morning - use explode() instead