SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jun 2001
    Location
    Iasi, Romania
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    intersting php MySQL problem

    I have a MySQl database with some persons. A record looks like: Name, Surname, sex, age, 1 to 3 links to photos (depends according to person) link to thumbnail and other details (hobby,job). Notice that may be a person without any photo.
    I need a php script which would do:
    - search the database according sex and age category (e.g 25-34, 35-44...);
    - make a three or four column html output with the results;
    - one cell (coresponding to one found record) will be like: thumbnail (or nothing if haven't a picture) and the surname bellow; the surname have to be also a hyperlink to the individual page (also a php template) of that person.
    - on the individual page (new page when click on hyperlink) will be displayed the thumbnail, links to pics and the details (only that details which have a non blank record, e.g. if the person doesn't have a hobby won't be displayed 'Hobby=......'.

    Any help would be greatly appreciated !

  2. #2
    Serial Publisher silver trophy aspen's Avatar
    Join Date
    Aug 1999
    Location
    East Lansing, MI USA
    Posts
    12,939
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    pretty basic php there, you should look over Kevin Yank's Tutorial on webmasterbase.com
    Chris Beasley - I publish content and ecommerce sites.
    Featured Article: Free Comprehensive SEO Guide
    My Guide to Building a Successful Website
    My Blog|My Webmaster Forums


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •