Maq

This is has been moved, next time find please find the correct section to post in.

'to' is a reserved MySQL keyword. http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html You either need to change it to something else or put backtics `to` around it wherever it's used.

This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=311539.0

This topic has been moved to PHP Regex. http://www.phpfreaks.com/forums/index.php?topic=311251.0

There really shouldn't be a reason to have that order anyway. In an if/elseif you can only execute one of the blocks, so either put the while before or after that block. You should be able to keep the elseif if you moved the while before the blocks. Remember, 2 ifs aren't the same as if/elseif.

Can you post the current code inside tags?

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=310935.0

#1 - This belongs in the MySQL section. #2 - Please don't be lazy and do a bit of research.

Looks like before. Properly formatting your code makes these type of errors easy to detect and keep your code way more readable.

You're missing closing braces.

There are a couple of FF plugins that may be useful, "SQL Inject Me" and "XSS ME".

Seems to be more of a PHP question since this can't be accomplished with HTML alone. Moving.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=309847.0

Someone already told you the answer in your other post: http://www.phpfreaks.com/forums/index.php/topic,309924.msg1463968.html#msg1463968

shaneg55, please don't create duplicate posts in different boards. fenway offered to move your thread and you went ahead and created one anyway.

What's the error?

Broken link...

Have you done any research? If so, are you stuck on a specific part? These are very primitive concepts of most languages. There are probably millions of tutorials and examples (in plain English) on the web.

The next auto-incremented number would be 6.

First you made it seem like you wanted to get information from the 'todo' and 'users' table, now there's a 'todo_list' table. Can you show us the table definitions of the tables you want to use?

From your first query, if you're specifying a $user id then it will only return results for that user. If I'm interpreting your question correctly then you need to join the tables, most likely on user_id from the todo table and id (or whatever it is) from the users table and add the condition for an active status. Your query should look similar to: SELECT DISTINCT u.user FROM users u LEFT JOIN todo t ON u.id=t.user_id WHERE t.status='a'; Only select what you need, not *. Change u.user to u.[field_name].

Fenway's response was intended to convey the expression, "Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime." By just dishing out answers you are neglecting the user thinking for themselves, and consequently by nature, making that same user always coming back for a quick CnP answer. These are free forums, no one is getting paid here, if someone has 'attitude' ignore them and let the other staff members deliberate and determine if they are out of line.

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=308889.0

And that would be?

There may be a better way but you can use a combination these two lines in a recursive manner to achieve what you want. t=setTimeout("yourFunction()", 20000); and clearTimeout(t);