Datalist with db component

[Simon Ruckledge]

Hi Guys/Girls

I have been learning the db conector/mysql/php thingy and have so far had
some limited success. I am now able to connect sucessfully to a database,
retrieve info, edit info and do a very basic search (more of a sort really).

I am now trying to take this forward. I want to be able to display a list of
results that then click into the full details,
ie, a list of business names, when I click on a selected business this then
gives me the full details.

In addition to this I want to be able to link up to mals cart. I have used
stacked pages in the past (http://www.icedoutuk.com/)
as per example attached but want to start offering dynamic sites so they are
easier/quicker to update. However, I cant seem to work out how the db
component will achieve this. Usually, i insert fields into html around the
buy it now button and this has proved successful but again this needs to
work with the mysql/php/db component. I have searched around the best I
could before troubling you guys but am now in need of your expert guidance.

The test site (appologies for the dyer design but this is just a test!!) is
at http://www.viewmysite.co.uk/business/index.html
(running on windows 98 se, 1&1 shared linux hosting with php + 1 mysql
database and NOF version 8 db component )

Thanks in anticipation

Simon Ruckledge
Partner

studio fortynine website design
www.studiofortynine.com
tel: 01977 619832

[Heath Holden]

Can you tell me how you did the search page
herehttp://www.viewmysite.co.uk/business/index.html? That is exactly what
I'm trying to do. What version NOF are you using?
Thanks
Heath

"Simon Ruckledge" <si...@studio49online.com> wrote in message
news:cdgas2$m9...@news01.netobjects.com...

[Simon Ruckledge]

Hi Heath (using fusion 8)

I sort of made it up as i went along by trial and error and couldn't believe
it when it worked
Anyway, here goes:

Set up record set called search with all datafields in connector (last tab
on nav in fusion8)
created search.html page

create form 2 cols by 2 rows
add comb box with values (drop down list)
add submit button
set form action to results.php (under form settings)
set method - get

create results page in site view and use custom name to give it .php
extension

add connector to page
add if condition (conditions = search post code starts with form.postcode
(select this by using custom variable))
Add Iterator - type=start, name = results, records per page=10,
recordset=search, start row 1)
create table - add lable for name and address
add iterator - end

Add if condition - elsif search.postcode does not contain form post code

add tect box under this saying
sorry no results
under this ad if condition saying endif

You should end up with two pages, one the seach.html and the other the
results.php. It took me until 4am to work it out but it does work ok. I
supposed you could modify it to work as a search page.

If you have any probs, please contact me again and i could possibly zip it
up or take screen shots

Thanks

Simon

"Heath Holden" <hol...@booksmartinc.com> wrote in message
news:cdpasl$p8...@news01.netobjects.com...