need help in update query

Posted on 16th Feb 2014 07:03 pm by admin

i create a form for update. there are 8 columns in my mysql table. on my main page all the data is retrieve from db and displayed on the page. after every row there is a link edit. when user click that link it goes to a form where all the required fields are displayed. the user may only change one column or two. so my question is how we will know in website which column is to be updated. ofcourse we know the column with modified value will have to be change in db but how we can implement this in php.

my code is my form which is a long one
Code: [Select]<form name="form1" method="post" action="jobsReview.php">
<p align="left">Fill the Following Form</p>
<table width="702" height="486" border="0">
<tr>
<td width="315" height="24"><div align="left">Job Title:</div></td>
<td width="377"><select name="title" id="title">
<option value="Computer Lecturer">Computer Lecturer</option>
<option value="Management Lecturer">Management Lecturer</option>
<option value="English Lecturer">English Lecturer</option>
<option value="Islamyat Lecturer">Islamyat Lecturer</option>
<option value="Electronics Lecturer">Electronics Lecturer</option>
<option value="Economics Lecturer">Economics Lecturer</option>
<option value="Mathematics Lecturer">Mathematics Lecturer</option>
</select></td>
</tr>
<tr>
<td height="26"><div align="left">University:</div></td>
<td><label>
<input type="text" name="university" id="university">
</label></td>
</tr>
<tr>
<td height="24"><div align="left">Minimum Education Required:</div></td>
<td><label>
<input type="text" name="education" id="education">
</label></td>
</tr>
<tr>
<td height="24"><div align="left">Experience Required:</div></td>
<td><label>
<input type="text" name="req_experience" id="req_experience">


</label></td>
</tr>
<tr>
<td height="21">Post On:</td>
<td><select name="day" id="day">
<?php while( $row = mysql_fetch_array($resultday) ) { ?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['day']; ?></option>
<?php } ?>
</select>
-
<select name="month" id="month">
<?php while( $row = mysql_fetch_array($resultmonth) ) { ?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['month']; ?></option>
<?php } ?>
</select>
-
<select name="year" id="year">
<?php while( $row = mysql_fetch_array($resultyear) ) { ?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['year']; ?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td height="21">Apply By:</td>
<td><select name="days" id="days">
<?php while( $row = mysql_fetch_array($resultdays) ) { ?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['day']; ?></option>
<?php } ?>
</select>
-
<select name="months" id="months">
<?php while( $row = mysql_fetch_array($resultmonths) ) { ?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['month']; ?></option>
<?php } ?>
</select>
-
<select name="years" id="years">
<?php while( $row = mysql_fetch_array($resultyears) ) { ?>
<option value="<?php echo $row['id']; ?>"><?php echo $row['year']; ?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td height="325" valign="top"><div align="left">Job Description:</div></td>
<td valign="top"><label>
<textarea name="description" id="description" cols="60" rows="20"></textarea>
</label></td>
</tr>
<tr>
<td height="26">&nbsp;</td>
<td><input type="submit" name="submit" id="button" value="Edit Job"></td>
</tr>
</table>
<p>&nbsp;</p>
</form>
and here is my php
Code: [Select]<?php
if(isset($_POST['submit']))
{
$id = $_GET["id"];
$db = mysql_connect("localhost");
mysql_select_db("jobolicious", $db);
$quizquery = "UPDATE jobs_uni SET column='{$data}' WHERE id='{$id}'" or die(mysql_error());
//echo $query;
$result = mysql_query($query) or die(mysql_error());
}
?>

Your Answer:

Login to answer

Other forums

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht

foreach and array need help combining
Hi guys.

Here's the code

Code: array(
'tag' => 'code',<

Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di

Calculating a rating by adding number of points and dividing by number of items
I have a site that users can post links to files to download. They can rate these files on a 1-5 sca

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str

Trouble checking SESSION cookie
I am trying to use $_SESSION cookies to verify admin privileges .
I don't understand why this is

Credit card verification
I have a client who wants to process credit card transactions from his web site rather than the goin