aeafisme23 Posted February 22, 2008 Share Posted February 22, 2008 My code below is pulling from a database and it's just listing the elements as a loop right now, below my code i will paste my sad attempt at putting it into a <select><option></select> but i dont know how to correctly put the data in there any suggestions? <?php //Setup connection to the database $connect = mysql_pconnect("localhost", "user", "pw") or die(mysql_error()); //Connect to the database mysql_select_db("x_x", $connect) or die(mysql_error()); // Perform an SQL query on the Address table $sql_address = mysql_query("SELECT dma_id, station_id from station_list order by dma_id") or die (mysql_error()); // Define the colours for the alternating rows $colour_odd = "#FFFFFF"; $colour_even = "#FFFFFF"; $row_count = 0; //To keep track of row number // Fetch the array of records and Loop through them while($results = mysql_fetch_array($sql_address)){ // Decide which colours to alternate for the rows If Remainder of $row_count divided by 2 == 0. $row_color = (($row_count % 2) == 0) ? $colour_even : $colour_odd; //Echo the table row and table data that needs to be looped Check All With selected: over until the end of the recordset echo ' <tr bgcolor="' . $row_color . '"> <td width=250 valign=top><p class=\"small\">' .$results['dma_id'] . ' <a href=view_records.php?station=' .$results['station_id'] . '>' .$results['station_id'] . '</a><br></p></td> </tr>'; // Increment the row count $row_count++; } // Free the MySQL resource mysql_free_result($sql_address); ?> My attempt at making it a drop down box. I am pretty sure im off base on most of it but just looking for some insight <?php //Setup connection to the database $connect = mysql_pconnect("localhost", "x", "x") or die(mysql_error()); //Connect to the database mysql_select_db("x", $connect) or die(mysql_error()); // Perform an SQL query on the Address table $sql_address = mysql_query("SELECT dma_id, station_id from station_list order by dma_id") or die (mysql_error()); // Fetch the array of records and Loop through them while($results = mysql_fetch_array($sql_address)){ // Decide which colours to alternate for the rows If Remainder of $row_count divided by 2 == 0. //Echo the table row and table data that needs to be looped Check All With selected: over until the end of the recordset echo ' <tr bgcolor="' . $row_color . '"> <td width=250 valign=top> <p class=\"small\"> <form><select name="dmalist"> <option value=''>- Select -</option> <option value="view_records.php?station=' .$results['station_id'] . '> formSelected( $HTTP_POST_VARS[ "dma_id" ], [ "station_id" ] ); </option> </select></form> </p> </td> </tr>'; // Increment the row count $row_count++; } // Free the MySQL resource mysql_free_result($sql_address); ?> Quote Link to comment Share on other sites More sharing options...
mem0ri Posted February 22, 2008 Share Posted February 22, 2008 You're not off by much...you don't want to loop through and recreate a new <select> box with every result (at least I hope not)...so you really only want to loop through the <option> part of the code...example //YOUR EARLIER CODE HERE <tr bgcolor="' . $row_color . '"> <td width=250 valign=top> <p class=\"small\"> <form><select name="dmalist"> <option value=''>- Select -</option> <?php while($results = mysql_fetch_array($sql_address)){ ?> <option value="view_records.php?station=' .$results['station_id'] . '> formSelected( $HTTP_POST_VARS[ "dma_id" ], [ "station_id" ] ); </option> <?php } ?> </select></form> </p> </td> </tr>'; //REST OF YOUR CODE HERE ...hmmm...o.k...that was really dirty code alteration I posted...changed it...gah...teach me to post really fast in reply... Quote Link to comment Share on other sites More sharing options...
aeafisme23 Posted February 22, 2008 Author Share Posted February 22, 2008 hehe i forgive your quick post and appreciate your nice way of saying i was'nt off that much but i couldnt hit a baseball if my life depended on it!!! Jk, thanks so much can't wait to find out if this works(sure it does) Quote Link to comment Share on other sites More sharing options...
aeafisme23 Posted February 22, 2008 Author Share Posted February 22, 2008 Okay my attempt at this did not return an error but it did however return absolutely nothing but a select box that was listed as Select but no database results were listed, i guarantee my problem is this line of code <option value="view_records.php?station=' .$results['station_id'] . '> formSelected( $HTTP_POST_VARS[ "dma_id" ], [ "station_id" ] ); </option> but i could be wrong, take a look at my code that i did below. Thanks in advance! <?php //Setup connection to the database $connect = mysql_pconnect("localhost", "x", "x") or die(mysql_error()); //Connect to the database mysql_select_db("x", $connect) or die(mysql_error()); // Perform an SQL query on the Address table $sql_address = mysql_query("SELECT dma_id, station_id from station_list order by dma_id") or die (mysql_error()); ?> <table> <tr bgcolor="' . $row_color . '"> <td width=250 valign=top> <p class="small\"> <form><select name="dmalist"> <option value=''>- Select -</option> <?php while($results = mysql_fetch_array($sql_address)){ ?> <option value="view_records.php?station=' .$results['station_id'] . '> formSelected( $HTTP_POST_VARS[ "dma_id" ], [ "station_id" ] ); </option> <?php // Increment the row count $row_count++; } // Free the MySQL resource mysql_free_result($sql_address); ?> </select></form> </p> </td> </tr></table> Quote Link to comment Share on other sites More sharing options...
aeafisme23 Posted February 22, 2008 Author Share Posted February 22, 2008 I also tried this approach with no avail, this approach did not return anything and returned php syntax errors. I think this approach may be better than the last but things are starting to mesh so much together that im actually confusing myself. Any clarity would be nice 3rd attempt: <table> <tr> <td width=250 valign=top> <p class="small"> <form><select name="dmalist"> <option value=''>- Select -</option> <?php while($results = mysql_fetch_array($sql_address)){ <option value=view_records.php?station=' .$results[`station_id`] . '>dma: ' .$results['dma_id'] . ' station: ' .$results['station_id'] . '</option> // Increment the row count $row_count++; } // Free the MySQL resource mysql_free_result($sql_address); ?> </select> </form></p> </td> </tr> </table> Quote Link to comment Share on other sites More sharing options...
peranha Posted February 22, 2008 Share Posted February 22, 2008 <?php // open connection $connection1 = mysql_connect($server, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); //this code is bringing in the values for dropdown number 1. $query="SELECT * FROM " . $pre . "country ORDER BY country"; /* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */ $result = mysql_query ($query); echo "<select name=\"bsc_country\" value='1'>Country Name</option>"; // printing the list box select command while($nt=mysql_fetch_array($result)){//Array or records stored in $nt echo "<option value=\"$nt[countryid]\">$nt[country]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box // close connection mysql_close($connection1); ?> The above is what I use for a drop down for countries. It pulls from a mysql database. If this is what you are looking for. Quote Link to comment Share on other sites More sharing options...
blackcell Posted February 22, 2008 Share Posted February 22, 2008 <form> <table> <tr> <td width=250 valign=top> <p class="small"> <select name="dmalist"> <option value=''>- Select -</option> <?php while($results = mysql_fetch_array($sql_address)){ $stationID = $results['station_id']; $dmaID = $results['dma_id']; echo"<option value='view_records.php?station=$stationID'>dma: $dmaID station: $stationID</option>"; // Increment the row count $row_count++; } // Free the MySQL resource mysql_free_result($sql_address); ?> </select> </p> </td> </tr> </table> </form> Try using this modified code. I think it will do what you need. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.