[PHP-DB] Insert problem

G'day all, I have a problem with an insert which is proving infuriating. When I run the following code everything seems to work (no errors) except the database remains empty. When I echo $query and run it from a command line it inserts fine. I don't get any connection errors - in fact when I

[PHP-DB] PHP and ODBC

How to cofigurare PHP in order to approach PostgreSQL using ODBC? Thanks -- Antonio Musarra Phone: +39 334 3401157 Phone: +39 328 8113527 Mail: [EMAIL PROTECTED] Web: http://www.romcad.it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: newbie lost on data import - solved

It seems that my text file was a UNICODE text file I have no idea how that happened as this was exported from Excel. So, anyway, now I know to check the file format before I spend over 100 hours trying to figure out why I could not INSERT to a database. Thanks to all who offered help,

Re: [PHP-DB] ODBC Database

Unless I am mistaken, but isn't there an ODBC driver available for MySQL called MyODBC? -- bob On Sun, 10 Aug 2003, Gerard Samuel wrote: Larry E.Ullman wrote: Im looking at venturing into working with PHP's ODBC extention. Does anyone have any recommendations as to a Database, that is

[PHP-DB] mysql problem importing data

Hi there, I have a data file with data seperated by semicolons. It is about 8MB big. Now I just want to import it into mysql. I tryed several things. First I took phpmyadmin, which resulted in a white page without error msg. Then I tryed it by hand with load data. This did not work as well. No I

[PHP-DB] looping code

Hello all I have a helpdesk application that was written in php and I would like to create a script that will e-mail the systems staff how many open helpdesk tickets they have. There are 10 users and I can wrtie a script no problem to do a count and then e-mail that to a user I just have no

Re: [PHP-DB] PHP MSSQL

This is true if Shaun was using MySQL, but he is using MSSQL. MSSQL allowas you to declare char and varchar fields with lengths up to 8000 characters. Unfortunately the extension bundled with PHP cannot read beyond the first 255 characters. This is primarily due to the fact that the extension

Re: [PHP-DB] ODBC Database

[EMAIL PROTECTED] wrote: whoops, meant to include thishttp://www.mysql.com/downloads/api-myodbc-3.51.html Unless I am mistaken, but isn't there an ODBC driver available for MySQL called MyODBC? -- bob I haven't a clue. Ill look, maybe it will help me create drivers for my DB

[PHP-DB] PHP MSSQL

Hi I am currently trying to use PHP and MSSQL together but I am having a few problems. I can enter data into the Db OK, but when pulling the data back to display on the page, the string cuts to around 250 chars. The Db field is VarChar 6000 and I can see the whole data in the field. I have

[PHP-DB] ODBC Database

Im looking at venturing into working with PHP's ODBC extention. Does anyone have any recommendations as to a Database, that is easy to understand/get into from a novice point of view, that installs on windows 2k, and is free? Thanks for your suggestions. -- PHP Database Mailing List

RE: [PHP-DB] Don't know why query works this way

Quoting Aaron Wolski [EMAIL PROTECTED]: Here's some functions I use in my development which save on connect and query calls for me. //General Purpose Utilities. //db_connect connects to the database server and selects the proper database. //Arguments: None //Returns: Nothing

Re: [PHP-DB] Sorting issue

You have to change kwo VARCHAR(10) NOT NULL, for kwoint(10) NOT NULL, Hope this helps Fernando Soto From: Jeff Date: Viernes, 08 de Agosto de 2003 10:36:33 a.m. To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Sorting issue Yes duh... I didn't realize numbers weren't considered