|
||||||||
|
||||||||
|
||||||||
|
|
|
User Tools
2D Graphics
- Fireworks (286)
- Flash (4166)
- Gimp (255)
- Illustrator (1472)
- Paint Shop Pro (54)
- Photoshop (16699)
3D Graphics
- 3DS MAX (2408)
- AutoCAD (81)
- Blender 3d (285)
- Bryce 3d (28)
- Cinema 4D (142)
- Lightwave 3D (38)
- Maya (566)
Web Design & Development
- Adobe Flex (66)
- ASP (378)
- ASP.NET (485)
- ColdFusion (16)
- CSS (574)
- Dreamweaver (388)
- HTML (401)
- Java (732)
- Javascript (925)
- MM Fusion (1)
- MS FrontPage (20)
- Perl and CGI (123)
- PHP (1578)
- Python (69)
- Ruby on Rails (106)
- SEO (186)
- Web Design (315)
- XML (164)
Business Applications
- MS Excel (448)
- MS PowerPoint (169)
- MS Word (154)
- QuarkXPress (8)
Business Development
- Accounting (46)
- eCommerce (77)
- Legal (7)
- Marketing (246)
Databases
Desktop Programming
- C and Cpp (518)
- Delphi (21)
- Visual Basic (339)
- Visual C (30)
Video Editing
- Final Cut Studio (23)
- Premiere (64)
Miscellaneous
- P2P Filesharing (8)
- Web Hosting (159)
Newsletter
User Login
Stats
- Tutorials: 38,092
- Categories: 572
Dreamweaver Tutorials : Creating Dynamic Dropdowns with PHP
| Using Dreamweaver and PHP to dynamically populate the dropdown menus in your forms. 2 short video sessions will get you started quickly. | php.jpg) |
| |
| • Comment On Tutorial |
• View Tutorial
• Report Broken Link |
|
|
- By:
- jewellman
Oct 23rd, 2007 at 01:45 PMGood tuturial, I am new to the php/mysql game. I followed his instructions but am getting an error when I try and select from the Car Make Field-
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/j/e/w/jewellman/html/vehicles_search.php on line 10
Here is my code-
<?php
require_once("Connections/Test.php"); // database connection
$Make = $_POST['Make'];
if ($Make) {
///////////////////////////////////////////////
$query = sprintf("SELECT * FROM Model where Model_Id='$Make'");
$result = @mysql_query($query);
$rowModel = mysql_fetch_array($result);
//////////////////////////////////////////////
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="vehicles_search.php">
<select name="Make" onchange="document.forms[0].submit()">
<option value="" selected>Select Make</option>
<option value="1">Audi</option>
<option value="2">BMW</option>
<option value="3">Chevrolet</option>
<option value="4">Dodge</option>
<option value="5">Honda</option>
<option value="6">Mazda</option>
<option value="7">Nissan</option>
<option value="8">Pontiac</option>
</select>
<select name="Model">
<option value="">Select Model</option>
<?php do { ?>
<option value="<?php echo $rowModel['Model_Id']; ?>"><?php echo $rowModel['Model']; ?></option>
<?php }while ($rowModel = mysql_fetch_array($result)); ?>
</select>
</form>
</body>
</html>