RE: [PHP-DB] Data errors in entering
I am only a beginner but I always use single quotes, I am using mySQL. Such as: $sql = "INSERT INTO $table_name (day, daydate, month, year, time, place, numbers, details, reportby) VALUES ('$day', '$daydate', 'month', 'year', '$time', '$place','$numbers','$details', '$reportby')"; All the Best Lisa -Original Message- From: Shane Barry [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 3:11 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Data errors in entering I seem to be having a problem with a php script I use to enter data into a sql database from a php frontend. The data are ints (months and years as a number). The Database is : +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | day | text| YES | | NULL| | | daydate | int(11) | YES | | NULL| | | month| int(11) | YES | | NULL| | | year | int(11) | YES | | NULL| | | time | text| YES | | NULL| | | place| text| YES | | NULL| | | numbers | text| YES | | NULL| | | details | text| YES | | NULL| | | reportby | text| YES | | NULL| | +--+-+--+-+-+---+ The html file takes the data in as (Using the post method): DATE: MONTH: YEAR: and the php script interacts with the data as: $sql = "INSERT INTO $table_name (day, daydate, month, year, time, place, numbers, details, reportby) VALUES (\"$day\", \"$daydate\", \"month\", \"year\", \"$time\", \"$place\",\"$numbers\",\"$details\", \"$reportby\") "; The Sections affected are month and year all the others including daydate which is exactly the same are working. Can someone please point out the error to me? Shane -- Webmaster Dublin & Wicklow Mountain Rescue Team www.dwmrt.ie Irish Mountain Rescue Association imra.ie.eu.org ICQ # 103528846 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Data errors in entering
The problem is in your insert statement. You forgot the $ on your month and year variable values. Your statement should read: $sql = "INSERT INTO $table_name (day,daydate,month,year,time,place,numbers, details,reportby) VALUES ('$day',$daydate,$month,$year,'$time','$place','$numbers','$details','$reportby')"; ^ ^ Another note, you do not need the quotes around your integer values for $daydate, $month, $year. You also should use single quotes on the other values rather than double quotes. Shane Barry <[EMAIL PROTECTED]> said: > I seem to be having a problem with a php script I use to enter data into a > sql database from a php frontend. The data are ints (months and years as > a number). > > The Database is : > > +--+-+--+-+-+---+ > | Field| Type| Null | Key | Default | Extra | > +--+-+--+-+-+---+ > | day | text| YES | | NULL| | > | daydate | int(11) | YES | | NULL| | > | month| int(11) | YES | | NULL| | > | year | int(11) | YES | | NULL| | > | time | text| YES | | NULL| | > | place| text| YES | | NULL| | > | numbers | text| YES | | NULL| | > | details | text| YES | | NULL| | > | reportby | text| YES | | NULL| | > +--+-+--+-+-+---+ > > The html file takes the data in as (Using the post method): > > DATE: > > > MONTH: > > > YEAR: > > > and the php script interacts with the data as: > > $sql = "INSERT INTO $table_name > (day, daydate, month, year, time, place, numbers, details, > reportby) > VALUES > ("$day", "$daydate", "month", "year", "$time", > "$place","$numbers","$details", "$reportby") > "; > > The Sections affected are month and year all the others including daydate > which is exactly the same are working. Can someone please point out the > error to me? > > Shane > > -- > Webmaster > Dublin & Wicklow Mountain Rescue Team > www.dwmrt.ie > > Irish Mountain Rescue Association > imra.ie.eu.org > > ICQ # 103528846 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Data errors in entering
You're going to hate this ... add the $ so that you have $month, $year. Miles PS I've done it too - you red it so many times you no longer see anything. At 03:10 PM 5/21/01 +0100, Shane Barry wrote: >I seem to be having a problem with a php script I use to enter data into a >sql database from a php frontend. The data are ints (months and years as >a number). > >The Database is : > >+--+-+--+-+-+---+ >| Field| Type| Null | Key | Default | Extra | >+--+-+--+-+-+---+ >| day | text| YES | | NULL| | >| daydate | int(11) | YES | | NULL| | >| month| int(11) | YES | | NULL| | >| year | int(11) | YES | | NULL| | >| time | text| YES | | NULL| | >| place| text| YES | | NULL| | >| numbers | text| YES | | NULL| | >| details | text| YES | | NULL| | >| reportby | text| YES | | NULL| | >+--+-+--+-+-+---+ > >The html file takes the data in as (Using the post method): > >DATE: > > >MONTH: > > >YEAR: > > >and the php script interacts with the data as: > >$sql = "INSERT INTO $table_name > (day, daydate, month, year, time, place, numbers, details, >reportby) > VALUES > (\"$day\", \"$daydate\", \"month\", \"year\", \"$time\", >\"$place\",\"$numbers\",\"$details\", \"$reportby\") > "; > >The Sections affected are month and year all the others including daydate >which is exactly the same are working. Can someone please point out the >error to me? > >Shane > >-- >Webmaster >Dublin & Wicklow Mountain Rescue Team >www.dwmrt.ie > >Irish Mountain Rescue Association >imra.ie.eu.org > >ICQ # 103528846 > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Data errors in entering
I seem to be having a problem with a php script I use to enter data into a sql database from a php frontend. The data are ints (months and years as a number). The Database is : +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | day | text| YES | | NULL| | | daydate | int(11) | YES | | NULL| | | month| int(11) | YES | | NULL| | | year | int(11) | YES | | NULL| | | time | text| YES | | NULL| | | place| text| YES | | NULL| | | numbers | text| YES | | NULL| | | details | text| YES | | NULL| | | reportby | text| YES | | NULL| | +--+-+--+-+-+---+ The html file takes the data in as (Using the post method): DATE: MONTH: YEAR: and the php script interacts with the data as: $sql = "INSERT INTO $table_name (day, daydate, month, year, time, place, numbers, details, reportby) VALUES (\"$day\", \"$daydate\", \"month\", \"year\", \"$time\", \"$place\",\"$numbers\",\"$details\", \"$reportby\") "; The Sections affected are month and year all the others including daydate which is exactly the same are working. Can someone please point out the error to me? Shane -- Webmaster Dublin & Wicklow Mountain Rescue Team www.dwmrt.ie Irish Mountain Rescue Association imra.ie.eu.org ICQ # 103528846 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]