Page 1 of 1

MySQL Statement Syntax and Logic

Posted: Sat Jul 28, 2007 12:26 pm
by legend986
I have two questions...

1. I need to enable registrations on my forum on another website. My forum is Invision. I wanted to know if there's a way to know what all SQL statements are carried out or what all database updates were performed after a particular step because the coded of the original script is really complex to make out any sense.

2. I want to connect to my forum's database from the other website. How would i do that? I mean Remote SQL Connection...

Please Help...

Posted: Sun Jul 29, 2007 1:25 pm
by mwasif
2. I want to connect to my forum's database from the other website. How would i do that? I mean Remote SQL Connection...
Use your Mysql server's IP address in mysql_connect(). And allow the user to connect remotely. e.g.

Code: Select all

$link = mysql_connect("21.34.56.123", "user", "pass");

Posted: Sun Jul 29, 2007 11:41 pm
by legend986
Thank you... Any idea about the answer for my first question please?

Posted: Mon Jul 30, 2007 7:05 am
by superdezign
legend986 wrote:Thank you... Any idea about the answer for my first question please?
It really sounds like something you'd need to do manually. If you handled your database queries through your own class, you could do it easily.