Insert

[NZ_Kiwi]

Hi,

I'm trying to get this so add to my database but i get this error
INSERT error: Unknown column 'username' in 'field list'

anyone know why? below are my two pages

enter.php

<table border="0" width="100%">
												<tr>
													<td>
													<font face="Verdana" size="2">
													Username:<input name="username" size="15" style="font-family: Verdana; border-style: solid; border-width: 1px"></font></td>
													<td>
													<font face="Verdana" size="2">
													Password:<input name="password" size="15" style="font-family: Verdana; border-style: solid; border-width: 1px"></font></td>
												</tr>
											</table>
											<p>Subject:<br>
											<input name="subject" size="34" style="font-family: Verdana; border-style: solid; border-width: 1px"></p>
											<p></p>
											<p>
											<textarea rows="14" name="comment" cols="51"></textarea></p>
											<p>
											<input type="submit" value="Send" name="B1" style="border-style: solid; border-width: 1px">&nbsp;&nbsp;
											<input type="reset" value="Reset" name="B2" style="border-style: solid; border-width: 1px"></p>
										</form>
										<p>&nbsp;</p>
										<p><br>
&nbsp; </p>
										</font></td>
									</tr>
								</table>

sent.php

	<?php

mysql_connect (localhost, user, pass);

mysql_select_db (table);

?> <?php 


$comment = str_replace ("\r", "<br>", $cooment); 

$posted = date("Y-m-d"); 

$result = mysql_query ("INSERT INTO feedback (`id`,`username`,`posted`,`comment`) Values('','$username','$posted','$comment')") or die("INSERT error: ".mysql_error()); 







?>

[Shrike]

I see you have put 'mysql_select_db (table);'. I assume you have removed the actual name for the post, but are you selecting the database, or the specific table. The former is the correct one.

Other than that, as the error says, column username doesn't exist in table feedback.

[NZ_Kiwi]

Originally posted by Shrike
I see you have put 'mysql_select_db (table);'. I assume you have removed the actual name for the post, but are you selecting the database, or the specific table. The former is the correct one.

Other than that, as the error says, column username doesn't exist in table feedback.

Oh crap, I was looking at that but it all looked ok but I was looking at the wrong table... never mind all fixed