Jessica

http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html

This forum is for help with code you wrote, not having someone do it for you. Please post it in the freelance forum if you need someone to do it.

Are payments always due end of month? Or always 1 month after the last payment? Usually companies do a specific day.

You're welcome to seek out a forum where everyone is as smart as you are, since this clearly isn't it. I did give you the only answer I have for the problem. I'm not claiming I know how to do the thing you want to do, I claimed there's a better way to approach the whole situation. I don't normally bother to mention it because I'd hate to be accused of bragging, but the idea that I am a troll on this forum is kind of ridiculous given the moderators and other gurus thought that I deserved the guru title. I've been here for 8 years. Calling me a troll is just name calling as there's absolutely no way this community would tolerate a troll being promoted to a badge and sticking around for that long. Use a little logic if you're going to try to accuse me of something please. Personally I don't care when people don't like my responses. But David took the time to write a very detailed response and you blew him off. That's annoying. It's rude. If anyone is being a troll, it's you. You join our community, ask for advice, then act like a whiny baby, insulting established members of the community because you don't like the advice. I might deserve it but David sure doesn't. Hopefully one of the moderators can lock this thread soon, and you can find somewhere to learn the wrong way to do things and be happy about it.

Because people insist on using bad design, and they're being accommodating. You're free to continue down that path, just don't act so surprised and put off when people tell you it's wrong. There's no reason not to normalize the data other than laziness.

Lazy. http://us3.php.net/PDO http://us3.php.net/manual/en/pdostatement.rowcount.php If you're doing a select, yes do two queries. I don't even understand why there's a question of IF you can do two queries.

Yes, it's better than what you're doing. Databases are meant to handle lots of rows. Put indexes on the right columns and it's no issue. If there's no problem with the way you're doing it, then you should have no problem writing the query you need. But you're here, right?

I'm sure you can do it in one query, and Barand is most likely to have the best answer I'll be back in a bit.

You need to normalize your data, storing anything in a delimited list in a single row is bad.

You should be able to do this all in SQL, no need to loop and do all those queries. You said the two tables had the same structure? Is it possible for there to be a row in table 1 that has the same username as table 2, and different information (besides the id)?

Why are you trying to insert the userID anyway?

1. I don't believe Javascript can access the query string part of a URL. 2. What?

Use the built in num_rows functionality. Look in the manual.

NP. To prevent this problem most token/merge code systems use a marker to denote the start and end of a token/code. You can use things like __, :, @@, etc.

Make the username field unique and use ON DUPLICATE IGNORE

In the future you should show us the actual string as well. Switch the order of the elements in the array.

Make the field's default value the current timestamp.

See the link in my signature on debugging SQL. You need to check for errors.

The problem is? You've done what to debug it? There's nothing that stands out as a problem.

Good job.

That line of code is not causing that error. Try to do a little debugging on your own now. It tells you where the problem is and exactly what is wrong.

Did you read the entire reply I gave?

1. You have a property _numRows and a function numRows(). You don't have a property numRows. 2. If you're trying to call the function numRows() you're going to have a problem in that your function doesn't do anything. Try return;

So the syntax is: foreach($array AS $key=>$value){... Your matrix array has a KEY of 'Letters' and a value of $letters. When you use array syntax on a string like 'Letters' you get the character at that point in the string (starting at 0). Try putting a space between $array and [$key]. Right now you're doing $array[$key] meaning the character at the key in that variable. You want to just echo the string that is $array and the string that is [$key].

You can use a cron job.