Re: Oracle and PHP question

As this is an Oracle usenet group, not a SQL Server one, I am can not fathom your assumption that I, or most anyone else here, would know what functionality you need.

So either post an explanation of what you are trying to do in English or look at REF CURSORS. Which is my best guess as to what you want.

But a bit of caution is due. Oracle is not just another brand of SQL Server. The architecture is completely different. If you are thinking you are going to recreate what you've already done replacing functinality 'A' in SQL Server with functionality 'B' in Oracle you are going to make a big mess. And please blame it on yourself ... not on Oracle.

Daniel Morgan

Michael Segulja wrote:

> Is there an equivalent function in Oracle to mssql_fetch_object? I have
> a SQL Server database I use for simple invoicing, and I would like to
> recreate this database with Oracle. I am taking an Oracle class, so
> basically it would be for practice.
>
> I have a customer table, and a web page to view a list of all customers
> in the table. Here's basically what I do with the code:
>
> mssql_fetch_object(query string to get the customers)
> print into a table $row->customer, $row->contact.
>
> How do I choose only the columns I want with the Oracle functions? I
> understand there is not an equivalent function to get a result set as an
> object, so the above does not work. Do I just name the columns in my
> select statement?
>
> Looking at the PHP documentation for OCI8, it looks pretty different
> from what I'm used to. I really appreciate the help, and any advice on
> how you guys to it out there in the real world.
>
> Thanks,
>
> Michael Segulja
> LMD Computing|Solutions
Received on Mon Feb 18 2002 - 11:23:52 CST