NEWBIE...need help..Again

[cnagra]

i got it to work, but suddenly jus stopped.
only data to the first field out of two gets data added to it. there is something wrong with the html file or the php file.

database is called data2, the fields are name and topic

[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]html file code[!--colorc--][/span][!--/colorc--]

<form name="form" method="post"
action="add_workin.php">

Name: <input type="text" name="name"><br>
Test: <input type="text" name="topic"><br>

<input type="Submit">
</form>

[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]php code[!--colorc--][/span][!--/colorc--]

<?php

mysql_pconnect('localhost');
mysql_select_db('test2');

mysql_query("insert into test values ('$name','$topic')");

?>

thanks...please help

[corillo181]

$sql = mysql_query("INSERT INTO test(name,topic) VALUES('$name','$topic')");

[cnagra]

[!--quoteo(post=365621:date=Apr 17 2006, 01:34 PM:name=Richard181)--][div class=\'quotetop\']QUOTE(Richard181 @ Apr 17 2006, 01:34 PM) [snapback]365621[/snapback][/div][div class=\'quotemain\'][!--quotec--]
$sql = mysql_query("INSERT INTO test(name,topic) VALUES('$name','$topic')");
[/quote]

hi, that worked fine, but only with numbers, they are both set to VARCHAR, so i dont get why this is ?

[corillo181]

what you mean it only works with number? the database should receive anything you put in the text area

[cnagra]

[!--quoteo(post=365625:date=Apr 17 2006, 01:46 PM:name=Richard181)--][div class=\'quotetop\']QUOTE(Richard181 @ Apr 17 2006, 01:46 PM) [snapback]365625[/snapback][/div][div class=\'quotemain\'][!--quotec--]
what you mean it only works with number? the database should receive anything you put in the text area
[/quote]


yeah thats what i thougt, but if input numbers in the fields, it works...but dont except text?....so strange....do u know why?

[corillo181]

not really you would have to wait untill someon that knows better if they know was wrong, becuase i got a form like that and it gets the values the right way..

[cnagra]

thanks anyway..

please someone help...it still only adds numbers!!

[corillo181]

one more thing did you define thefields as veriables?

or what you showed is the whole code?