Hi, I am editing a php script for a website. Now, I managed to edit the script to sove this problem the other day, but accidently got rid of the changes... and have no clue how I managed to edit the script the other day... I am trying to add a field for "tax" and one for "ved rating". I can display the values currently in the database, but cannot update them. All other fields are working fine. If someone can take a look, I would be very greatful. The script is below: EDIT How do I enter the script... I can't seem to paste it in... <b>EDIT:<b>I worked it out and it is posted below
:<? include_once "./admin_homepage.php"; $sid = session_id (); session_register("$start"); if ( session_is_registered ( "user_name")) { if ( $p_id) { delete_image ( $p_id); } if ( $p_id1) { delete_image ( $p_id1); } function tick ($name,$value,$value1,$label) { echo "<tr>\n<td align=right class=bodyfontwhite>\n"; echo "$label</td>\n<td>\n"; echo "<input type=checkbox name='$name' value='$value'"; if ($value == $value1) { echo " checked "; } echo ">\n</td>\n</tr>\n"; } // function category_full_list ( ) { global $s_id,$site,$PHP_SELF,$cid,$start,$st,$st1, $frontend_labels,$admin_fields, $admin_links; echo "<h1><span class=\"white\">".$admin_links["CARS"]."</h1></span>"; if ( empty ($start)) { $start = 0; } echo "<table border=0 cellpadding=0 cellspacing=0><tr><td><a href = \"$PHP_SELF?mode=edit&new=yes&s_id=$s_id\"><img src='../images/butaddcar.jpg' border='0' alt=\"".$admin_links["ADD"]."\" border='0'></a></td></tr></table>\n "; echo "<table>\n"; echo "<tr>\n"; echo "<td colspan=40 align=center>\n<a href='$PHP_SELF?st='>".$admin_fields["DISPLAY_ALL_CARS"]."</a>\n</td>\n</tr>\n"; echo "<tr>\n"; echo "<td>\n<a href='$PHP_SELF?st=1'>1</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=2'>2</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=3'>3</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=4'>4</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=5'>5</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=6'>6</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=7'>7</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=8'>8</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=9'>9</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=0'>0</a>\n</td>\n"; echo "<td>\n--\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=a'>A</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=b'>B</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=c'>C</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=d'>D</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=e'>E</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=f'>F</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=g'>G</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=h'>H</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=i'>I</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=j'>J</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=k'>K</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=l'>L</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=m'>M</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=n'>N</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=o'>O</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=p'>P</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=q'>Q</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=r'>R</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=s'>S</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=t'>T</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=u'>U</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=v'>V</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=w'>W</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=x'>X</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=y'>Y</a>\n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st=z'>Z</a>\n</td>\n"; echo "<td>\n -- \n</td>\n"; echo "<td>\n<a href='$PHP_SELF?st1=1'>".$admin_fields["MOST_POPULAR_CARS"]."</a>\n</td>\n"; echo "</tr>\n"; echo "</table>\n"; //KWD ADDED $query = "select distinct ".$site."_motor.id, ".$site."_motor.title, ".$site."_category.name,".$site."_motor.des, ".$site."_motor.active,".$site."_motor.click, ".$site."_motor.offer, ".$site."_motor.interior_color, ".$site."_motor.tax, ".$site."_motor.tax from `".$site."_motor`,`".$site."_category` where ".$site."_motor.cat = ".$site."_category.id "; if ( $st) { $query .= " and ".$site."_motor.title like '$st%'"; } if ($st1 == 1) { $query .= " ORDER BY ".$site."_motor.click desc "; } else { $query .= " ORDER BY ".$site."_motor.title asc "; } $result = mysql_query($query); $result = mysql_query($query); $number = mysql_num_rows ( $result); $page_count=ceil ($number/25); if ( $page_count > 0) { echo "<table>\n"; echo "<tr>\n"; echo "<td class=bodyfontwhite>\n"; echo $frontend_labels["PAGE"]; echo "</td>\n"; for ( $j = 0; $j < $page_count; $j++) { echo "<td>\n"; $start1 = $j * 25 ; echo "<a href=\"$PHP_SELF?start=$start1&st=$st\" "; echo ">".($j+1)."</a>"; echo "</td>\n"; } echo "</td>\n"; echo "</tr>\n"; echo "</table>\n"; } $query .= " limit $start,25"; $result = mysql_query($query); echo "<BR><BR>\n<center>\n<table border=\"0\" valign=\"top\" width=98%>\n"; while ($row_array = mysql_fetch_row($result)) { echo "<tr>\n<td valign=top><a href = \"$PHP_SELF?mode=edit&id=$row_array[0]\"><img src='../images/edit.gif' alt='".$admin_links["EDIT"]."' border='0'></a></td> \n "; echo "<td valign=top class=bodyfontwhite>$row_array[1]</td> \n"; echo "<td valign=top class=bodyfontwhite class=bodyfontwhite><b>$row_array[2]</b></td> \n"; if ($row_array[4] == 'y') { echo "<td valign=top class=bodyfontwhite>".$admin_fields["ACTIVE"].":<a href=\"../flyer.php?id=$row_array[0]\" target=\"_blank\">$frontend_labels[PRINT]</a></td> \n"; } else { echo "<td valign=top class=bodyfontwhite>".$admin_fields["INACTIVE"]."</td> \n"; } if ($row_array[6] == 'y') { echo "<td valign=top class=bodyfontwhite>".$admin_fields["TOCLEAR"]."</td> \n"; } else { echo "<td valign=top class=bodyfontwhite> </td> \n"; } if ($row_array[7] == 'y') { echo "<td valign=top class=bodyfontwhite>".$admin_fields["CAR_OF_THE_WEEK"]."</td> \n"; } else { echo "<td valign=top class=bodyfontwhite> </td> \n"; } echo "<td valign=top class=bodyfontwhite> ".$row_array[5]." ".$admin_fields["CLICKS"]."</td> \n"; echo "<td valign=top class=bodyfontwhite><a href = \"$PHP_SELF?mode=delete&id=$row_array[0]&s_id=$s_id\" onClick=\"return confirm('Are you sure you want to delete?')\"><img src='../images/delete.gif' alt='".$admin_links["DELETE"]."' border='0'></a></td>\n</tr> \n"; echo "<tr>\n<td colspan=8>\n<hr color='#ffffff' size='1'> \n</td>\n</tr>\n"; } echo "</table>\n\n\n"; } if ($mode == "delete1") { delete_image ( $z, $z1); $mode = "edit"; } $s_id = session_id (); // todays date $today = date("Y-m-d"); //KWD ADDED TAX, VED if ($mode == "edit") { $query = "SELECT `id`,`title`,`des`,`no_of_doors`,`color`,`vin_no`, `engine_capacity`,`reg_plate1`,`cat`,`make`,`miles`, `fuel`,`model`,`year`,`price`,`tax`,`ved`,active, offer,status,interior_color,`tax`,`ved`, transmission FROM `".$site."_motor` WHERE id = '$id' "; $result = mysql_query($query); if ($error) { print "Query Syntax (probably) Error:<br><br>$error<br>\n"; exit(); } $row_array = mysql_fetch_row($result); echo "<form NAME = \"category_edit\" action = \"$PHP_SELF?s_id=$s_id\" method = \"post\" encType=\"multipart/form-data\"> \n"; echo "<table>\n"; // echo "<tr><td>$query</td></tr>"; echo "<input type=\"hidden\" name=\"start\" value=\"$start\">\n"; // echo "<tr>\n<td>\n Title : </td>\n<td><input type=\"text\" name=\"title\" value=\"$row_array[1]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n ".$admin_fields["MODEL"]."</td>\n<td><input type=\"text\" name=\"model\" value=\"$row_array[12]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["MAKE"]."</td>\n<td>\n"; $sql1 = "select id,name from ".$site."_make order by name"; $result1 = mysql_query ($sql1); echo "<select name='make'>\n"; while ( $row1 = mysql_fetch_row ($result1)) { echo "<option value = '$row1[0]'"; if ( $row_array[9] == $row1[0]) { echo " selected "; } echo " > $row1[1]</option>\n"; } echo "</select>\n"; echo "</td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["TRANSMISSION"]."</td>\n<td>\n"; echo "<select name='transmission'>\n"; for ($i = 0; $i < sizeof ($arr_transmission); $i++) { echo "<option value = '$arr_transmission[$i]'"; if ( $row_array[19] == $arr_transmission[$i]) { echo " selected "; } echo " >$arr_transmission[$i]</option>\n"; } echo "</select>\n"; echo "</td>\n</tr>\n"; echo "<tr>\n<td valign=top align=right class=bodyfontwhite>\n".$admin_fields["DESCRIPTION"]."</td>\n<td><textarea name=\"des\" rows=16 cols=40>$row_array[2]</textarea></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["FUEL"]."</td>\n<td class=bodyfontwhite>\n"; $sql1 = "select id,name from ".$site."_fuel order by name"; $result1 = mysql_query ($sql1); echo "<select name='fuel'>\n"; while ( $row1 = mysql_fetch_row ($result1)) { echo "<option value = '$row1[0]'"; if ( $row_array[11] == $row1[0]) { echo " selected "; } echo " > $row1[1]</option>\n"; } echo "</select>\n"; echo "</td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["MILES"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"miles\" value=\"$row_array[10]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["CATEGORY"]."</td>\n<td class=bodyfontwhite>\n"; $sql1 = "select id,name from ".$site."_category order by name"; $result1 = mysql_query ($sql1); echo "<select name='cat'>\n"; while ( $row1 = mysql_fetch_row ($result1)) { echo "<option value = '$row1[0]'"; if ( $row_array[8] == $row1[0]) { echo " selected "; } echo " > $row1[1]</option>\n"; } echo "</select>\n"; echo "</td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["YEAR"]."</td>\n<td class=bodyfontwhite>\n"; echo "<select name='year'>\n"; for ($i = 1960;$i < (date("Y") + 1);$i++) { echo "<option value = '$i'"; if ( $row_array[13] == $i) { echo " selected "; } echo " > $i</option>\n"; } echo "</select>\n"; echo "</td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["PRICE"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"price\" value=\"$row_array[14]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["NO_OF_DOORS"]."</td>\n<td class=bodyfontwhite>\n"; echo "<select name='door'>\n"; for ($i = 2;$i < 7;$i++) { echo "<option value = '$i'"; if ( $row_array[3] == $i) { echo " selected "; } echo " > $i</option>\n"; } echo "</select>\n"; echo "</td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["COLOUR"]."</td>\n<td><input type=\"text\" name=\"color\" value=\"$row_array[4]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["VIN_NO"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"vin_no\" value=\"$row_array[5]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["ENGINE_CAPACITY"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"engine_capacity\" value=\"$row_array[6]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["REGISTRATION_PLATE"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"reg_plate1\" value=\"$row_array[7]\"></td>\n</tr>\n"; // KWD ADDED SAME AS ABOVE BUT WITH TAX AND VED echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["TAX"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"tax\" value=\"$row_array[15]\"></td>\n</tr>\n"; echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["VED_RATING"]."</td>\n<td class=bodyfontwhite><input type=\"text\" name=\"ved\" value=\"$row_array[16]\"></td>\n</tr>\n"; echo "<input type=hidden name=active value='y'>"; tick ("offer",'y',$row_array[16],$admin_fields["TOCLEAR"]); tick ("featured",'y',$row_array[18],$admin_fields["CAR_OF_THE_WEEK"]); echo "<tr>\n<td align=right class=bodyfontwhite>\n".$admin_fields["STATUS"]."</td>\n<td class=bodyfontwhite>\n"; echo "<select name='status'>\n"; echo "<option value = '".$admin_fields["ON_FORECOURT"]."'"; if ( $row_array[17] == $admin_fields["ON_FORECOURT"]) { echo " selected "; } echo " >".$admin_fields["ON_FORECOURT"]."</option>\n"; echo "<option value = '".$admin_fields["PENDING"]."'"; if ( $row_array[17] == $admin_fields["PENDING"]) { echo " selected "; } echo " >".$admin_fields["PENDING"]."</option>\n"; echo "<option value = '".$admin_fields["AWAITING_PREPARATION"]."'"; if ( $row_array[17] == $admin_fields["AWAITING_PREPARATION"]) { echo " selected "; } echo " >".$admin_fields["AWAITING_PREPARATION"]."</option>\n"; echo "<option value = '".$admin_fields["SOLD"]."'"; if ( $row_array[17] == $admin_fields["SOLD"]) { echo " selected "; } echo " >".$admin_fields["SOLD"]."</option>\n"; echo "</select>\n"; echo "</td>\n</tr>\n"; $sql1 = "select id,name from ".$site."_miles order by name"; $result1 = mysql_query($sql1); $i = 0; while ( $row1 = mysql_fetch_row($result1)) { echo "<input type=hidden name='nam_id[$i]' value='$row1[0]'>\n"; $sql2 = "select article_id from ".$site."_pars where article_id = '$id' and par_id = '$row1[0]' order by article_id"; $result2 = mysql_query($sql2); if (mysql_num_rows($result2) == 1) { $temp = 'y'; } else { $temp = ''; } tick ("nam[$i]",'y',$temp,"$row1[1]"); $i++; } for ( $i = 10;$i < 50; $i++) { echo "<tr>\n<td align=right class=bodyfontwhite>\n"; echo $admin_fields["IMAGE"]." ".($i - 9)." "; echo "</td>\n<td class=bodyfontwhite>\n"; image_list ( $id, $i); echo "</td>\n"; echo "</tr>\n"; } // echo "<tr>\n<td align=right class=bodyfontwhite>\n"; // echo "Banner Image :"; // echo "</td>\n<td class=bodyfontwhite>\n"; // image_list ( $id, "98"); // echo "</td>\n"; // echo "</tr>\n"; echo "<input type=\"hidden\" name=\"mode\" value=\"edit2\"> \n"; echo "<input type=\"hidden\" name=\"id\" value=\"$id\">\n"; if ($new == "yes") { echo "<input type=\"hidden\" name=\"new\" value=\"yes\">\n"; } echo "<tr>\n<td colspan = \"2\" align='right'><input type=\"submit\" name=\"submit\" value=\"submit\"></td>\n</tr>\n"; echo "</table>"; echo "</form>"; } elseif ($mode == "edit2") { if ($status == 'PENDING') { $active = 'n'; } $sql = "select name from ".$site."_make where id = '$make'"; $result = mysql_query($sql); list ($make1) = mysql_fetch_row($result); $sql = "select name from ".$site."_fuel where id = '$fuel'"; $result = mysql_query($sql); list ($fuel1) = mysql_fetch_row($result); // $title = "$make1, $model, $color, $year, $fuel1, $miles ".$admin_fields["MILES"].""; $title = "$make1 $model ($year) in $color ($transmission)"; if (!get_magic_quotes_gpc()) { $des = mysql_real_escape_string($des); } if ( $new == "yes") { $query = "INSERT INTO `".$site."_motor` (transmission, interior_color ,offer,status,click,active,`id`, `title`, `des`, `no_of_doors`, `color`, `vin_no`, `engine_capacity`, `reg_plate1`, `cat`, `make`, `miles`, `fuel`, `model`, `year`, `price`) VALUES ('$transmission', '$featured','$offer','$status','0','$active','', '$title', '$des', '$door', '$color', '$vin_no', '$engine_capacity', '$reg_plate1', '$cat', '$make', '$miles', '$fuel', '$model', '$year', '$price')"; } else { $query = "UPDATE `".$site."_motor` SET transmission = '$transmission', interior_color = '$featured', offer = '$offer',status = '$status', active = '$active',title = '$title',des = '$des',no_of_doors = '$door',color = '$color',vin_no= '$vin_no',engine_capacity= '$engine_capacity', reg_plate1= '$reg_plate1',cat= '$cat',make = '$make',miles = '$miles',fuel= '$fuel',model = '$model',year = '$year',price = '$price' WHERE id = '$id'"; } $result = mysql_query($query); if ( $new == 'yes') { $query = "SELECT max(id) FROM ".$site."_motor order by id desc"; $result = mysql_query($query); if ($error) { print "Query Syntax (probably) Error:<br><br>$error<br>\n"; exit(); } $row_array = mysql_fetch_row( $result); $id = $row_array[0]; } $sql = "delete from ".$site."_pars where article_id = '$id'"; $result = mysql_query($sql); for ($i = 0; $i < sizeof ($nam_id); $i++) { if ($nam[$i] == 'y') { $sql = "insert into ".$site."_pars (article_id,par_id) values ('$id','$nam_id[$i]')"; $result = mysql_query($sql); } } for ( $i = 10; $i < 51; $i++) { unset( $temp,$temp1); $temp = "at_".$i; $temp1 = $$temp; if ($temp) { $attachfile = $_FILES["$temp"]['tmp_name']; $actualtype = $_FILES["$temp"]['type']; $at_var_size = $_FILES["$temp"]['size']; $actualname = $_FILES["$temp"]['name']; insert_image ($actualname, $attachfile, "3000", "3000", "4000000", $actualtype, $i, $id); } } category_full_list(); } elseif ($mode == "delete") { $query = "DELETE FROM `".$site."_motor` WHERE id = '$id'"; $result = mysql_query($query); $sql = "delete from ".$site."_pars where article_id = '$id'"; $result = mysql_query($sql); delete_image ($id."_3"); for ( $i = 10; $i < 51; $i++) { $z = $id."_".$i; delete_image ($z); } category_full_list(); } else { category_full_list(); } } echo "</center>"; echo "</td>\n</tr>\n"; echo "<tr><td class=bodyfontwhite>\n"; echo "<center><b><a name='help'></a>H E L P</b></center><br>\n"; echo $admin_message["HELP_CARS"]; echo "</td></tr></table>\n"; include "../footeradmin.php"; ?> Code (markup):
Ok I have worked it out. Just one thing: I now need to get a label to be displayed in the table cell before each of the tax and ved columns: how do i do this?
Sorry I have actually worked it out now! I spent hours and hours trying before posting here, then I suddenly work it out in ten minutes!Typical