help plz!?

[immanuelx2]

<?php

mysql_connect("localhost", "user", "pass");
mysql_select_db("fd_news");

$title = $_POST['title'];
$news = $_POST['news'];
$timestamp = "wtf do i put here to get current time?";

if ( (isset($title)) && (isset($news)) ) {
 $sql = "INSERT INTO addressbook SET
 ID = '',
 Timestamp = '$timestamp',
 Title = '$title',
 News = '$news'
 ";

 mysql_query($sql);

 echo("<font color=#00FF00>News added successfully</font><p>Title: $title<br>News: $news<br>Timestamp: $timestamp");
}
else {
 echo("<font color=#FF0000>Error!</font> Not added successfully<p>Title: $title<br>News: $news<br>Timestamp: $timestamp");
 include('addnews.php');
}

?>

1) How come it wont add the row
2) What do i set my $timestamp to so it will be 0000-00-00 00:00:00 time format
3) Also any help that can fine tune this page (error checking etc...) is appreciated

ty everyone

[cgraz]

1) How come it wont add the row

cause your syntax is incorrect

2) What do i set my $timestamp to so it will be 0000-00-00 00:00:00 time format

use mysql's NOW()

Also, use mysql_error() to see what the problem is when you execute the query.

Here's what I'd make your query look like

$sql = "INSERT INTO addressbook (Timestamp, Title, News) VALUES(NOW(), '$title', '$news')";

$result = mysql_query($sql) or die(mysql_error());

Cgraz

[immanuelx2]

how do i use Mysql's NOW()

when i do $timestamp = NOW();

i get:

Fatal error: Call to undefined function: now() in /usr/local/psa/home/vhosts/finaldawn.orphus.com/httpdocs/admin/addednews.php on line 8

[cgraz]

sorry, you prob have to use mysql_query() when you use now() since it's a mysql function.Drop those two lines and use this:

$sql = mysql_query("INSERT INTO addressbook (Timestamp, Title, News) VALUES(NOW(), '$title', '$news')") or die(mysql_error()); 

Cgraz

[immanuelx2]

got it thank u 🙂