Page 1 of 1

Any sample scripts to connect and query with MySQL database?

Posted: Mon May 01, 2006 1:54 pm
by alex298
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

Posted: Mon May 01, 2006 2:04 pm
by malte
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

Posted: Mon May 01, 2006 2:27 pm
by alex298
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

Posted: Mon May 01, 2006 2:59 pm
by Janschenkel
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.