All pastes #241010 Raw Edit

Someone

public python v1 · immutable
·published 2006-11-06 00:01 UTC
rendered paste body
// db meros //CREATE TABLE `auto` (  `id` int(4) NOT NULL,  `company` varchar(12) NOT NULL,  `model` varchar(12) NOT NULL,  `color` varchar(12) NOT NULL,  `fuel` varchar(12) NOT NULL,  `year` int(4) NOT NULL,  `price` int(7) NOT NULL)// FORM meros //<form method="post" action="search.php">   <select name="search">   <option value="">""</option>   <option value="fiat">fiat</option>   <option value="hunday">hunday</option>    <option value="reno">reno</option>    <option value="toyota">toyota</option>    <option value="skoda">skoda</option>    <option value="audi">audi</option>    </select>         <input type="text" name="search2" size=25 maxlength=25>        <select name="search3">   <option value="">""</option>   <option value="diesel">diesel</option>   <option value="benzin">benzin</option>     </select>         <input type="Submit" name="Submit" value="Submit"> </form>// PHP meros //<?mysql_connect("localhost","nn","nnn");     mysql_select_db("amaxadiko");$search=$_POST['search'];$search2=$_POST['search2'];$search3=$_POST['search3'];$result = mysql_query("SELECT * FROM auto WHERE company = '$search' AND model = '$search2' AND fuel = '$search3'");$numRows = mysql_num_rows($result);if( $numRows == "0" ){echo "No Results Found";} else {while($r=mysql_fetch_array($result)){         $company=$r['company'];   $model=$r['model'];   $price=$r['price'];   $fuel=$r['fuel'];             echo " Znacka: $company<br>  Model: $model<br> Cena: $price<br> Fuel: $fuel<br> <p>";}} ?>