Another form

[Dada78]

Ok I am working on another form that has three different options to be entered into my DB. Everything is getting entered and it's working. Problem is they are being entered onto seprate lines instead of one line. The form I am working on can be seen here

http://www.texascaching.com/date_placed.html

I think, no, I know I did something wrong for it to be entered this way, just not sure what.

<?

include("dbinfo.inc.php");

$str_date_placed_month = $_POST['date_placed_month']; 
$str_date_placed_month = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_date_placed_month);

$str_date_placed_day = $_POST['date_placed_day']; 
$str_date_placed_day = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_date_placed_day);

$str_date_placed_year = $_POST['date_placed_year']; 
$str_date_placed_year = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_date_placed_year);

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = mysql_query("INSERT INTO date_placed (date_placed_month) VALUES ('$str_date_placed_month')")or die (mysql_error()); 

$query = mysql_query("INSERT INTO date_placed (date_placed_day) VALUES ('$str_date_placed_day')")or die (mysql_error()); 

$query = mysql_query("INSERT INTO date_placed (date_placed_year) VALUES ('$str_date_placed_year')")or die (mysql_error()); 
{
echo "Thanks for your help while we continue to develop. Click the Home button in the upper left corner to return back to the Home Page.";
} 


mysql_close();
?>

Now like I said everything is working just the options from the table are being entered on different lines which means it takes on 3 lines for one date instead of just using 1 line.

The table has 4 feilds, ID, date_placed_month, date_placed_day, date_placed_year. Like I said everything is being entered correctly except the fact it is not being entered on 1 line and I am sure it has to do with how I have the script wrote. Could it be that I am calling the $query = mysql_query( 3 seperate times for each feild? Thanks in advance for any help.

-Thanks

[shonuff]

Why not combine all your queries into one?

$query = "INSERT into date_placed " . 
   "set ID = NULL, " . 
   "date_placed_month = \"" . $str_date_placed_month . "\", " . 
   "date_placed_day = \"" . $str_date_placed_day . "\", " . 
   "date_placed_year = \"" . $str_date_placed_year . "\"";

above code untested of course, but you get the idea :-)

[Dada78]

Thank you for the reply. I figured it had something to do with that as it didn't look right. I just couldn't remember how to do it. After looking over some other files I have it jogged my memeory (as well as a good nights sleep) and came up with this.

$query = "INSERT INTO date_placed VALUES ('','$date_placed_month','$date_placed_day','$date_placed_year')"; 
mysql_query($query);

Now everything works like butter except when I try to add this onto the statement. or die (mysql_error()); like this

$query = "INSERT INTO date_placed VALUES ('','$date_placed_month','$date_placed_day','$date_placed_year')"; 
mysql_query($query)(mysql_error());

I get an error that states unexpected " I can get it to work without that but it would be nice to have that inlcuded so I know if their are any problems later.

-Thanks Again

[rincewind456]

Thats because you need to stick an "or" in there:

mysql_query($query) or die (mysql_error());  

[Dada78]

That did the trick, thank you so much for the suggestion

-Thanks