Any sample scripts to connect and query with MySQL database?

alex298 · Post by **alex298** » Mon May 01, 2006 1:54 pm

Hello,

I decide to use RR and MySQL with my project. I have some experience in using SQL with other computer languages. However I have problem to get start with RR. My problem is:

Are there any sample scripts and tutorials to use RR connect and query with MySQL database?

Thanks and best regards

malte · Post by **malte** » Mon May 01, 2006 2:04 pm

Hi Alex,

you might want to look at Sarahs mySQL stacks, which you can download here:

http://troz.net/Rev/tutorials.php

All the best,

Malte

alex298 · Post by **alex298** » Mon May 01, 2006 2:27 pm

Malte,

Thanks

I download the MySQLtests.rev and play around. However I have another question:

All computers in the LAN are running windows OS. The MySQL database is installed on a server and the RR stack is running on a client. What is the path of the MySQL database?

Thanks and best regards

Janschenkel · Post by **Janschenkel** » Mon May 01, 2006 2:59 pm

Hi Alex,

When you connect to a MySQL database, you specify the host of the database as an IP-address or its hostname). So suppose that the server is called "gandalf.example.net", you'll connect to it like:

Code: Select all

get revdb_connect("mysql","gandalf.example.net",.....)
    or
get revdb_connect("mysql","192.168.2.50",.....)

Ask your network administrator if you don't know exactly what the server is named or what IP-number it has.

Hope this helped,

Jan Schenkel.