Site Messaging Help

[Nathan__02]

Ok I'm trying to set up site messaging on my site...ive only got the main part where you check your mail and the compose part done...but whenever i go to compose i always get the 'Mail was not sent' Message...here's my code

<?php
session_start();
include("config.php");
include("style.css");

if ($_GET['area']=='compose' && $_GET['action']=='sendmail') {


$receiver=$_POST['receiver'];
$subject=$_POST['subject'];
$message=$_POST['message'];
$uname=$_SESSION['username'];
$date=mktime();

$query=mysql_query("INSERT * INTO messaging VALUES ('','$receiver','$uname','$message','$date','$subject')");

if ($query) {
echo("Mail Sent");
} else {
echo("Mail was not sent");
}
} elseif ($_GET['area']=='compose') {


echo ("<form action=/messaging.php?area=compose&&action=sendmail method='post'><center><table border=1 cellpadding=0 cellspacing=0 height=200 width=500>
<tr height=25><td align=left>To: <input type=text name=receiver></td><td>&nbsp;Subject: <input type=text name=subject></td></tr>");
echo("<tr height=150><td align=center colspan=2><textarea cols=78 rows=20 name=message></textarea></td></tr>");
echo("<tr height=25><td align=left colspan=2><input type=submit value=Send name=submit></td></tr>");
echo("</table></form>");

} else {


//main table...holds messages received and not deleted


$query=mysql_query("SELECT * FROM messaging WHERE receiver= '$username' ORDER BY date DESC");

echo ("<center><table border=1 cellpadding=0 cellspacing=0 height=75 width=500>
<tr height=25><td align=center>From</td><td align=center>Subject</td><td align=center>Date</td></tr>");

while ($row=mysql_fetch_array($query))  

{
echo("<tr height=25><td align=center>".$row["from"]."</td><td align=center>".$row["subject"]."</td><td align=center>".$row["date"]."</td></tr>");
}

echo ("<tr height=25><td align='center'><a href='/messaging.php'>Inbox</a></td><td align='center'><a href='/messaging.php?area=compose'>Compose</a></td><td align='center'><a href='/messaging.php?area=trash'>Trash</a></td></tr>");

echo("</table></center>");

//end of main table

}

?>

[zhabala]

It's because your insert statement is badly written:

$query=mysql_query("INSERT * INTO messaging VALUES ('','$receiver','$uname','$message','$date','$subject')");

should be

$query=mysql_query("INSERT INTO messaging VALUES ('','$receiver','$uname','$message','$date','$subject')");

Zdenek