Jeneca Posted January 31, 2012 Share Posted January 31, 2012 hi..Just want to ask how can I get only the selected item to display where there's a lot of option you will choose..?thanks and have a great day ahead! Link to comment Share on other sites More sharing options...
Don E Posted January 31, 2012 Share Posted January 31, 2012 Are you referring to something like this: <!DOCTYPE html><html><body><select> <option value="volvo">Volvo</option> <option value="saab" selected="selected">Saab</option> <option value="opel">Opel</option> <option value="audi">Audi</option></select></body></html> Saab will be selected when the page is loaded. Link to comment Share on other sites More sharing options...
regicidedelferoz Posted January 31, 2012 Share Posted January 31, 2012 tama po ba sya? Link to comment Share on other sites More sharing options...
Jeneca Posted January 31, 2012 Author Share Posted January 31, 2012 <?php // db connection $db = "mds_reports"; if($connect = mysql_connect("172.16.8.32", "mds_reports", "password")) $connect = mysql_select_db($db); else die("Unable to connect".mysql_error()); $date_from = $_POST['dfrom']; $date_to = $_POST['dto']; $res_name = $_POST['rname'];?><html> <head> </head> <title>Sales Frequency Bracket</title> <body> <h1>Sales Per Sales Frequency Bracket</h1> <form name="fetching" method="POST" action="Sales.php"></p> Date From: <br><input type="text" name="dfrom" id="dfrom"></p> Date To: <br><input type="text" name="dto" id="dto"><br /><br /><p> Restaurant Name: <select name="formName"> <option value="">SELECT...</option> <option value="all">ALL</option> <option value="morayta">MORAYTA</option> <option value="greenhills">GREENHILLS</option> <option value="un">UN AVENUE</option> <option value="quezon">QUEZON AVENUE</option> <option value="greenbelt">GREENBELT</option> <option value="roxas">ROXAS BLVD BACLARAN</option> <option value="alabang">ALABANG</option> <option value="mcs">MCS</option> <option value="lasalle">LA SALLE TAFT</option> <option value="commonwealth">COMMONWEALTH</option> <option value="laspinas">LAS PINAS</option> <option value="katipunan">KATIPUNAN</option> <option value="robinsons">ROBINSONS GALLERIA</option> <option value="rodriguez">E.RODRIGUEZ</option> <option value="tarlac">TARLAC ROMULO</option> <option value="marcos">MARCOS HI-WAY</option> <option value="retiro">RETIRO</option> <option value="megamall">SM MEGAMALL</option> <option value="cebu">CEBU JONES</option> <option value="davao">DAVAO BAJADA</option> <option value="edsa">EDSA SHANGRILA</option> <option value="ayala">LIPA AYALA</option> <option value="antipolo">ANTIPOLO</option> <option value="anonas">ANONAS</option> <option value="philcoa">PHILCOA</option> <option value="joson">CABANATUAN-JOSON</option> <option value="southmall">SM SOUTHMALL</option> <option value="waltermart">WALTERMART-DASMARINAS</option> <option value="cavite">CAVITE CITY 1-J FELIPE</option> <option value="ever">EVER GOTESCO CAINTA</option> <option value="sanpedro">SAN PEDRO</option> <option value="sumulong">SUMULONG</option> <option value="cathedral">LIPA CATHEDRAL</option> <option value="metrolane">METROLANE</option> <option value="valenzuela">VALENZUELA SOUTH</option> <option value="mindanao">MINDANAO</option> <option value="marikina">C AND B MARIKINA MALL</option> <option value="sanmateo">SAN MATEO</option> <option value="general">GENERAL LUNA-UPSI</option> <option value="rizal">J.P.RIZAL</option> <option value="dasmarinas">DASMARINAS BAYAN</option> <option value="visayas">VISAYAS AVE</option> <option value="malate">ROBINSON MALATE</option> <option value="sanjoaquin">SAN JOAQUIN</option> <option value="malabon">MALABON CONCEPCION</option> <option value="nemall">NE MALL CABANATUAN</option> <option value="stacruz">STA CRUZ CHURCH</option> <option value="muntinlupa">MUNTINLUPA</option> <option value="pateros">PATEROS BAYAN</option> <option value="kabihasnan">KABIHASNAN</option> <option value="west">WEST AVENUE</option> <option value="paco">PACO</option> <option value="banaue">BANAUE</option> <option value="rotonda">EDSA ROTONDA</option> <option value="tagaytay">TAGAYTAY 2-OLIVAREZ</option> <option value="barangka">BARANGKA</option> <option value="matalino">MATALINO</option> <option value="project">PROJECT 8</option> <option value="festival">FESTIVAL MALL GRD LEVEL</option> <option value="morato">TOMAS MORATO</option> <option value="ilustre">DAVAO3-ILUSTRE</option> <option value="makati">MAKATI AVENUE</option> <option value="munoz">MUNOZ</option> <option value="pedrogil">PEDRO GIL</option> <option value="tierra">TIERRA PURA</option> <option value="panay">EDSA PANAY</option> <option value="kingswood">KINGSWOOD</option> <option value="perpetual">TIMES PERPETUAL</option> <option value="lepanto">LEPANTO</option> <option value="campa">P.CAMPA</option> <option value="airport">AIRPORT ROAD</option> <option value="buendia">BUENDIA</option> <option value="regalado">REGALADO</option> <option value="staana">PRC STA.ANA</option> <option value="banawe">QA BANAWE</option> <option value="north">NORTH AVE</option> <option value="masinag">MASINAG</option> <option value="eastwood">EASTWOOD</option> <option value="rockwell">ROCKWELL</option> <option value="mcu">MCU</option> <option value="evangelista">EVANGELISTA</option> <option value="wilson">WILSON</option> <option value="novaliches">ROBINSONS NOVALICHES</option> <option value="quirino">QUIRINO TAFT</option> <option value="lapu-lapu">CEBU LAPU-LAPU</option> <option value="bicutan">SM BICUTAN</option> <option value="square">CEBU JY SQUARE</option> <option value="boni">EDSA BONI</option> <option value="emerald">EMERALD SHELL</option> <option value="people">PEOPLE SUPPORT</option> <option value="bankmer">BANKMER</option> <option value="sanlazaro">SM SAN LAZARO</option> <option value="binondo">BINONDO</option> <option value="pueblo">EL PUEBLO</option> <option value="sucat">SUCAT PALANYAG</option> <option value="northroad">CEBU NORTHROAD</option> <option value="northgate">NORTHGATE - F@ST BYTES</option> <option value="strata">STRATA 100</option> <option value="itcenter">EDSA IT CENTER</option> <option value="valero">VALERO VERA</option> <option value="bridgestone">32ND BRIDGESTONE</option> <option value="imus">IMUS</option> <option value="escario">CEBU ESCARIO</option> <option value="pioneer">ROBINSONS PIONEER</option> <option value="muntinlupa">SM MUNTINLUPA</option> <option value="mckinley">MCKINLEY</option> <option value="damosa">DAVAO DAMOSA</option> <option value="matina">DAVAO MATINA</option> <option value="amang">AMANG RODRIGUEZ</option> <option value="worlwide">WORLDWIDE ANNEX</option> <option value="farmers">FARMERS MARKET</option> <option value="agora">AGORA</option> <option value="tabunok">CEBU TABUNOK</option> <option value="tycoon">TYCOON</option> <option value="it">CEBU IT</option> <option value="frontera">FRONTERA VERDE</option> <option value="metropoli">C5 METROPOLI</option> <option value="zabarte">PUREGOLD ZABARTE</option> <option value="cyberzone">CYBERZONE2</option> <option value="newport">NEWPORT</option> <option value="casimiro">CASIMIRO</option> <option value="fairview">WEST FAIRVIEW</option> <option value="garcia">QA GARCIA</option> <option value="piazza">PIAZZA</option> <option value="novaliches">SM NOVALICHES</option> <option value="rockwell">MED CITY/ROCKWELL ORTIGAS</option> <option value="ortigas">ORTIGAS EXTENSION CAINTA</option> <option value="staana">STA. ANA</option> <option value="circumferential">ANTIPOLO CIRCUMFERENTIAL</option> <option value="molino">NEW MOLINO</option> </select></p> <input name="submit" type="submit" value="Go"> </form> <table> <table border="2" cellpadding="2" cellspacing="1" style='width:100%;'> <tr> <th>Restaurant Code</th> <th>Restaurant Name</th> <th>100 & Below</th> <th>101-200</th> <th>201-300</th> <th>301-400</th> <th>401-500</th> <th>501-600</th> <th>601-700</th> <th>701-800</th> <th>801-900</th> <th>901-1000</th> <th>1001 & Above</th> <th>Total Gross Sales</th> </tr> <?php if(isset($_POST['submit'])){ echo " Date select from $date_from to $date_to"."</p>"; $sql = "SELECT restaurant_master.code, restaurant_master.name FROM restaurant_master, SUM(CASE WHEN mds_orders.GrossTotal < '100' THEN mds_orders.GrossTotal END) AS 'less100', SUM(CASE WHEN mds_orders.GrossTotal >= '100' AND mds_orders.GrossTotal < '200' THEN mds_orders.GrossTotal END) AS 'less200', SUM(CASE WHEN mds_orders.GrossTotal >= '200' AND mds_orders.GrossTotal < '300' THEN mds_orders.GrossTotal END) AS 'less300', SUM(CASE WHEN mds_orders.GrossTotal >= '300' AND mds_orders.GrossTotal < '400' THEN mds_orders.GrossTotal END) AS 'less400', SUM(CASE WHEN mds_orders.GrossTotal >= '400' AND mds_orders.GrossTotal < '500' THEN mds_orders.GrossTotal END) AS 'less500', SUM(CASE WHEN mds_orders.GrossTotal >= '500' AND mds_orders.GrossTotal < '600' THEN mds_orders.GrossTotal END) AS 'less600', SUM(CASE WHEN mds_orders.GrossTotal >= '600' AND mds_orders.GrossTotal < '700' THEN mds_orders.GrossTotal END) AS 'less700', SUM(CASE WHEN mds_orders.GrossTotal >= '700' AND mds_orders.GrossTotal < '800' THEN mds_orders.GrossTotal END) AS 'less800', SUM(CASE WHEN mds_orders.GrossTotal >= '800' AND mds_orders.GrossTotal < '900' THEN mds_orders.GrossTotal END) AS 'less900', SUM(CASE WHEN mds_orders.GrossTotal >= '900' AND mds_orders.GrossTotal < '1000' THEN mds_orders.GrossTotal END) AS 'less1k', SUM(CASE WHEN mds_orders.GrossTotal >= '1000' THEN mds_orders.GrossTotal END) AS 'gtr1k', SUM(mds_orders.GrossTotal) AS 'total' FROM mds_orders JOIN restaurant_master ON mds_orders.RestaurantID = restaurant_master.PKID WHERE mds_orders.OrderDate BETWEEN '".$date_from." 00:00:00' AND '".$date_to." 23:59:59' AND restaurant_master = '$res_name' GROUP BY restaurant_master.code, restaurant_master.name"; $result = mysql_query($sql) or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); $i = 0; if (mysql_num_rows($result) >0) { while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){ $csv .= $row['code'].",". $row['name'].",". $row['less100'].",". $row['less200'].",". $row['less300'].",". $row['less400'].",". $row['less500'].",". $row['less600'].",". $row['less700'].",". $row['less800'].",". $row['less900'].",". $row['less1k'].",". $row['gtr1k'].",". $row['total'].","."<br>"; ?> <tr> <td><?php echo $row['code'];?></td> <td><?php echo $row['name'];?></td> <td><?php echo $row['less100'];?></td> <td><?php echo $row['less200'];?></td> <td><?php echo $row['less300'];?></td> <td><?php echo $row['less400'];?></td> <td><?php echo $row['less500'];?></td> <td><?php echo $row['less600'];?></td> <td><?php echo $row['less700'];?></td> <td><?php echo $row['less800'];?></td> <td><?php echo $row['less900'];?></td> <td><?php echo $row['less1k'];?></td> <td><?php echo $row['gtr1k'];?></td> <td><?php echo $row['total'];?></td> </tr> </tr> </tr> <?php }}} ?> </table<br /> <form name="export" method="POST" action="try.php"> <input type="hidden" name="try_dfrom" id="data" value="<?=$date_from?>"> <input type="hidden" name="try_dto" id="data" value="<?=$date_to?>"> <input type="submit" name="extract" value="Extract"> </form> </body></html> this is my sample program., and when I click any of the store it should be the one should display.,how can I do this..? Link to comment Share on other sites More sharing options...
Jeneca Posted January 31, 2012 Author Share Posted January 31, 2012 @Regicide Del Feroz malapit po yung sagot pero di po yun yung hinahanap kong output. Link to comment Share on other sites More sharing options...
birbal Posted January 31, 2012 Share Posted January 31, 2012 you want to do that dynamicaly? you need to use ajax http://w3schools.com/ajax Link to comment Share on other sites More sharing options...
regicidedelferoz Posted January 31, 2012 Share Posted January 31, 2012 kelan sya madidisplay?,. pagkapiling pagkapili o pag click ng submit? Link to comment Share on other sites More sharing options...
Jeneca Posted January 31, 2012 Author Share Posted January 31, 2012 pagka-click ng submit. paano pong gagawin ko..? Link to comment Share on other sites More sharing options...
regicidedelferoz Posted January 31, 2012 Share Posted January 31, 2012 nang hindi nagrerefresh? Link to comment Share on other sites More sharing options...
Jeneca Posted January 31, 2012 Author Share Posted January 31, 2012 yup, pagka-pili ng store saka iki-click yung button submit then automatically kung anu lang yung pinili mo yun lang yung lalabas na hindi na kailangan mg-refresh. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.