Page 1 of 1

PHP MYSQL Query to delete records from table using combo box

Posted: Wed Sep 24, 2008 12:59 pm
by pavanpuligandla
hii,,
I've 2 combo boxes in my front end html form, user has to select values from both the combo boxes to delete records frm mysql table, my delete query is not being executed,, please help me out..
herez my front end form,

Code: Select all

<TD CLASS="text">
<SPAN STYLE="font-weight: bold; color:#001F97;">
Batch ID:
</SPAN>
 
</TD>
<td>
<select name="Batch" style="width:180px; font-weight:bold; color:#001F97;"><option value="" selected="selected"><b>-Select Batch ID-</option></b>
<option value="T08" style="font-weight:bold">T08</option>
<option value="T09" style="font-weight:bold">T09</option>
<option value="T10" style="font-weight:bold">T10</option>
<option value="T11" style="font-weight:bold">T11</option>
<option value="T12" style="font-weight:bold">T12</option>
<option value="T13" style="font-weight:bold">T13</option>
<option value="T14" style="font-weight:bold">T14</option>
<option value="T15" style="font-weight:bold">T15</option>
</select>
</td>
</tr>
<tr>
<TD CLASS="text">
<SPAN STYLE="font-weight: bold; color:#001F97;">
Exam Type:
</SPAN>
 
</TD>
<td>
<select name="Type" style="width:180px; font-weight:bold; color:#001F97;"><option value="" selected="selected">-Select Type-</option>
<option value="In I" style="font-weight:bold">In I</option>
<option value="In II" style="font-weight:bold">In II</option>
<option value="In III" style="font-weight:bold">In III</option>
<option value="In IV" style="font-weight:bold">In IV</option>
<option value="Inl V" style="font-weight:bold">Inl V</option>
<option value="In VI" style="font-weight:bold">In VI</option>
<option value="Final " style="font-weight:bold">Final </option>
<option value="Ext" style="font-weight:bold">Ext</option>
</select>
</tr>
</td>
</table>
mysql php delete query :

Code: Select all

<?PHP
  include "authn.php";
//Connect to mysql server
    $link=mysql_connect("localhost","root","");
    if(!$link) {
        die('Failed to connect to server: ' . mysql_error());
    }
    //Select database
    $db=mysql_select_db("tge");
    if(!$db) {
        die("Unable to select database");
    }
$Batch = $_POST['Batch'];
$Type = $_POST['Type'];
 
    
    
    $query = mysql_query("DELETE FROM in WHERE Type = '$Type' AND Batch = '$Batch'") or die(mysql_error());
    
    echo "records deleted";
    
    
    ?>
i want to delete rows based on this type and batch only.. as there are several batches and types are there in th table..
many thanks.

Re: PHP MYSQL Query to delete records from table using combo box

Posted: Thu Sep 25, 2008 12:13 am
by ramya123
First check by printing the values of Batch and Type in your PHP file