MySQL table problem

[HalfLife]

If I want to make a guestbook, What type, attributes, etc. should be the field?
I have one that is set only on longtext and not null. It causes some errors when I try to change the field and it saves it as one line.

[tuf-web_co_uk]

it really depends on what feedback you want from your user

you could have something like this

id (bigint(20), auto_increment, primary)
posters_name (varchar(255))
posters_email (varchar(255))
entry (longtext())
date (timestamp(14))

[HalfLife]

I have these:

title blob
new longtext
more longtext
image blob
thumb blob
date blob

When I try to delete or change a field using this code:
$sql = "DELETE FROM news WHERE new='$dummy' ";

it gives me this error:
Error adding submitted file: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's conflicts. One of the main features in this anthology is "ISR

[tuf-web_co_uk]

try

$sql = "DELETE FROM news WHERE new = '".$dummy."'";