php and javascript dropdowns

@simpson97Dec 08.2004 — #Heres a rudimentary example:

<html>

<body>

<?php

$rowcnt = $_POST['rows'];

$colcnt = $_POST['cols'];

if(isset($_POST['rows']))

{

print "<table border=1><tbody>";

for($r = 0; $r < $rowcnt; $r++)

{

print "<tr>";

for($c = 0; $c < $colcnt; $c++)

{

print "<td>$r - $c</td>";

}

print "</tr>";

}

print "</tbody></html>";

}

?>

<form action='atest.php' method='post'>

<select name='rows'>

<?php

for($i = 1; $i < 10; $i++)

print "<option value=$i>$i";

?>

</select>

<br />

<select name='cols'>

<?php

for($i = 1; $i < 10; $i++)

print "<option value=$i>$i";

?>

</select>

<br />

<input type=submit value='Make Table'>

</form>

</html>

</body>

Bob

@tasneemauthorDec 11.2004 — #hi

thanks

but my drop down are dynamic for mysql db.

i get the complete table done beautifully with this code:

[code=php]<?php include('myconnaspfree.php');
 
 //set defaults
 $country = 'All';
 $stateprov = 'allstateprov';
 
 //create short variable name
 if($HTTP_POST_VARS['country']) $country = $HTTP_POST_VARS['country'];
 if($HTTP_POST_VARS['stateprov']) $stateprov = $HTTP_POST_VARS['stateprov'];
 ?>
 [/code]

[CODE]<form name="retailerform" method="post">
 <table>
 <tr>
 <td><label for="country"><strong>Select a Country...</strong></label><br />
 <select name="country" class="selectbox">
 <?php 
 if($country !== 'All') {
 echo('<option value="'.$country.'">'.$country.'</option>'."n");
 }
 ?>
 <option value="All">All</option>
 <?php
 $strsql = "select distinct country from retailers order by country";
 $rsTmp = mysql_query($strsql) or die("Query failed");
 while($rowTmp = mysql_fetch_array($rsTmp)) { 
 echo "<option value='$rowTmp[0]'>$rowTmp[0]</option> ";
 }
 ?>
 </select>
 <?php 
 ?>
 </td>
 <td><label for="stateprov"><strong>Select a State/Province...</strong></label><br />
 <select name="stateprov" class="selectbox">
 <option value="allstateprov">All</option>
 <?php 

 $strssql = "select distinct state from retailers where state <> ' ' order by country,state";
 $rssTmp = mysql_query($strssql) or die("Query failed");
 while($rowsTmp = mysql_fetch_array($rssTmp)) { 
 echo "<option value='$rowsTmp[0]'>$rowsTmp[0]</option> ";
 }
 ?>
 </select></td>
 <td valign="middle">
 <input name="go" type="submit" class="button" value="Search">
 </td></tr></table>
 
 </form> [/CODE]

and then i have the code table populating.

You can have a look at this page [URL=http://des-us.glwb.info/staciretailersnew.php]testpage[/URL]

I just need the code to change the state drop down list after choosing a country.

thanks

php and javascript dropdowns

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

php and javascript dropdowns

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