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">
Did you know?Explore Trending and Topic pages for more stories like this.
<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());
}
?>
No comments posted yet

Your Answer:

Login to answer
259 Like 31 Dislike
Previous forums Next forums
Other forums

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

file_put_contents and createimagefromjpeg
All,
I do somethings and then I have the following code:
file_put_contents('./test/'.$filename

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

Last Weeks sDate and eDate.
sDate - Start Date
eDate - End Date

I need to pull two dates for "Last Week" whi

Warning: session_start() [function.session-start]: Cann.....
hi, can someone help me with this? I keep getting this error....

Warning: session_start() [fu

Displaying different page content, depending on the logged in user.
Hi all, I am new to ASP.net (and web development in general), and have a question about how I can di

Displaying a record from mysql in a simple swf file
Hi,

I have a mysql database containing information I would like to display in my swf.

Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/

Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash