some obvious errors:
$submiited on =date(1y-m-d'); // typo on submittedon and the date
format seems off, maybe you're looking for date('y-m-d') .
$query=insert into articles
(date,submitted,status,title,lead,body,submitted by)
// if the field name is submitted by then you need to write it
'submitted by'
values(!$submittedon',$status',$title',$lead',$body',$author,);
your use of punctuation is more than a bit off, and your field count doesn't
match your values count
values('$submittedon','$status', . );
$query=insert into articles (date, submitted, status, title, lead, body,
submittedby) values
('$submittedon','$submitted','$status','$title','$lead','$body','$submittedb
y'); // is the correct form but whether the field names and the value
variables are correctly named is up to you.
Hugh
- Original Message -
From: Karl James [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 10:37 PM
Subject: [PHP] help with insert into table to mysql
Hey guys
Im trying to have a form submit a body or article into a
Table called articles for people to post there stories or what not.
So far what I have written is not working and im not able to view
My errors for some reson,
Could some take a look at the three links below, thanks Karl
My code: http://nopaste.php-q.net/7668
My assignment: http://66.12.3.67/webdb/assign3.html
My link for the assignemt:
http://66.12.3.67/webdb/webdb13/insertarticle.php
ultimatefootballleague.com/index.php
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php