Help with select query

farel

Hello, I'm trying to have transactions recorded and displayed in a manner similar to how paypal displays their history in those neat little tables. I just need to know how to get my database table to select it to act like that.

My table is as follows

Id
Sender
Reciever
Description
Date

I am trying to create a query that when user "tim" goes to his history page a query can check that if he is in either sender or reciever and give the details and date in a html table sort of like paypal displays. Thank You

mcrbids

Sorry. I can only offer pointers.

1) There's an article posted here a while back about using templates - read it:
http://phpbuilder.com/columns/david20000512.php3
to which I once wrote a followup:
http://www.devshed.com/Server_Side/PHP/PHPLib/page1.html

This will help you with the "in nice, neat tables" bit.

2) To get the sql, you'll see something like
mysql_query("select * from $table");

Unfortunately, you don't specificy what database you're using. (MySQL, Postgres, Oracle, CSV?)

I'd be happy to put together a quote for doing it for you, but without alot more detail, I can't be of all that much assistance.

farel

Hello,

Im sorry for the vague aspect of my post I'm fairly new to all this and don't really know what is needed. I am using mysql database. My idea is to use a query sorta like this.

Select id, sender, reciever, desc, date From where sender or reciever = $membername

The table I want to show up is just for that user that is logged in such as this.

if they made two trades the code searchs the entire shares table and finds if they were involved in any and if so returns the id# Desc and date and rather it was recieved or sent.

Transaction ID TO/From Description Date
232123 From NYE 11/13/04
453536 To IBM 12/11/03

Like that sorta I hope that clarifies and if not just let me know what you need to know and I appreciate the links.