[PHP-DB] sybase_connect(): Sybase: "Unable to allocate connection record" problem

2003-11-17 Thread samuel
Dear friends, I installed sybase 12.5 develop edition, apache 2.0.48 and php 4.3.4 on the same server, the php testing is no problem. But i use function sybase_connect() in program test.php, open the file in IE, error messages : Warning: sybase_connect(): Sy

Re: [PHP-DB] CSV Import Question

2003-11-17 Thread Jason Wong
On Tuesday 18 November 2003 13:07, Chris Payne wrote: > > > any ideas? Here's the code: > > > > > > $row = 1; > > > $handle = fopen ("$userfile","r"); > > > while ($data = fgetcsv ($handle, 250, "$delim")) { > > > $num = count ($data); > > > $row++; > > > for ($c=0; $c < $num; $c++) {

Re: [PHP-DB] CSV Import Question

2003-11-17 Thread Chris Payne
Hi there, > On Tuesday 18 November 2003 12:34, Chris Payne wrote: > > > I have a 2 Column CSV file, and i'm trying to import it into the DB via a > > form, I have it importing fine with the first field (Called EMail) but I > > cannot get it to import the second column correctly (Called name). I

Re: [PHP-DB] CSV Import Question

2003-11-17 Thread Jason Wong
On Tuesday 18 November 2003 12:34, Chris Payne wrote: > I have a 2 Column CSV file, and i'm trying to import it into the DB via a > form, I have it importing fine with the first field (Called EMail) but I > cannot get it to import the second column correctly (Called name). I know > it's going to

[PHP-DB] CSV Import Question

2003-11-17 Thread Chris Payne
Hi there everyone, I have a 2 Column CSV file, and i'm trying to import it into the DB via a form, I have it importing fine with the first field (Called EMail) but I cannot get it to import the second column correctly (Called name). I know it's going to be something so obvious i'll pass out, b

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread ramki
Generally in DBs, data is case sensitive. Simply you can do an uppercase or lowercase conversion in both sides. Ex : Select item number from item where upper(item_code) = upper("m1234"); -ramki - Original Message - From: "Larry Sandwick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

Re: [PHP-DB] Read file

2003-11-17 Thread Cal Evans
I've seen it done with some creative javascript. (i.e. caching to a tmp dir and accessing the txt file onChange.) But you cannot (REPEAT CANNOT) execute php on a client machine unless you load php and a web server onto that client machine. PHP is still a server side script. And 10k cookies is o

Re: [PHP-DB] Read file

2003-11-17 Thread Cal Evans
Jason Wong wrote: > On Tuesday 18 November 2003 09:58, Ng Hwee Hwee wrote: > >>the reason i don't want to read from the server is because i don't want to >>use up too much space and processing time on the server.. the file has >>50,000 records of information.. >> >>is there another way other than

Re: [PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
what about using cookies? my problem is this: i have about 10,000 hotels records and each of them has information about its location, its hotel code, its hotel tel, its country code etc... i would like to load this into the clients computer so that when they enter a hotel code, all the information

Re: [PHP-DB] Read file

2003-11-17 Thread Jason Wong
On Tuesday 18 November 2003 09:58, Ng Hwee Hwee wrote: > the reason i don't want to read from the server is because i don't want to > use up too much space and processing time on the server.. the file has > 50,000 records of information.. > > is there another way other than uploading on the server

[PHP-DB] MySQL join with variable table?

2003-11-17 Thread Jason Godesky
In a MySQL database, I have several tables, including one central table that essentially keeps track of the records in the other tables. TABLE1 +---+---+---+ | id| str | val1 | +---+---+---+ |

Re: [PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
the reason i don't want to read from the server is because i don't want to use up too much space and processing time on the server.. the file has 50,000 records of information.. is there another way other than uploading on the server side?? thanx! hwee - Original Message - From: "Jason

Re: [PHP-DB] Read file

2003-11-17 Thread Jason Wong
On Tuesday 18 November 2003 09:29, Ng Hwee Hwee wrote: > can anyone enlighten me on how i can use PHP to read the contents of a file > from the client's machine?? for eg, the client has a CSV file in his > MyDocuments directory, how can I read the contents and publish them on the > web? You have

[PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
hi all, can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? thank you lots! Hwee Hwee

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread Pedro Pais
Hey! At least in Postgresql you can do something like: SELECT * FROM table where item_code ILIKE 'blabla'; But I guess it's standard, so you can use it in any DB. Larry Sandwick wrote: Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data b

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread CPT John W. Holmes
From: "Larry Sandwick" <[EMAIL PROTECTED]> > Is there a way to run a query so that it ignores the case, and the query > is not case sensitive? What's this have to do with PHP and what database are you using? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread roy.a.jones
In Oracle you have a couple of choices. (1) If you can ensure that the data stored is in one case you can apply a function to the keyed in data SELECT item_number FROM item WHERE item_code = lower('M1234'); (2) If you can not ensure data case then you can apply the function to both side

[PHP-DB] Query Case In-sensitive

2003-11-17 Thread Larry Sandwick
Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is "m1234" Query Select item number from item where item_code = "M1234" ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Ne

RE: [PHP-DB] No tuples available

2003-11-17 Thread Ryan Jameson (USA)
Great recommendation. The @ should work great. Thanks. <>< Ryan -Original Message- From: David T-G [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 8:03 PM To: PHP DB list Cc: Ryan Jameson (USA) Subject: Re: [PHP-DB] No tuples available Ryan -- ...and then Ryan Jameson (USA

[PHP-DB] apache mod-rewrite

2003-11-17 Thread Harlan Lax
I am now trying to use the apache mod-rewrite to allow the site to be indexed by search engines. Am I correct in assuming that mod-rewrite only works with url parameters and not session variables? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.p

[PHP-DB] Passing Data between pages

2003-11-17 Thread Harlan Lax
As I am fairly new to web development I was looking into way to pass data between pages on a web site. I decided that using session variables was the most attractive but it seems like most sights use url parameters. I am now trying to use the apache mod-rewrite to allow the site to be indexed by

[PHP-DB] error configuring php4.2.3 --with solid embedded engine version 3.0

2003-11-17 Thread sjef
Hi, We're trying to configure php to work with solid but we get the following error in the output: * * Unable to locate /usr/home/solid/lib/libfex.so or /usr/home/solid/lib/libfex.a * Please correct this by creating the follow