i hav two tables add_url and user_credit....

add_url fields
1.url_id
2.url

user_credit fields
1.url_id
2.user_id

as per screenshot given ....it retrieve the values from add_url table...
when d logined user clicks the "start browsing" option ... it saves the values of user id,url id ---- to the user_credit tables....

now when the user comes back to the page .... clicked urls must be shown as "credited" instead of "start browsing" ....by comparing add_url table(url_id) with d user_credit table(url_id)

plzzz...help ...how can i do it.....

Cant you just add a field for "clicked"

if that field has a value of 1 then show Clicked. if its 0 ( you set to default 0 ) then show ClickMe.

?

Originally Posted by lynxus

Cant you just add a field for "clicked"

if that field has a value of 1 then show Clicked. if its 0 ( you set to default 0 ) then show ClickMe.

?

where i add tat?? ...add_url table ?? ....

Wherever your reading the list from?

If i understand what your trying to do..Is.
Someone logs in.
They click a link and youw ant it to show clicked for that account?


I would have 2 tables..

1 with urls and user id's in.

and another for that user.

IE:
usertable
-id ( int - primary key - auto incr )
-username ( varchar )
-password ( varchar )
-credits (int )

urltables
-id ( int - primary key - auto incr )
-username ( varchar )
-url ( varchar )
-clicked ( int )

Then when someone adds a url,
You add it to the urltable ie:
lynxus http://google.com 0

Shows my name, url and if its clicked.

When they click it,, Update this table to show cliecked - 0 where username = lynxus and url = google.com
then update their credits to credits + credits +1 ( $credits ++; )


Hope this makes sense?

Basically you link urls to users in your user table.

Keeping it clean.

url tables r updated by admin....i jus retrieving it to d users page....


check ur vistors message...

Use the PM system NOT visitor messages

ok...thanx

i dnt knw whether u understand my concept...