HELP!!! I cannot insert/update any products in my database

[Guest]

This is what I have done:

 

Insert HTML in the text field instead of text - i.e. using HTML tags

 

I can preview a new item or an existing item, but when I press INSERT or UPDATE - nothing. No movement no nothing :cry:

 

Anyone help before I have a nervous breakdown!!!

[Guest]

post a sample of the html you are trying to insert and which field (ie: description) are you trying to use it in.

[Guest]

I think I have fixed it (yes I am an idiot)

 

Check out this code:

<table width="200" border="0" cellspacing="0" cellpadding="0">

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_sold_out.gif" width="200" height="25"></td>

</tr>

<tr>

<td background="http://www.mygeekshop.com/catalog/images/description/product_background.gif"><font size="2"> 

</font> <table width="180" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td><font size="2" face="Microsoft Sans Serif">Regular Price $15.95</font><font face="Microsoft Sans Serif"><br>

<font color="#FF0000" size="3"><strong>Our Price $13.55</strong></font><br>

<font size="1">That's a saving of 15% ($1.40)</font></font><br>

</td>

</tr>

<tr>

<td colspan="2"> <div align="center">

<input type="hidden" name="products_id" value="30">

<input type="image" src="http://www.mygeekshop.com/catalog/includes/languages/english/images/buttons/button_in_cart.gif" border="0" alt="In Cart" title=" In Cart ">

 </div></tr>

</table></td>

</tr>

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_bottom.gif" width="200" height="25"></td>

</tr>

<tr>

<td><font color="#333333" size="1" face="Microsoft Sans Serif">Age?/Audience?</font></td>

</tr>

<tr>

<td><font color="#333333" size="1" face="Microsoft Sans Serif">Rating? (insert

Rating Graphic)</font></td>

</tr>

<tr>

<td><font color="#333333" size="1" face="Microsoft Sans Serif">Manufacturer:

<Insert Image></font></td>

</tr>

<tr>

<td><font color="#333333" size="1" face="Microsoft Sans Serif">Item Number</font></td>

</tr>

</table>

<hr>

<p><font size="2" face="Microsoft Sans Serif"><strong>Description:</strong></font></p>

<p><font size="2" face="Microsoft Sans Serif"><enter description here><br>

<br>

<strong> Special Features:</strong><br>

<br>

<Enter Special Features/What you get here></font></p>

<hr>

<table width="350" border="0" cellspacing="0" cellpadding="0">

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_background_350_top.gif" width="350" height="20"></td>

</tr>

<tr>

<td background="http://www.mygeekshop.com/catalog/images/description/product_background_350.gif"><table width="345" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="345"> <form name="tell_a_friend" method="get" action="http://www.mygeekshop.com/catalog/tell_a_friend.php">

<div align="center">

<div align="left"></div>

</div>

<div align="left"><font size="2" face="Microsoft Sans Serif"><br>

Tell a friend about this product.

<input name="image2" type="image" title=" Tell A Friend " src="http://www.mygeekshop.com/catalog/includes/languages/english/images/buttons/button_tell_a_friend.gif" alt="Tell A Friend" border="0">

<input type="hidden" name="products_id2" value="30">

</font></div>

<font size="2" face="Microsoft Sans Serif"> </font> </form></td>

</tr>

</table></td>

</tr>

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_background_350_bottom.gif" width="350" height="20"></td>

</tr>

</table>

<br>

<table width="350" border="0" cellspacing="0" cellpadding="0">

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_background_350_top.gif" width="350" height="20"></td>

</tr>

<tr>

<td background="http://www.mygeekshop.com/catalog/images/description/product_background_350.gif"><table width="320" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td width="157" valign="top"><img src="http://www.mygeekshop.com/catalog/images/description/product_weight.gif" width="33" height="33" align="left"><strong><font size="2" face="Microsoft Sans Serif">Weight:</font></strong><br>

<font color="#666666" size="1" face="Microsoft Sans Serif"><insert

weight><br>

</font><br>

</td>

<td width="163" valign="top"><img src="http://www.mygeekshop.com/catalog/images/description/product_measurements.gif" width="33" height="33" align="left"><strong><font size="2" face="Microsoft Sans Serif">Dimensions:</font></strong><br>

<font color="#666666" size="1" face="Microsoft Sans Serif"><insert

dimensions><br>

</font></td>

</tr>

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_giftwrap.gif" width="33" height="33" align="left"><strong><font size="2" face="Microsoft Sans Serif">Gift

Wrap</font></strong>:<br>

<font color="#666666" size="1" face="Microsoft Sans Serif">Avaliable at Checkout</font></td>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_power.gif" width="33" height="33" align="left"><strong><font size="2" face="Microsoft Sans Serif">Batteries:</font></strong><br>

<font color="#666666" size="1" face="Microsoft Sans Serif"><insert

description></font></td>

</tr>

</table>

</td>

</tr>

<tr>

<td><img src="http://www.mygeekshop.com/catalog/images/description/product_background_350_bottom.gif" width="350" height="20"></td>

</tr>

</table>

 

Basically I feel that the bolded area was the problem. What I did was create a form for TELL A FRIEND in the actually HTML. The result was no records could be updated

 

If I create it without the form, then the whole html works, and it's rocking.

 

I was wanting to remove the tell a friend box on the right and add it to the document but this isnt the way to do this :oops:

 

So lesson for all - dont mess with a good system - you will get results you dont want to know about! :cry: :oops:

 

Thanks,

James