When a user clicks on an image, PHP script to insert a value into a field in MySQL table for a row that ALREADY exists... Much like a shopping cart for a specific user...

Basically, what I tried earlier was reading information from a cookie, but what happened in return, is it created 2 new NULL users... :/

Help?

As I stated before, it should be sorta like an online shopping cart.

/The name/id thing in the image I was talking about :

"<img src='...' width=123 height=456 name=object id=object>"

I'm not so good with PHP programming. I am trying to learn as I go, so that I don't have to keep coming here so often, and spamming the place up.

Post edited at 8:05 pm on Mar. 21, 2008 by xXDarkened ShAdowsXx

On the page that the image links to (presumably something like imageclick.php?id=$object), the code should simply be something like:

Code:

$sql = mysql_query("UPDATE `userImageClick` set `imageID` = '$_GET[id]' WHERE `userID` = '$_COOKIE[ID]' LIMIT 0,1") or die('Query failed.');

I get the feeling that I've misunderstood what you want to happen though...

-------
When they leave me, they're all smiles.
When they leave you, they're in tears.

I also don't want to use a prebuilt custom CMS... That only makes things more difficult :)

Here's a flash on what I'm trying to do...

http://img227.imageshack.us/my.php?image=examplegx3.swf

Basically, this is the function I'm using :

<?php

print"<img id='Picture' src='./picture.gif'>"

?>

How would I do what I showed you in the Flash movie?