RE: [PHP-DB] converting extracted variables to arrays

2001-12-17 Thread Beau Lebens
$var_array = explode("#", "student#name#address#college#etc... #...#"); // -Original Message- // From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 18 December 2001 3:07 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] converting extracted variables to arrays // // /

[PHP-DB] converting extracted variables to arrays

2001-12-17 Thread sharmad
Hi, i have a variable which is multi valued seperated by # (say as) delimiter like student#name#address#college#etc... #...# i want to seperate it into an array with index $i can anyone suggest a way to do so TIA -Sharmad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

Re: [PHP-DB] Re: Table to BIG to dump, how ?

2001-12-17 Thread Nagasea
there are no error message, the browser is suddenly stop (like no connection) --- "Fred" <[EMAIL PROTECTED]> wrote: >Where is the error msg? > >Fred > >Nagasea <[EMAIL PROTECTED]> wrote in message >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> I always got this error message when I tried to dum

Re: [PHP-DB] duplicated entry for key #

2001-12-17 Thread Miles Thompson
This is custom error messaging. Julie Meloni has published a good tutorial on this, which you can find at http://www.thickbook.com. Have a look at that. What you do is seek into your users table before creating an insert. Your form, as its action, calls itself, so you are passing your variabl

[PHP-DB] Re: Converting english date formats to french....

2001-12-17 Thread Fred
You can use PHP to format the date: http://php.he.net/manual/en/function.date.php or use MySQL: http://www.mysql.com/doc/D/a/Date_and_time_functions.html see DATE_FORMAT() Fred Vincent Beaulieu <[EMAIL PROTECTED]> wrote in message 004001c18741$ffba54b0$1b737a89@universiqhgcnn">news:004001c18741

[PHP-DB] duplicated entry for key #

2001-12-17 Thread nautilis
Hi everybody! My problem is: I have a form to allow users in a website to register. My problem is that when someone registers a name that is alredy taken, mysql returns a 'Duplicate entry 'username' for key 1. I just want to show a message to user telling that the username is in use by another

[PHP-DB] Re: Table to BIG to dump, how ?

2001-12-17 Thread Fred
Where is the error msg? Fred Nagasea <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I always got this error message when I tried to dump my structure and data table to a file. > I think it's because the file table size it BIG (almost 10mb). > Is there anyway

[PHP-DB] Converting english date formats to french....

2001-12-17 Thread Vincent Beaulieu
Hi All, Does anyone have a quick and easy trick to convert dates from a MySQL database from English to French? I have a Calendar that uses PHP and MySQLworks wonderfully in English...having trouble converting the dates to a French format though. Are there built-in MySQL or PHP functions that

[PHP-DB] Table to BIG to dump, how ?

2001-12-17 Thread Nagasea
I always got this error message when I tried to dump my structure and data table to a file. I think it's because the file table size it BIG (almost 10mb). Is there anyway to dump that table to file without getting browser time out ? Please help me here.. -Naga _

Re: [PHP-DB] PostgreSQL and Regular Expressions

2001-12-17 Thread GB Clark II
On Monday 17 December 2001 09:12, Joe Koenig wrote: > I've been digging through the postgres docs and haven't found a way to > use reg ex's in a query. Is there a simple way? Something similar to > MySQL's RLIKE? I'm trying to select all records that start with a number > [0-9]. Thanks, > > Joe Ta

Re: [PHP-DB] Dumb Question??

2001-12-17 Thread Daniel Barton
Russ - That's exactly what I'm doing with this GIS application I'm working on (I may not have understood your original question?) Here's the general design (although it's all OOP so it's a little less clearcut): 1) Table with "projects" in it - contains basemap, associated datatable(s), and

[PHP-DB] PHP + DB2 for stored procedures

2001-12-17 Thread Rares Vasilescu
hi Anyone here used PHP to connect to a IBM DB2 database? Of course, using ODBC. I am having difficulties calling stored procedures with input/output parameters. Please enlighten me. Rares -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition

[PHP-DB] PostgreSQL and Regular Expressions

2001-12-17 Thread Joe Koenig
I've been digging through the postgres docs and haven't found a way to use reg ex's in a query. Is there a simple way? Something similar to MySQL's RLIKE? I'm trying to select all records that start with a number [0-9]. Thanks, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscri

RE: [PHP-DB] Query Help

2001-12-17 Thread Rick Emery
Well, there's two ways I can think of: 1) SELECT category FROM table ORDER BY category; Then cycle through the returned list of categories and assign the category to $category. For each category, do: SELECT * FROM table WHERE category=$category ORDER BY minor_category; 2) SELECT * FROM table

[PHP-DB] Using persistent connection to database

2001-12-17 Thread Berlina
Hi to everybody, first sorry for my poor english. im trying to use persistents connections to an Oracle Database through PHP, for manageing transactions, and have some problems. My Schema: * Web Server: Apache 1.3.20 on a Linux RedHat 7.0 * PHP: 4.0.6 compiled with oracle module functions (ora_

Re: [PHP-DB] Dumb Question??

2001-12-17 Thread Russ Michell
> Russ - >Why not (MySQL) extract the field always, and code into your (php) generic mechanism >whether or not a > particular field under that name appears? Using mysql_fetch_assoc() you could >exclude 'modified' from > your generic mechanism under particular circumstances. This avoids coding i