xjshiya

I have an array of checkbox that is populated with data from mysql database through a query. I can submit the value of the checked checkbox into a table from a database. But I want it to be saved according to the sequence the checkbox was checked by the user. …

Hello. I have two tables, the itinerary table and location table. The itinerary table consists of all the itinerary: * A - B * B - A * B - C * C - B * C - A * A - C The user will select from the itinerary …

I have the following codes.. echo "<form><center><input type=submit name=subs value='Submit'></center></form>"; $val=$_POST['resulta']; //this is from a textarea name='resulta' if (isset($_POST['subs'])) //from submit name='subs' { $aa=mysql_query("select max(reservno) as 'maxr' from reservation") or die(mysql_error()); //select maximum reservno $bb=mysql_fetch_array($aa); $cc=$bb['maxr']; $lines = explode("\n", $val); foreach ($lines as $line) { mysql_query("insert into location_list (reservno, location) …

I have an array of checkbox that is populated with data from mysql database through a query. I can submit the value of the checked checkbox into a table from a database. But I want it to be saved according to the sequence the checkbox was checked by the user. …

I have a a table with the following data: reservno || icode || location 00004 || 00021 || Bohol - Cebu 00004 || 00022 || Cebu - Manila 00004 || 00014 || Manila - Bohol I use this query to retrieve the concatenated value of location. `SELECT GROUP_CONCAT(location) from location_list …

You didn't select the database you are going to use.. Do it like this.. <?php $link=mysql_connect("localhost","my_username", "my_password"); if(!$link) { die("Could not connect:" .mysql_error()); } mysql_select_db("name_of_your_database"); //here goes the database selection echo "Connected successfully!"; ?> Hope this helped.. :))))

Use the 'WHERE' clause. UPDATE leave_request SET leave_status = 'Approve' WHERE leave_req_id = '00001' // you can replace the 'leave_req_id = '00001' with whatever condition you wish, to change a specific row you want.

Try visiting http://w3schools.com/ and http://www.tizag.com/. They have good tutorials out there. Google is always an option.

Try visiting http://w3schools.com/ or http://www.tizag.com/. They have good tutorials for beginners. Well, google is always at your side, and forums like this for question. :))))

Hello! I have a code here that has a dropdown box which is populated with data from mysql table, itinerary to be spicific (e.g. Tokyo- London, London - Tokyo, etc.). I also have a textbox that displays the block time (no. of hours required to travel a specific itinerary) of …

Hi! I have a php code that generates an excel file that is populated with mysql data of course through a mysql_query.. Here it is.. <?php require("aacfs.php"); header("Content-type: application/ms-excel"); header("Content-Disposition: attachment; filename=Reservation Summary_sortbydate.xls"); header("Pragma: no-cache"); header("Expires: 0"); $head1="Ayala Aviation Corporation"; $head2="RESERVATION SUMMARY"; $head3="For the period ___________"; $heads="$head1\n$head2\n$head3\n"; $query = "select …