I'm retarded (inserint in to MYSQL)

Anon

I've been trying to insert data in to the database and for some odd reason i'm not getting any parssing errors but its not inserting it in to the database. It just says thank you information entered. But when i go back to the database its not there. Can anyone of you see anything wrong with the code? Here it is:

<head>
<title> Update The News </title>
</head>
<body>
<?php
if ($submit) {
// process form
$db = mysql_connect("localhost", "<username>", "<password>");
mysql_select_db("<databasename>",$db);
$sql = "INSERT INTO news (name,topic,news,email, date) VALUES ( '$name', '$topic', 'news' , '$email', '$date=now()')"; $result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
else{
// display form
?>
<form method= "post" action= "<?php PHP_SELF?>">
Name: <input type="Text" name="name"> <br>
Topic: <input type="Text" name="topic"> <br>
News: <textarea rows="16" name="news" cols="57"></textarea><br>
E-mail: <input type ="text" name= "email"> <br>
<input type="hidden" name="date">
<P><input type="Submit" name="submit" value="Enter information"></p>
</form>
<?php
} // end if
?>
</body>

The '$date = now()' is supposed to insert the current date into the date field. Atleast its supposed to.

Thank you guys

Anon

ok i got it to work inserting in to the database. But that now() thing doesn't work for the date. Is there anyway i can convert a date given to me in mm-dd-yyyy in to yyyy-mm-dd???

Anon

$date=date("Y-m-d");

and just insert $date

Anon

I got it to work also but i did something like this...but if yours work i'm going to shoot myself in the head for doing it the long way hehe

<?php
$string = $date;
$stringArray = explode ("-", $string);
echo $string;
printf ( "<br>");
$d = $stringArray [1];
$m = $stringArray[0];
$y = $stringArray [2];
$convertedDate = "$y-$m-$d";
echo " $convertedDate";
?>

Anon

Jaret
I tried that but it doesn't work it gives me a blank date...I would love it if i could just find a way of entering the system date into the table..would save me hella of alot of trouble on error checking, if any of you know how...please fill me in.

vex__

Umm... Why not just use NOW(), or SYSDATE() or CURRENT_TIMESTAMP, these are all standard MySQL functions for getting the current date and time.... or just use CURDATE() if you don't want the time as well...

INSERT INTO table (date_field) VALUES (NOW())

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions

Anon

This is what i'm using to try to enter the curent date into the table. Is my Syntax wrong?
$sql = "INSERT INTO news (name,topic,news,email, date) VALUES ( '$name', '$topic', '$news' , '$email',
'curdate()')";
$result = mysql_query($sql);

It enters everything but the date

vex__

Yeah, you don't need the single quotes around the function call.. Try this..

$sql = "INSERT INTO news (name,topic,news,email, date) VALUES ( '$name', '$topic', '$news' , '$email',
curdate())";

With the quotes around it, MySQL treats it as a text string, and inserting that into a date field will just generate 0's..

Should work now....

Anon

Thank you guys!