So im looking to integrate a search function into a website and I have a feeling that XML is a good way to go about this as I can document my website.
At the moment I have a website that uses two tables; one which is prepopulated called quality_info:
quality_id
quality_name
what_is_it
how_it_works
suitable_for_x
suitable_for_y
etc
and another table called quality_user that the user populates
user_id
which_activity_x
which_activity_y
which_income_x
which_income_y
suitable_for_x
suitable_for_y
the user can carry out a needs analysis where they respond to questions that populate the quality_user table. Responses for the fields suitable_for_x and suitable_for_y in the quality_user table are then compared against corresponding prepopulated fields in the quality_info table (suitable_for_x , suitable_for_y). If the two corresponding fields match (are both checked) then this will be flagged and the SQL select query will display it.
I am assuming a database structure will be something on the lines of:
PageID (e.g. '1')
PageAddress (e.g. http://www.mysite.com/iso.php)
PageTitle ('Quality standard ISO 9000')
quality_name('ISO')
what_is_it ('ISO 9000 is a quality standard..... etc')
how_it_works('it works by....')
suitable_for_x('1' checkbox value)
suitable_for_y('0' checkbox value)
How would I structure XML sourcecode within this context as well as with a view to having a search function to complement the database structure described above and in what other circumstances could XML be deployed?
thx in advance
