Hi, sorry to post just after subscribing but I didn't find anything in the faqs.
I have to port an Oracle-based system to MySQL and am now investigating how to get rid of the Oracle specialities. I neither wrote the system nor do I fully understand how it's working yet, so I might miss something. The biggest trouble spot seems to be the use of the ora_bind functions as in the following example: $e = db_parse ($curs, "insert into usercomments values "."(:pkey,:pser,:pnam,:pema,:pdat,:ptxt,:psub,:pref) ") if ( ! $e ): $err = "Error in insert statement!"; $errn = $curs; else: db_bind ($curs, "param_key", ":pkey", 6, 1); db_bind ($curs, "param_ser", ":pser", 16, 1); db_bind ($curs, "param_nam", ":pnam", 128, 1); db_bind ($curs, "param_ema", ":pema", 128, 1); db_bind ($curs, "param_dat", ":pdat", 64, 1); db_bind ($curs, "param_txt", ":ptxt", 1024, 1); db_bind ($curs, "param_sub", ":psub", 128, 1); db_bind ($curs, "param_ref", ":pref", 16, 1); if (!db_exec ($curs)): $err = "Could not execute insert statement, sorry!"; $errn = $curs; else: endif; endif; The problem is that I don't really see what the use of the ora_bind is here. Is there anything that would forbid the port to: mysql_query("insert into usercomments values( $param_key, $param_ser, ..., $param_ref)"); Or am I missing something substantial here? Thanks a lot, Christian -- Christian Schneider <[EMAIL PROTECTED]> Zentrum für Angewandte Informatik --.. .- .. -.- Universitätsweiter Service .-. .-. --.. -.- + Universität zu Köln + Robert-Koch-Str. 10 + D-50931 Köln + Tel. +49 221 478 7021 + -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php