Add/Edit/Delete Problems...LONG

BoostinZX

Hey guys/girls, I have been looking around here for a while, and cannot find anything that helps me out, so I figured I would ask. I have found some threads that were similar to the problem I am having, but not one that can answer my question... anyways here it goes... and if this is out of place or whatever I am sorry...

I am very very new to php and mysql, but have been designing websites for a while with just plain ole html and xhtml... and I have taken a project on for a friend of mine to make him a website where he can list cars for sale. I have the layout already done, and working with html, but I want to change the box's where the cars are listed into php so that he can add new cars without having to call me all the time. The current static site is www.southeastsupercars.com you can go there and look at the design that I have made and get an idea for what I am trying to do... anyways, I have setup an admin page to where he can add/edit/delete car listings. I have the add.php working, but I cannot get the edit or delete to work.. I don't even know where to start. I have even looked into a premade CMS but they offer waaaaaaaaay too much for what I am trying to do. In other words they are overy complicated🙂... anyways, if anyone feels like helping me out please e-mail me at boostinzx at turbokars dot com, or catch me on aim at boostnzx... or respond here... Below is the code that I have made already.

This is the page that is just the dummy page, practicing to try to get the tables to work right so i can just add them to the index of the live site...

[INDENT]<b><center><h1>Car Listings</h1></center></b><br><br><p>
</p>
<link href="CSS.css" rel="stylesheet" type="text/css">
<table width="360" height="222" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" height="222">
<table width="360" height="190" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="369"> <div align="left">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" class="Car_Current_Availability_Title_Red"><strong>FOR
SALE </strong></div></td>
</tr>
</table>
<table width="358" height="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr class="Car_Small_Listing">
<td width="160" rowspan="10"><div align="center"> <a href="car_detail_pages/96_Silver_Cobra_0001.htm"><img src="car_pictures/96_Silver_Cobra_0001/mini-cobra_right_small.jpg" width="150" height="113" border="0"></a><br>
[click pic for more info]</div></td>
<td width="61" class="Navigation">Year:</td>
<td width="137">1993</td>
</tr>
<tr>
<td width="61" class="Navigation">Make: </td>
<td width="137" class="Car_Small_Listing">Mazda</td>
</tr>
<tr>
<td class="Navigation">Model: </td>
<td class="Car_Small_Listing">RX7 Twin Turbo</td>
</tr>
<tr>
<td class="Navigation">Trans: </td>
<td class="style1"><p class="Car_Small_Listing">5-Speed</p></td>
</tr>
<tr>
<td class="Navigation">Mileage:</td>
<td class="Car_Small_Listing">103,000</td>
</tr>
<tr>
<td class="Navigation">VIN:</td>
<td class="Car_Small_Listing"><font face="Arial, Helvetica, sans-serif">JN1CSEI39477321</font></td>
</tr>
<tr>
<td class="Navigation">Price:</td>
<td class="Car_Small_Listing"><font face="Arial, Helvetica, sans-serif">$19,000</font></td>
</tr>
<tr>
<td class="Navigation">Mods: </td>
<td rowspan="3" valign="top" class="Car_Small_Listing">Intake, Exhaust, ECU
</td>
</tr>
<tr>
<td class="Navigation"> </td>
</tr>
<tr>
<td class="Navigation"> </td>
</tr>
</table>
</div></td>
</tr>
</table>
 </td>
