Re: Moving from MySQL to Oracle

On Thu, 24 Aug 2000, you wrote: > I've been developing with PHP for quite some time now, however I've allways > used MySQL as a database (when doing php apps with db backends). However, I > just got a new job (see my sig :) ) and this place uses nothing but Oracle. > > I've read the Oracle 8 functions and sort of understand them but I would like > to see some examples.... > > So if anyone who knows both MySQL and Oracle functions well could convert the > following code from using MySQL to using Oracle it would give me a great > understanding of it...thanks: > > -- Code -- > $dbConn = @mysql_connect("host", "user", "password"); > mysql_select_db("myDb", $dbConn); > > $sql = "Select * from bigtable order by somerow"; > if($result = mysql_query($sql, $dbConn)) { > if($row = mysql_fetch_array($result)) { > do { > echo "$row[somerow] and $row[thisrow]"; > } while($row = mysql_fetch_array($result)); > } > } > > @mysql_close($dbConn); > > > Thanks :) So no one can help me out here?? -- James Atkinson ----------------------------------------------------------------- James Atkinson 100world Technical Developer 512-1529 West 6th Avenue phone: +1-604-637-8122 Vancouver, BC, V6J 1R1 fax: +1-604-742-1770 Canada email: james.atkinson@100world.com http://www.100world.com +---------------------------------------------------------------+ | This message may contain confidential and/or privileged | | information. If you are not the addressee or authorized to | | receive this for the addressee, you must not use, copy, | | discolse or take any action based on this message or any | | information herein. If you have received this message in | | error, please advise the sender immediately by reply e-mail | | and delete this message. Thank you for you cooperation | +---------------------------------------------------------------+