[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

[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] 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:

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] 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.

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

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 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

[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] 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 to

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

[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 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

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

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 uploading

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

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:

[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,

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 be

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 know

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++) { mysql_query (INSERT

[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():