RMS: Discussion Groups
News l Modules l TechInfo l FAQ/HOWTO l RoxenProviders l Discuss l
Login :
Don't have an account? Register Forgot your password? Retreive
Benefits of Registering * Privacy Policy

Roxen Discussions

Just for Newbies

Subject: Re: MySQL + Roxen
Posted on: 7 October 1999 by Philip M. Hofer (Frumph)

Well to start the reason mysql is off the disabled list was because you compiled roxen while having mysql installed, it found the libraries and figured for itself to include mysql as a possible avenue for roxen to use.

As for actually connecting to the database itself make sure you add the sql module to your virtual server and specify the settings in the setup of the sql module in the virtual server itself.

for example under default SQL-Table host I have:


than, when I want to do something WITH the database I do something like:

<sqloutput database=sleepless
query="SELECT userid, username, city FROM userinfo ORDER BY username">

notice I utilize the database= inside the line, .. one thing to look for is to make sure that the user:password you use has access to do things to the particular database you use. (mind you thats inside mysql to setup permissions not roxen)

[ New Post ]   [ Post Reply ]   [ Previous Post ]   [ Next Post ]   [ Previous in Thread ]   [ Next in Thread ]   [ Forum Index ]

Follow Up:


Comments? Questions? < rms@riverweb.com >
visitors since .
This page last updated February 2002.
Riverweb Logo RMS is hosted by Riverweb Internet Commerce
Copyright © 1998 H. William Welliver III
This site is powered by Roxen Challenger 1.3 and mySQL.