In a form there are 3 text boxes – assetid, quantity, amount. When i enter 3 in the quantity and click a save button, assetid should auto increment from com1 to com2,com3,com4 consecutively in access database column and at the same time the amount should be divided equally among the 3 assetid and saved in the database.

this is the code i have been using but something goes wrong somewhere and it fails no errors but it simply reloads the page and discards the information i put in

Update multiple rows in mysql

$host="xxx.xxx.xxx.xxx";
$username="HSR_CR";
$password="xxxxxxxxx";
$db_name="HSR_CR";
$tbl_name="COPE";

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>

if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $tbl_name SET Completion='$Completion[$i]' WHERE ID='$ID[$i]'";
$result1=mysql_query($sql);
}
}

if($result1){
header("location:index.php");
}
mysql_close();
?>

I have a datalist bound to a database. I want to highlight the rows of the datalist if the date in the database column is less than today’s date in the output. How to go about it?

I usually use Joomla but I am creating a site in an ASP-only environment.
Can anybody recommend a CMS that supports templates and translation and also allows admins to add content through a friendly GUI.

I have Dropdownlist1 which is bound to a database. Now based on the selected item in this dropdownlist, a list of items from the database should be displayed in Dropdownlist2.

I need something that works as a webproxy page, something like
www.sedisem.info
and i need the software to be asp.net based… Any idea where to get it from ?

I am looking to host a website and use various PHP scripts. The hosting site that I am looking at offers “CGI based PHP”? What does that mean for me? Does that mean I cannot embed PHP into my web pages? Do I have to put all PHP scripts into the cgi-bin?

How to make a form using HTML/PHP with conditional responses that are based on selection? For instance: drop down menu selections that determine the message on the confirmation screen.

Is there a php based script that will automatically translate a website according to the visitors IP address using Google Translator or better yet any other translator?

I already have the website built and I have a php based template I’d like to use for the “store” part of this site. What do I do with this php template? Tell me what kind of editor, etc. that I need and then how I can take the template from the form it comes in to being present and operating as a part of my site. PLEASE!!

Thanks!