donnan

Hi Keith, Thanks for your reply mate. I found the syntax error was being caused because of an ealier query that wasn't getting correct data to apply to this query. I am learning though. Thanks again for your help. Most appreciated.

Firstly BACKUP the original db. I would create a new table with an id field with Auto Increment set then use something like this: SELECT distinct email FROM originaltable WHERE id > 0 Get the results of that query and then paste them into this. INSERT INTO newtable SET email = value1, name = value2.....then any other fields. Hope this helps.

You should look for any CSS style class called "center". Are you trying to center the link? If so, remove the class="center" from the anchor tag and place a div tag to center your link as below. <div align="center"><a href="somesite.htm">Link Here</a></div>

Hi Denno, How many photos on a page are you talking about? If they are .jpg's have you optimized each photo to make them as small is kb as possible?

Hi guys, My server mysql version is 5.1.55 I have been pulling my hair out trying to figure where I have got the syntax wrong with this one. mysql_query("UPDATE `gemps_shares` SET `given_gemps` = given_gemps + " . $gemps . ", `total_gemps` = given_gemps + link_gemps WHERE `user_id` = '$_REQUEST[user_id]' AND `user_id` = '$_REQUEST[owner_id]'") or die (mysql_error()); I am just trying to add values from field `given_gemps` to a int variable $gemps, then getting a total by adding `given_gemps` field to `link_gemps` field and settting `total_gemps` field with the result. It's got me where I have gone wrong. I think I have tried everything. Maybe it's something really simple. Thanks in advance for your help and guidance.