PLEASE DISREGARD MY LAST POST: I am trying to do it through a new method but I still can't get my results. Alright instead of trying to pull the date from a different field I have added an insert record behavior to when the user uploads his page so it enters the date into the subscribe table, it works fine, and is entered into the database, BUT, I am still having trouble getting that date to be the one that shows up next to the last uploaded page.
My database is structured as follows:
ID=Key Column
subscribe2=(the username of the one being subscribed to)
subscriber= (the username of the one subscribing)
date=(a timestamp)
SUBID=( a unique numerical ID associated with each user)
Now when someone (user1)subscribes to a user (user2) the following would be entered into the database
ID=auto
subscribe2=user2
subscriber=user1
date=current
SUBID=6(user2's unique numerical no.)
Now when user2 uploads a new page the following is entered into the same database
ID=auto
subscribe2=NA
subscriber=NA
date=current
SUBID=6(user2's unique numerical no.)
so if the two above were consecutive rows it would look like this
1 - user2 - user1 - 1/3/2010 - 6
2 - NA - NA - 1/4/2010 - 6
My RSquery looks like this
("SELECT * FROM subscribe WHERE subscriber = %s ORDER BY `date` DESC"
This gives me the results as far as the users name being subscribed to, but with the date in row 1.
How can I get the users name being subscribed to BUT with the date from row two. Being that the SUBID field would be identical I thought I could group them together somehow but I'm not sure as to the method. Thanks!