[PHP-DB] Re: characters problem

2004-12-17 Thread Panos Yahoo
It doesn't work :( I also read on the php.net for addslashes and stripslashes but still nothin :( Any other ideas guyz? Thx Panos Nadim Attari [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] $myquery=INSERT INTO `$table` (`comments`) VALUES ('$mycomments'); $mycomments =

RE: [PHP-DB] characters problem

2004-12-17 Thread Bastien Koert
Two years and you haven't heard of: addslashes? mysql_reaL_escape_string? or even something as simple as $comments = str_replace(','',$comments); to replace the one quote with two single quotes (don't forget to remove them on the display...) bastien From: Panos Yahoo [EMAIL PROTECTED] To: [EMAIL

RE: [PHP-DB] Re: characters problem

2004-12-17 Thread Bastien Koert
try echoing out the sql to see what it looks like, you may also have magic_quotes turned on...turn it off bastien From: Panos Yahoo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: characters problem Date: Fri, 17 Dec 2004 11:20:01 +0200 It doesn't work :( I also read on the php.net

[PHP-DB] mysql to access

2004-12-17 Thread Perry, Matthew (Fire Marshal's Office)
Does anyone know of a FREE program that exports MySQL to access? The trial versions of the ones I have downloaded do not export all the records of the database. - Matthew

RE: [PHP-DB] mysql to access

2004-12-17 Thread Norland, Martin
-Original Message- From: Perry, Matthew (Fire Marshal's Office) [mailto:[EMAIL PROTECTED] Does anyone know of a FREE program that exports MySQL to access? The trial versions of the ones I have downloaded do not export all the records of the database. If you can get a .csv export

[PHP-DB] Apache2+PHP5, Connecting to multiple Oracle servers

2004-12-17 Thread Mikael Jokela
Hi, I use Apache2+PHP5 on Linux to connect to an Oci8 compliant remote Oracle server. I have compiled PHP against the Oracle client release 10.1.0. This works fine so far. I need to connect to an older remote Oracle server, too. This Oracle version is 8.0.5 which seems to be too old to work with

RE: [PHP-DB] mysql to access

2004-12-17 Thread Bastien Koert
why not just link the mysql to access? bastien From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql to access Date: Fri, 17 Dec 2004 09:33:39 -0600 Does anyone know of a FREE program that exports MySQL to access? The trial versions of the

[PHP-DB] PHP, MySQL and phpMyAdmin versions...

2004-12-17 Thread Mark Benson
I am running MySQL 3.23.49 under Windows NT (XP Home). I also run PHP 4.3.9 on the same server, and use phpMyAdmin 2.6.0-pl2 for admin to my databases. I cannot upgrade to MySQL 4.x becuase apparently the MySQL API included with my PHP distro is not up to date enough to work with the revised

[PHP-DB] html display

2004-12-17 Thread Kevin Russell
sorry but this has nothing to do with: 1. DBs 2. PHP 3. LAMP ok out right your mostly correct, but what I really want to do is display fixed content for dynamic searches for a web site on a lamp server,(fc2) their php is a little out dated, but their in the move to 5 so its ok, I would like

RE: [PHP-DB] mysql to access

2004-12-17 Thread Perry, Matthew (Fire Marshal's Office)
Here is the problem: I am currently using MySQL and PHP for this application but have realized recently that the bulk of my work is setting up three forms (add, view, modify) for each table I create. It takes hours for each table with MySQL and PHP but takes only minutes with Access. Also,

Re: [PHP-DB] Apache2+PHP5, Connecting to multiple Oracle servers

2004-12-17 Thread roy . a . jones
I compiled my PHP Apache with the Oracle 8.1.7 client for Linux. Oracle 10g can only communicate with Oracle 10g Oracle 9i. The 8.1.7 client can communicate with Oracle 7, 8, 8i, 9i, 10g. I also have a configuration compiled against the 9.2.0.4 client but it can not communicate with

RE: [PHP-DB] PHP, MySQL and phpMyAdmin versions...

2004-12-17 Thread Bastien Koert
huh? you can and should be able to upgrade to 4.0.x without too many problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin. Moving to mySQL 4.1 will involve more pain as the protocols are vastly different and uses a different php library (mysqli). For upgrade info see here

RE: [PHP-DB] mysql to access

2004-12-17 Thread Miles Thompson
Use ODBC to use MySQL from either Access or VB (or any other language!) MT At 12:25 PM 12/17/2004, Perry, Matthew (Fire Marshal's Office) wrote: Here is the problem: I am currently using MySQL and PHP for this application but have realized recently that the bulk of my work is setting up three

RE: [PHP-DB] mysql to access

2004-12-17 Thread Bastien Koert
see embedded comments bastien From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql to access Date: Fri, 17 Dec 2004 10:25:09 -0600 Here is the problem: I am currently using MySQL and PHP for this application but have realized recently

RE: [PHP-DB] PHP, MySQL and phpMyAdmin versions...

2004-12-17 Thread Norland, Martin
-Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] huh? you can and should be able to upgrade to 4.0.x without too many problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin. Moving to mySQL 4.1 will involve more pain as the protocols are vastly different

Re: [PHP-DB] characters problem

2004-12-17 Thread Jochem Maas
Bastien Koert wrote: Two years and you haven't heard of: addslashes? mysql_reaL_escape_string? or even something as simple as $comments = str_replace(','',$comments); to replace the one quote with two single quotes (don't forget to remove them on the display...) I thount that the first