Pikachu2000

<option name='multiply'>*</option> // Change this <option value='multiply'>*</option> // To this

I haven't tested this, but change FROM_UNIXTIME to DATE_FORMAT and give it a try.

You're attempting to insert a duplicate value into a table field that is a unique indexed field. Just like the error says. A login script shouldn't need an INSERT query at all (in general).

Yes, it can be done. You're going to need to provide a lot more info for anyone to help you with the how part of it, though.

You have an extra concatenation operator ( . ) after $decrypted_username, before the closing parenthesis. scandir("/oauth/files/".$decrypted_username.);

There's an extra closing curly brace on line 18.

It's most likely something that doesn't work from one PHP version to another. You'll need to post the code, the PHP version you developed the site on, and the PHP version the web server is running before anyone here will really be able to help.

It must have been a PEBCAK error . . .

It looks fine to me. What is the problem?

Change the quotes around $timestamp from single to double quotes.

What do you mean by "correct it"? What problems are you having with it?

After the INSERT queryin the first script, you can call mysql_insert_id(), and store its value in a hidden field or $_SESSION var for use in the next script.

You'd need to change the comparison operator from greater than to less than for the previous record.

$query = "SELECT * FROM submissions WHERE id>'$curid' ORDER BY id DESC limit 1"; $next = mysql_query($query) or die( '<br />Query string ' . $query . '<br />Produced error: ' . mysql_error() . '<br />');

Timestamps, perhaps?

Unfortunately, it still shows up in some current books and tutorials, even though it shouldn't . . .

No, I mean remove $_SERVER['PHP_SELF'] from the <form tag and leave everything else.

Sort of unrelated, but change the form's action to action="" if you're submitting it to itself. Using $_SERVER['PHP_SELF'] is an XSS risk.

Is there a particular reason you need to do it this way? Most browsers limit the number of characters that can be used in a GET query string, so you'd be better off using the POST method.

Nobody will likely be able to help you without seeing the relevant code, and database structure (if applicable).

Start by copy/pasting the query into phpMyAdmin and seeing if it runs successfully that way.

$new_score = ($score + $old_score); AND $new_played = ($old_played + 1); // at least that's what it looks like you're trying to do . . .

Missed it last night, but string type data needs to be enclosed in quotes in the query string. Table and field names should be enclosed in backticks, and although it isn't necessarily required, it can save you headaches in the future. $query = "INSERT INTO `mailinglist` (`First`, `Last`, `Email`, `How_Found`) VALUES ('$firstname', '$lastname', '$email', '$howfound')";

It would have to be an HTML formatted email, not a plain text email, then you can simply use the regular <img> tags for the image.

What do you mean? These two things don't really go together . . . Unless you're actually talking about sending a multipart email.