id like to input a parameter using an input box it suppose fill a column of an existing table
the submit button need to clear the old values in this column and than fill it with the new values
for example three column row; id, countries, parameter1
on submit clear column parameter and fill with parameter input as many countries as there are
Jump to PostSorry dear ,
i cant understand what you actually want to do. please write all.
Sorry dear ,
i cant understand what you actually want to do. please write all.
sorry for being unclear.
i imagine a input box, entering the value and pressing the submit button will send this value into a mysql table filling a defined column
mysql table
column1 column2
a cat
b cat
c cat
d cat
enter value "dog" submit on html page
table now looks lik this
column1 column2
a dog
b dog
c dog
d dog
hope this i more clear
if(isset($_POST['submit'])){
mysql_query("delete from table_name");
mysql_query("insert into table_name (column1,column2) values ('value1','value2')")or die(mysql_error());
}Hi
yes you can use update query to change the values in column2.
update query will change the data in column2.
Gajendra
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.