Just for Newbies
Subject: Re: MySQL + Roxen
Posted on: 7 October 1999 by Philip M. Hofer (Frumph)
Post: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:
mysql://user:password@localhost
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">
<tr>
<td>#userid#</td>
<td>#username#</td>
<td>#city#</td>
</tr>
</sqloutput>
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:
