[imparator]

Hi guys, im in the middle of converting a script that uses a MySQL databae so that i can use it with an Oracle database. The thing is that since MySQL and Oracle functions are a bit different im a bit lost.

Can anyone help me convert the following segments of MySQL to the equivelent in Oracle?

Note: all i've included is the MySQL code that i've used

Code:

// Set MySQL Variables

	$host = 'localhost';
	$user = 'user';
	$pass = 'password';
	$db = 'my_db';
	$table = 'my_table';

mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());


//Print the data

	$query  = "SELECT * FROM post";
	$result = mysql_query($query);

	while($row = mysql_fetch_row($result))
	{
	    $name    = $row[0];
	    $post = $row[1];
    	$ip = $row[2];
    	$pid = $row[3];

print "$post";
}

// Connect to the Database and add the stuff

			mysql_connect($host,$user,$pass) or die(mysql_error());
			mysql_select_db($db) or die(mysql_error());
			$add_all = "INSERT INTO $table values('$name','$comment','$ip','$cid','$pid2')";
			mysql_query($add_all) or die(mysql_error());

[digioz]

Here is a quick tutorial on what you are looking for:

http://www.webmonkey.com/webmonkey/0...tml?tw=backend