1. How do I set up the search options so that the visitor conducts a general search, he can just get all the listings listed alphabetically? This would be whether he selected a specific category, or no category at all.

2. I can't seem to figure out how to center the search results header.
Example: http://www.eyesontraffic.com/cgi-bin/dbman/db.cgi?db=default&uid=ceniti.101033873317241&ID=&Title=&URL=&Type=---&Date=&Category=---&Description=&ma=on&keyword=the&mh=10&sb=5&so=ascend&view_records=View+Records.

3. Can I import an existing database? If so, is there a specific format I need to use? I was thinking about building one in MS Access. But I'm open to suggestions as to what works best with dbman. Should it be a specific format (comma delimited, tab delimited)?

4. Does a guest have to login by entering guest for user ID and password, or can I provide a link to bypass the login page?

Thanks for your help (again)

1) In your sub html_view_search and sub html_view_failure you can set up default sort options

I do this by adding:

<input type="hidden" name="sb" value="$sort_field">
<input type="hidden" name="so" value="$sortorder">

to my forms and then in my .cfg file I set the variables:

$sort_field ='4'; ### field number to sort by
$sortorder = 'ascend';

2) Not sure which header you are referring to ... your link will not work as it is for a logged in user. But I'm guessing you are referring to the header within sub html_view_success

3) Look in the FAQ noted below under the section "Files" for information about importing existing databases.

4) To have a default user view the database without logging in you would create your link like this:

http://www.eyesontraffic.com/cgi-bin/dbman/db.cgi?db=default&uid=default

Be sure to set up your .cfg file to allow default users and specify what they can do.

$auth_allow_default = 1;
@auth_default_permissions = (1,0,0,0,0); # (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.

Hope this helps


Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/