php to mysql database

joma

i want to do a simple thing that my stoopid head can't understand

i want a simple script, i want it to connect to a database and add an sql query to a table. I will specify the information in sql format to what i want it to add, I want to use the script with cron aswell to execute on x-mas day. Can anyone help me, my database is mcm_Chat and this is what i want to add to it

INSERT INTO `main_chatfile` (`id`, `namecolor`, `textcolor`, `timestamp`, `isadmin`, `nickname`, `message`, `userip`, `mesdate`) VALUES
(43767, '855BD7', '', '[15:51]', 'false', '&lt;Administrator>', 'Merry X-Mas', 'IP', 'Thursday, Dec 25th 2008'),

can someone make my life easier. also if they know the cron command to execute the script aswell. thankyou !

TheStalker

//conect to database
$con = mysql_connect("host", "username", "password");
	mysql_select_db("mcm_Chat",$con);

mysql_query INSERT INTO `main_chatfile` (`id`, `namecolor`, `textcolor`, `timestamp`, `isadmin`, `nickname`, `message`, `userip`, `mesdate`) VALUES
(43767, '855BD7', '', '[15:51]', 'false', '&lt;Administrator>', 'Merry X-Mas', 'IP', 'Thursday, Dec 25th 2008')

mysql_close($con);

somthing along those lines. Thats should get you started any way 🙂