Đã hoàn thành

121403 Parent-Child Query and Display

We currently have a website that replicates for our users when they sign up. At the time of signup they are linked in the mySQL database with a parent/child relationship with their referrer. The database hierarchy is linked through the �member id�.

Our members also have multiple custom fields to use in personalizing their own replicating website (also stored in the same mySQL database).

The public web pages then use custom tags that query the mySQL database and display the member�s personalized information. This information is determined by the member�s �username� displayed in the website affiliate url.

We can also display their referrer�s information on the web pages using the �left join� function and �sponsor� personalization tags.

The public web pages are stored in a folder named �template�. At the current time, the web pages are all .htm but can be converted to .php if needed.

Here�s what we need:

When someone visits the member�s website and the member has empty customization fields in their profile, we want the script to query up the hierarchy (as many levels as it takes) to find the next available �parent� whose field is NOT null (empty). We then want that information to display on the website of the original member.

We want this to work for current custom fields as well as fields we may add in the future.

Kĩ năng: Bất kì công việc gì, PHP, SQL

Xem nhiều hơn: php script null, n query, named query, linked in sign in, replicating website, parent, display, child, sql database relationship, sql stored function, linked sign, display mysql, mysql sql function, web query time, php mysql query multiple, display field, php mysql database query, mysql empty database, display customization, query query, affiliate replicating website, php referrer affiliate script, can someone null script, script mysql query php, affiliate customization script

Về Bên Thuê:
( 5 nhận xét ) Watertown, United States

ID dự án: #1867569

Được trao cho:


No problem, easy job!

$45 USD trong 0 ngày
(1 Nhận xét)