[yakovw]

Hallo

Please help on this asp programming.

I want to display family members details from access db - (Family.mdb)
I have many records of families members with these details:
Name; Fname; Pname; Age; Phone; Email; Address; Son_No
I have a Page called: All.asp
There, I list All the "Pname - Fname" - each is a link to: ShowFamily.asp (Pname = Parent's name, Fname = last name)

If I choose: "Maria_Dan" I go to: ShowFamily.asp?Pname=Maria_Dan page.

How do I get the right children's to the Chosen Family from the other page: (All.asp)

I want to display the Chosen Family, Parent's name at first (Parent's name is Unique) and bellow
All family members (order by "Son_No").
How can I gather all the children's of "Maria_Dan Griffin" display this way:

Maria & Dan Griffin

Drew Griffin
18, student, living in London
Email…Phone….

Mike Griffin
24, student, living in Oxford
Email…Phone….

Son No 3…

Thank you.
Yakov

[Catalyst]

If I understand you want to get all the children of Maria_Dan, so you do a SQL query like:

SELECT * FROM tablename WHERE pname='Maria_Dan'

and just swap out Maria_Dan with your querystring value for Pname. Note: You should cleanse the querystring before you use it so that someone can't do a SQL injection attack on your database.

See http://www.4guysfrom.../061902-1.shtml for example

So

sql = "SELECT * FROM tablename WHERE pname='" & Replace(Request.Querystring("pname"), "'", "''") & "'"

[yakovw]

Thanks!

I'll try to do so.

Yakov