On Thu, 15 May 2003 13:05:09 -0500
"Vaughn, Paul" <Paul.Vaughn@amhealthways.com> wrote:
> Sorry, I should have posted two messages. This example was for connecting
> to Oracle.
>
> My issue seems to have been not including the connection ($conn) with the
> ociparse statement. I was not accustom to that with MySql.
>
> $result = mysql_query("select * from users");
>
> vs.
>
> $sql = ("select * from dw_val.process_user");
> $query = OCIParse ($conn, $sql);
there should also follow
OCIExecute($query);
> Now I'm am connected and returning results from my query. For future
> reference, is this just a difference in coding style, or mysql and oci
> functions?
In mySQL there is nothing much to do between the query and the execution
while in Oracle you can also bind the variables once they were parsed
and before they get executed. read the documentation. Take a look at
OCIBindByName().
--
Maxim Maletsky
maxim@php.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
