Two questions in one - INSERT and retriving dates

Eskimo887

I have a sign up form on my website, and for some reason (it seems to have only started now) when you submit, it adds two records to the database.

 $sql = "INSERT INTO roster SET first_name='$first', last_name='$last', email='$email', password='$password', hours='0.0', date = CURDATE()"; 
$result=mysql_query($sql) 
    OR die("Query error:<br />{$sql}<br />" .mysql_error()); 
	if (mysql_query($sql)) {

That's the INSERT query it uses, why is it adding two records?

Question 2.

As you can see, this query inserts the date the user signs up. I also have another form that users submit which also submits a date to another table.

How can I find how long ago the user either submitted the other form, or, if they haven't, the date they registered?

Thanks

Kudose

Although I can't recall if mysql_query is called if $result is never used, but:

$result=mysql_query($sql)
    OR die("Query error:<br />{$sql}<br />" .mysql_error());
    if (mysql_query($sql)) {

Is kind of redundant, and may be causing the two records all of a sudden.

Or ... if you are using $result later ... the mysql_query gets called for $result, and the if conditional.

Eskimo887

Ok, that works and it's now adding one record at a time.

What about question 2?

tekky

look at mysql.com under DATE_DIFF or DATE functions

reloj_alfred

can any one please send me php codes for a basic calculator....please!!!!

tekky

reloj_alfred wrote:
can any one please send me php codes for a basic calculator....please!!!!

Try posting in a relavent THREAD (one that you start most likely) and asking this... and in the mean time read the NETIQUETTE guide and relavent NEWBIE docs in the stickys and such around the forum