Adopts News

[Saphira]

Hmm. I haven't tried this out since I changed the database field for detail to LONGTEXT. I'm trying to post news now, and I'm getting an error on add_news.php. I'm guessing that there's an error inserting it into the database.

PHP Code:

    $query = "INSERT INTO ".$prefix."news(topic, detail, name, nid, datetime) VALUES('".$topic."', '".$detail."', '".$name."', '".$Max_idd."', '".$datetime."')"; 


The line of code to insert it, and below, the database layout:

nid int(11)
topic varchar(255)
detail longtext
name varchar(65)
datetime varchar(25)

Does this all seem right to you?

[Bloodrun]

Originally Posted by Saphira

Hmm. I haven't tried this out since I changed the database field for detail to LONGTEXT. I'm trying to post news now, and I'm getting an error on add_news.php. I'm guessing that there's an error inserting it into the database.

PHP Code:

    $query = "INSERT INTO ".$prefix."news(topic, detail, name, nid, datetime) VALUES('".$topic."', '".$detail."', '".$name."', '".$Max_idd."', '".$datetime."')"; 


The line of code to insert it, and below, the database layout:

Does this all seem right to you?

Can you tell me the error please.

And find the '$result' nearest to the line where it says the error is, and place this right after it:

die('Invalid query: ' . mysql_error());