MySQL Statement Syntax and Logic

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
legend986
Forum Contributor
Posts: 258
Joined: Sun Jul 15, 2007 2:45 pm

MySQL Statement Syntax and Logic

Post 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...
mwasif
Forum Newbie
Posts: 13
Joined: Sun Jul 15, 2007 1:24 pm

Post 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");
User avatar
legend986
Forum Contributor
Posts: 258
Joined: Sun Jul 15, 2007 2:45 pm

Post by legend986 »

Thank you... Any idea about the answer for my first question please?
User avatar
superdezign
DevNet Master
Posts: 4135
Joined: Sat Jan 20, 2007 11:06 pm

Post 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.
Post Reply