i have trouble with this select.. where syntax. it works well if i state what i want selected, eg 'select booktitle, price from africana_books where booktitle="maasai_of_kenya"' but if i use it with a php form and replace what i want selected with "$maasai_of_kenya" i get sorry, no records found.

Try swapping the quotes around. Put the "" around the whole thing and the '' around the individual fields.

thanx Chapman. it worked. tell me r u good with matts formmail. (scriptarchive.com)

i have customized one for my site but one region doesnt work well.

i have configure it to send visitors form entries to my email.

it my email it shows:

from: nameofvisitor@visitorsserverdetails.com
to: qurya@fishers-ofmenministries.org


that from is inaccurate, how it picks the name of visitor and assumes that is the email address is a mystery. may we can carry this on through our emails so i can send you the whole script.