Member Avatar

Sorry I'm new to these stuff but I am having a hard time about this. So I'll trying to create a php and mysql program which can view records from database server. In my form I have 2 dropdown list and 2 submit button, the first one the the list of "section" and submit button, and the second one is a list of "year level" and submit button again. If I select the section "A" and click submit button, it will display only the student's information that belongs only on section "A" and same as on "year level". I can't …

Member Avatar
0
14
Member Avatar

Hey fellows, I have three database tables AUCTIONS auction_id name description place date BIDDERS bidder_id firstname lastname email signupdate BIDS bid_id auction_id bidder_id biddate I want to create a drop down menu to select and display BIDDERS signed up for each AUCTIONS. I have coded the following in PHP to select the auction_id and title from AUCTIONS table into the drop down list. [CODE] <!-- Assuming connected to mysql database --> <form id="form1" name="form1" method="post" action=""> <?php $query="SELECT * FROM auctions"; $result =mysql_query($query,); $options=""; while ($row=mysql_fetch_array($result)) { $auction_id=$row["auction_id"]; $name=$row["name"]; $options.="<OPTION VALUE=\"$auction_id\">".$name.'</option>'; } ?> Auction: <select name="select" id="select"> <option value="Select All">Select …

Member Avatar
0
27
Member Avatar

Hi, I have three drop down boxes for a Date field; one each for days, month and year. I want it so that when a year and month are selected they can be checked and then i can use those variables to insert the options into the days drop down box. However obviously i do not want to submit the month and year first, so is there a way to check the current selected value of a drop down box? Thanks.

Member Avatar
0
24
Member Avatar

Well, I'm really new into JS and I'm actually more into C++, but I decided to give it a try since I'd love to develop some online games, using the new Canvas element HTML5 is providing. But before that i need to get the basics. What I'm trying to do here is a web application capable of solving some High School math problems related to Sine, Cosine, Tangent.... But I'm getting an "Undefined" Error, when trying to run a simple test. Here's the code, It's in spanish, but I think It's pretty much self-explaining, though I've modified the important parts …

Member Avatar
0
5
Member Avatar

Hello, I have looked over many examples of how to populate a dropdown with rows like [code=php] $sql="SELECT id, thing FROM table"; $result=sqlsrv_query($conn,$sql) or die("Couldn't execut query"); while ($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){ $id=$row["id"]; $thing=$row["thing"]; $options.="<option value=\"$id\">".$thing "</option>"; } [/code] But i need to populate this list with tables and will need to set values for an auto-submit feature. I know using [code=php] $sql = "SELECT NAME FROM <database>..sysobjects WHERE xtype = 'U'"; [/code] will give me a list of the tables but im not sure how to use with a while loop. Any help would be greatly appreciated.

Member Avatar
0
9
Member Avatar

Hello everyone, I have a problem with my drop down list box on my edit page in php. I would like my drop down list box to show what the user has selected, then if the user wishes to, change their selection updating the DB(mysql) at the same time. I have a couple of radio buttons that does the same thing and works fine.[CODE]eg <?php if ($dataArow['garageopt'] == "yes"){ echo ' checked="checked"';}?> />[/CODE] When i try to apply the same method changing the checked=checked to selected it doesen't work. [CODE]<select name="cartype" /> <option value="<?php if ($dataArow['cartype'] == "tvr"){ echo ' …

Member Avatar
0
11

The End.