qxygene Posted March 8, 2007 Share Posted March 8, 2007 hi; i made a case ; case 1: if ($form) { $query="INSERT INTO emlak (type,sqm,loc,price,info1,info2,bedr,bath,car,tarih,buy) VALUES ('$type','$sqm','$loc','$price','$info1','$info2','$bedr','$bath','$car',now(),'$buy')"; MYSQL_QUERY($query); $strSQL = "SELECT max(ref) FROM emlak"; $result = mysql_query($strSQL); $row = mysql_fetch_row($result); $ref = $row[0]; header("location:?step=2&ref=$ref"); } else { echo "STEP1<br>"; require ("inc/step1.inc.php"); } break; this case sends data to database , it works properly. also here is inc/step1.inc.php <form method="post" enctype="multipart/form-data"> <table> <tr> <td>Ref:</td> <td><? echo $ref ?></td> </tr> <tr> <td>Type:</td> <td> <select style="background-color:#ffffff; color:#333333; font-size: 12pt;" name=type> <option>Apartment</option> <option>Villa</option> <option>Commercal</option> <option>Land</option> </select> </td> </tr> <tr> <td>Sale or Rent?:</td> <td> <select cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;" name=buy> <option value=1>For Sale</option> <option value=0>For Rent</option> </select> </td> </tr> <tr> <td>S.Q.M.:</td> <td><input cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=sqm value=></td> </tr> <tr> <td>Location:</td> <td> <select name=loc cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;"> <option>Bozburun</option> <option>Marmaris</option> </select> </td> </tr> <tr> <td>Price £:</td> <td><textarea cols="48" rows="1" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=price value=></textarea></td></tr> </tr> <tr> <td>Info Head:</td> <td><textarea cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=info1 value=></textarea></td></tr> <tr> <td>Info Main:</td> <td><textarea cols="48" rows="10" style="background-color:#ffffff; color:#333333; font-size: 12pt;"></textarea></td> </tr> <tr> <td>Bedrooms:</td> <td><textarea cols="2" rows="1" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=bedr value=></textarea></td> </tr> <tr> <td>Bathrooms:</td> <td><textarea cols="2" rows="1" style="background-color:#ffffff; color:#333333; font-weight: bold; font-size: 12pt;" type=text name=bath value=></textarea></td> </tr> <tr> <td>Car Parking:</td> <td><textarea cols="2" rows="1" style="background-color:#ffffff; color:#333333; font-weight: bold; font-size: 12pt;" type=text name=car value=></textarea></td> </tr> <tr> <td colspan=2 align=right><input type=submit value="Go to Step2" name=form></td> </tr> now i want to make and edit/modify like this; i think i need a new case and step2.inc.php.. but i dont know how to do it.. any help.. Note:i also attached files. [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/41784-need-help-to-create-a-case/ Share on other sites More sharing options...
gabrielkolbe Posted March 8, 2007 Share Posted March 8, 2007 here'a an example ..hope it helps.. $query = "UPDATE customer SET username= '" . $_POST['username'] . "', fname= '" . $first . "', lname= '" . $last . "', email= '" . $_POST['email'] . "', tel= '" . $_POST['tel'] . "', fax= '" . $_POST['fax'] . "', cell= '" . $_POST['cell'] . "', hnum= '" . $_POST['hnum'] . "', street= '" . $_POST['street'] . "', city= '" . $city . "', province= '" . $_POST['province'] . "' , post_code= '" . $_POST['post_code'] . "' WHERE id = '".$_SESSION['userid']."'"; $result = mysql_query($query) or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/41784-need-help-to-create-a-case/#findComment-202658 Share on other sites More sharing options...
qxygene Posted March 8, 2007 Author Share Posted March 8, 2007 where to use this? Link to comment https://forums.phpfreaks.com/topic/41784-need-help-to-create-a-case/#findComment-202992 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.