Advance Question: Stored Procedures in MYSQL

programming
1

Hi all,

To make my network more efficiency, i want to create a stored procedures by using MYSQL Browser. I google many articles but still don’t know how to write the procedure that describe conditions and make it works on my php script.

The question still same as my previous post:
*when a user select ‘Audi’ from the list, it will record the submission date and return to the form. The drop down list will then populate available car brand that has not yet selected for following user. *

Here is my php script:


<?php 
if ( isset($_POST['Submit']) ){ 
$link = mysql_connect("localhost", "user", "pwd") or die("Connection cannot establish"); 
$query = "UPDATE auto_table SET WHERE id = '".((int)$_POST['Car'])."' LIMIT 1"; 
mysql_query($query,$link) or die("Query Failed"); 
echo '<script>alert("Update Successfully !");opener.location.reload();</script>'; 
} 
$link = mysql_connect("localhost", "user", "pwd") or die("Connection cannot establish"); 
$query = "SELECT id,car_brand FROM auto_table WHERE date_check IS NULL ORDER BY id ASC"; 
$result = mysql_query($query,$link) or die("Query Failed"); 
$options = array(); 
while($row = mysql_fetch_array($result)){ 
$options[] = $row; 
} 
?> 
<body topmargin="20" leftmargin="20"> 
<table width="367" border="1" cellpadding="0" cellspacing="1" bordercolor="#333333" align="center"> 
<form method="post"> 
<tr> 
<td> 
<table width="100%" border="0" cellspacing="0" cellpadding="0"> 
<tr> 
<td> 
<table width="100%" border="0" cellspacing="0" cellpadding="1"> 
<tr> 
<td width="91"><strong>Car</strong></td> 
<td width="266">: 
<select name='Car'> 
<?php foreach($options as $data){ ?> 
<option value='<?php echo $data['id']; ?>'><?php echo $data['car_brand']; ?></option> 
<?php } ?> 
</select> 
</td> 
</tr> 
</table> 
</td> 
</tr> 
<tr> 
<td colspan="2" align="center"> 
<input type="submit" name="Submit" value="Update"> 
</td> 
</tr> 
</table> 
</td> 
</tr> 
</form> 
</table> 
</body>

I believe this is some advance level question, does anyone here can help me out? Many thanks :slight_smile: