inserting records into mysql database?

Anon

I really need help. I have www.chart-lyrics.com as a website and anyone can review an album. But what happens at the moment is that the form gets emailed to me then i insert it into the mysql database manually. I no longer have the time to insert these reviews manually so I need your help.

I sortof know how to add the name, email and review into the databse but I am having problems with the date and datetime records.

I need the datetime records coz if i get 2 reviews on the same album in the same day then it sorts it by time aswell.

Hope you guys can help

Anon

$db = mysql_connect("localhost", "userName", "password") or die ("Could not connect");
mysql_select_db("dataBaseName") or die ("Could not select db");
$sql = "INSERT INTO tableNameHere(field_id, field1, field2, field3) VALUES (NULL, '$field1variable, '$field2variable, '$field3variable)";
mysql_query($sql);
mysql_close($db);

and i guess you have the reading part done because you say you are inputting int database

Anon

OK, thats great. But i still need to know how to input todays date into the table. I dont need the datetime function anymore just date.

Thanks

kparker

Let MySql do it for you, by adding a column of type TIMESTAMP. If you will be adding reviews only, that's all you have to do. If you allows users to update/edit their review, you'll have to decide if they get a new timestamp each time they're updated. If they do, again there's nothing to do, but if you want to retain the timestamp column as the original date of creation you'll need to rewrite the existing value back to the column.

That is, in your INSERT query you won't mention the timestamp column (thus MySql will give it the default value consisting of the current time.) But when doing and UPDATE, you will need to have retrieved the value of timestamp column, and then say

UPDATE .... set .... created='$created' ...

Otherwise if it's omitted from the column list the value will be updated to the current time when the row is updated.

Anon

That's great ...but its now duplicating entries. The timestamp is putting different times in each duplicate. How annoying. Does anyone know how to insert just one record at a time?