#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    3
    Rep Power
    0
    HIya there,

    was wondering if anybody could help me sort out my problem with multiple search criteria

    I want to build a vehicle search page that has the following search criteria:
    category of vehicle
    make
    location
    price
    year

    I want to use php & mySQL.

    Also want to populate a drop down list from records within the database. Does anybody know the code to do this

    I'd really appreciate any help

    Cheers!
  2. #2
  3. No Profile Picture
    beans-curry
    Guest
    Devshed Newbie (0 - 499 posts)
    hi DTM....

    here's the code u use to populae a drop down list...

    $q = "select * from vehicles;";
    $r = mysql_query($q);

    echo "<form><select name="vehicles">";

    for($i=0;$i<mysql_num_rows($r);++$i)
    { $arr = mysql_fetch_row($r);
    echo "<option value="".$arr[0]."">".$arr[0]."<option>";

    }

    echo "<select></form>";

    i hope that u get the general idea....use the same code to generate other lists too

    the logic's perfect...but just check for syntactical errors.....

    mail me to let me know more...



IMN logo majestic logo threadwatch logo seochat tools logo