<td width="50%"> </td>
</tr>
</table>
<p>
</p>
<link href="CSS.css" rel="stylesheet" type="text/css">
<table width="360" height="222" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" height="222">
<table width="360" height="190" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="369"> <div align="left">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" class="Car_Current_Availability_Title_Red"><strong>FOR
SALE </strong></div></td>
</tr>
</table>
<table width="358" height="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr class="Car_Small_Listing">
<td width="160" rowspan="10"><div align="center"> <a href="car_detail_pages/96_Silver_Cobra_0001.htm"><img src="car_pictures/96_Silver_Cobra_0001/mini-cobra_right_small.jpg" width="150" height="113" border="0"></a><br>
[click pic for more info]</div></td>
<td width="61" class="Navigation">Year:</td>
<td width="137">300</td>
</tr>
<tr>
<td width="61" class="Navigation">Make: </td>
<td width="137" class="Car_Small_Listing">Nissan</td>
</tr>
<tr>
<td class="Navigation">Model: </td>
<td class="Car_Small_Listing">300ZX Twin Turbo</td>
</tr>
<tr>
<td class="Navigation">Trans: </td>
<td class="style1"><p class="Car_Small_Listing">5-speed</p></td>
</tr>
<tr>
<td class="Navigation">Mileage:</td>
<td class="Car_Small_Listing">260,000</td>
</tr>
<tr>
<td class="Navigation">VIN:</td>
<td class="Car_Small_Listing"><font face="Arial, Helvetica, sans-serif">JN1CZ2393484</font></td>
</tr>
<tr>
<td class="Navigation">Price:</td>
<td class="Car_Small_Listing"><font face="Arial, Helvetica, sans-serif">18,000</font></td>
</tr>
<tr>
<td class="Navigation">Mods: </td>
<td rowspan="3" valign="top" class="Car_Small_Listing">Intake, Exhaust, Intercoolers
</td>
</tr>
<tr>
<td class="Navigation"> </td>
</tr>
<tr>
<td class="Navigation"> </td>
</tr>
</table>
</div></td>
</tr>
</table>
 </td>
<td width="50%"> </td>
</tr>
</table>
<p>
</table></p>[/INDENT]

Here is the code for my add.php

[INDENT]<body bgcolor="F5f5f5">
<h1 align="center">Add A New Car</h1>
<form action="insert.php" method="post">
<div align="center"><br>
<table width="44%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Make:</td>
<td width="65%"><input name="make" type="text" id="make" size="30"></td>
</tr>
<tr>
<td>Model:</td>
<td><input name="model" type="text" id="model" size="30"></td>
</tr>
<tr>
<td>Year:</td>
<td><input name="year" type="text" id="year" size="30"></td>
</tr>
<tr>
<td>Mileage:</td>
<td><input name="mileage" type="text" id="mileage" size="30"></td>
</tr>
<tr>
<td>Transmission:</td>
<td><input name="transmission" type="text" id="transmission" size="30"></td>
</tr>
<tr>
<td>VIN:</td>
<td><input name="vin" type="text" id="vin" size="30"></td>
</tr>
<tr>
<td>Price:</td>
<td><input name="price" type="text" id="price" size="30"></td>
</tr>
<tr>
<td>Exterior:</td>
<td><input name="exterior" type="text" id="exterior" size="30"></td>
</tr>
<tr>
<td>Interior:</td>
<td><input name="interior" type="text" id="interior" size="30"></td>
</tr>
<tr>
<td colspan="2"><div align="center">Short Mod List:</div></td>
</tr>
<tr>
<td colspan="2"><p align="center">
<input name="shortmods" type="text" id="shortmods" value="" size="50">
</p></td>
</tr>
<tr>
<td colspan="2"><div align="center">Long Mod List:</div></td>
</tr>
<tr>
<td colspan="2"><div align="center"></div>
<div align="center">
<textarea name="longmods" cols="50" rows="5" id="longmods"></textarea>
</div></td>
</tr>
</table>
<br>
<input type="Submit" value="Add Car">
</div>
</form>[/INDENT]

BoostinZX

Here's the rest... it wouldnt let me post it because it was too long...

and here is the insert.php that add calls... I don't know if this is the right way to do it or not, you should probably just include this in the add.php code itsself, but this is the way I got it to work... lol

insert.php

[INDENT]<body bgcolor="f5f5f5">
<meta http-equiv="refresh" content="3;URL=index.html">
<?
include("../dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO cars VALUES ('','$make','$model','$year','$mileage','$transmission','$vin','$price','$exterior','$interior','$shortmods','$longmods')";
mysql_query($query);
echo "Car Insterted Into DB, You Will Now Be Redirected to the Admin Menu";
mysql_close();
?> [/INDENT]

The add part of the code works, I just cannot get the edit or the delete functions to work, if you need anymore information, or if you need me to try to explain this more clearly, please let me know and I will do my best... Like I said... I am new to this so go easy on me🙂.. Also I need them to be able to upload pictures to the listing also. and when they click on the box that lists the car's main stuff, it should take them to a detail page just like what the static site that is online does right now...

Summary: I want the exact site that I made in html, to be in php so the guys I made the site for can update the site on their own...lol

Thanks in advance!

-Ian