chunkbar

$ratequeri="SELECT type FROM roomreservation ORDER BY room_no DESC LIMIT 1 "; mysql_select_db($database_ast_conn, $ast_conn); $Result111 = mysql_query($ratequeri, $ast_conn) or die(mysql_error()); $omgg=mysql_fetch_array($Result111); $rrate; if($omgg=="Deluxe Floor Room"){$rrate=350;} elseif($omgg=="Executive Club Floor Room"){$rrate=350;} elseif($omgg=="Junior Suite"){$rrate=350;} elseif($omgg=="Executive Suite"){$rrate=350;} elseif($omgg=="Presidential Suite"){$rrate=350;} $insertqueri="INSERT INTO roomreservation (rate) VALUES ('$rrate') "; mysql_select_db($database_ast_conn, $ast_conn); $Result1111 = mysql_query($insertqueri, $ast_conn) or die(mysql_error()); ///////////////////////// …

HI EVERY ONE how i can insert a confirm dialog box behind delete record button so that it will prompt like this ARE YOU SURE YOU WANT TO DELETE? YES OR NO ? if yes button is pressed then it will delete other wise dont .? thanks in advance

textbox1.Text = ""; textbox2.Text = ""; soon after your insertion querry

1.fill your dropdownlist with any unique/primary key through datareader 2.then use SELECT querry 3. open connection 4.execute querry 5. close connection

you can use return(); after inserting data for the first time in your condition ,it will avoid duplication of data, OR set primary key in your database it will also work,

both of these methods are not working in our project we hav tried both of them.we want to remove background repeatetion in extreme right of our project interface >:(

this is our insertion logic. but the problem is that after inserting one record we reset the textfields to clear them.and after that if we again press the insert button it duplicate the previous record into our database.we want to tackle with this??????so that no duplicate entry should be inserted …