Re: [PHP-DB] Converting from PHP4 to php5

2011-06-03 Thread Karl DeSaulniers
Google "php4 to php5 converter" or "php4 to php5 conversion" That should set you on your way. The best way I have read to do this is just run your code on a php5 server and build in php error detection of some kind, then just fix the errors as they come. :) Best, Karl On Jun 3, 2011, at 6

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-03 Thread user080701
-- From: "Richard Quadling" Sent: Friday, June 03, 2011 7:26 PM To: "Dr Vijay Kumar" Cc: Subject: Re: [PHP-DB] Converting from PHP4 to php5 On 1 June 2011 13:52, Dr Vijay Kumar wrote: i AM WONDERING IF SOMEONE CAN TAKE

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-03 Thread user080701
-- From: "Richard Quadling" Sent: Friday, June 03, 2011 7:26 PM To: "Dr Vijay Kumar" Cc: Subject: Re: [PHP-DB] Converting from PHP4 to php5 On 1 June 2011 13:52, Dr Vijay Kumar wrote: i AM WONDERING IF SOMEONE CAN TAKE

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-03 Thread Richard Quadling
On 1 June 2011 13:52, Dr Vijay Kumar wrote: > i AM WONDERING IF SOMEONE CAN TAKE UP CONVERSION OF MY SOFTWARE FROM PHP4 TO > PHP5 Whilst there will be many aspects of the code that will run quite happily, there are several features that have been deprecated and/or removed, depending upon the vers

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-02 Thread Guru™
Richard & I are waiting for an answer from someone..??? -- *Best, * *Guru™*

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-02 Thread Richard Quadling
On 1 June 2011 14:26, HallMarc Websites wrote: > Without looking at the rules (Sry barely have time to reply!) I don't think > this is appropriate for this list. I am fairly certain it is against the > rules to ask/offer work on here. > Can anyone confirm or deny? > > Thank you, > Marc Hall > Hall

RE: [PHP-DB] Converting from PHP4 to php5

2011-06-01 Thread HallMarc Websites
> i AM WONDERING IF SOMEONE CAN TAKE UP CONVERSION OF MY > SOFTWARE FROM PHP4 TO > PHP5 > Without looking at the rules (Sry barely have time to reply!) I don't think this is appropriate for this list. I am fairly certain it is against the rules to ask/offer work on here. Can anyone confirm or den

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-01 Thread Guru™
I am not a master but as per my knowledge your software which is in PHP4 should work properly in PHP5 too. -- *Best, * *Guru™*

[PHP-DB] Converting from PHP4 to php5

2011-06-01 Thread Dr Vijay Kumar
i AM WONDERING IF SOMEONE CAN TAKE UP CONVERSION OF MY SOFTWARE FROM PHP4 TO PHP5 -- Dr Vijay Kumar, E 9/18 Vasant Vihar, New Delhi-110 057 Ph: 09868 11 5354, 011-2615 4488 Email :"Dr Vijay Kumar"

RE: [PHP-DB] Converting text field to barcode CODE 39

2006-10-27 Thread Miguel Guirao
Jorge, If you have downloaded FPDF you will se that it comes with a couple of examples that you can use to learn. Miguel Guirao -Original Message- From: Jorge Giménez [mailto:[EMAIL PROTECTED] Sent: Viernes, 27 de Octubre de 2006 04:49 p.m. To: php-db@lists.php.net Subject: [PHP-DB

RE: [PHP-DB] Converting text field to barcode CODE 39

2006-10-27 Thread Bastien Koert
www.fpdf.org has a free class / tutorial bastien From: Jorge Giménez <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Converting text field to barcode CODE 39 Date: Fri, 27 Oct 2006 23:49:22 +0200 Hello. Can anyone tell me where I can find information or examples about printing on scr

[PHP-DB] Converting text field to barcode CODE 39

2006-10-27 Thread Jorge Giménez
Hello. Can anyone tell me where I can find information or examples about printing on screen or in PDF (with FDPF for example) for text fields stored on a MySQL Database with PHP 4 , PHP 5. Best regards, Jorge Gimenez

Re: [PHP-DB] Converting to Decimal

2006-06-28 Thread Skip Evans
de Junio de 2006 06:04 p.m. To: [EMAIL PROTECTED] Cc: Php-Db Subject: Re: [PHP-DB] Converting to Decimal Mark Bomgardner wrote: I am query a database and pulling some decimal values out of the table, but when I display whole numbers in php, it drops the decimal places. It takes a value of 12.00

RE: [PHP-DB] Converting to Decimal

2006-06-28 Thread Miguel Guirao
You could actually do (int) $var or use the sprintf(%d, $var); -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Miércoles, 28 de Junio de 2006 06:04 p.m. To: [EMAIL PROTECTED] Cc: Php-Db Subject: Re: [PHP-DB] Converting to Decimal Mark Bomgardner wrote: > I am qu

RE: [PHP-DB] Converting to Decimal

2006-06-28 Thread Bastien Koert
$val = number_format($row['val'],2); Bastien From: Mark Bomgardner <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Php-Db Subject: [PHP-DB] Converting to Decimal Date: Wed, 28 Jun 2006 17:20:21 -0500 I am query a database and pulling some decimal values out of the ta

Re: [PHP-DB] Converting to Decimal

2006-06-28 Thread John Meyer
Mark Bomgardner wrote: I am query a database and pulling some decimal values out of the table, but when I display whole numbers in php, it drops the decimal places. It takes a value of 12.00 in the database and makes it 12, where I need 12.00. I am having trouble finding ways to "cast" this val

[PHP-DB] Converting to Decimal

2006-06-28 Thread Mark Bomgardner
I am query a database and pulling some decimal values out of the table, but when I display whole numbers in php, it drops the decimal places. It takes a value of 12.00 in the database and makes it 12, where I need 12.00. I am having trouble finding ways to "cast" this value. markb -- PHP D

RE: [PHP-DB] Converting the Month from a word into the numerical expression

2005-10-07 Thread Bastien Koert
ths); $month_num = $Inv_Month($month); bastien From: "Ron Piggott" <[EMAIL PROTECTED]> Reply-To: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Subject: [PHP-DB] Converting the Month from a word into the numerical expression Date: Thu, 6 Oct 2005 23:09

Re: [PHP-DB] Converting the Month from a word into the numerical expression

2005-10-07 Thread Jeffrey
Ron Piggott wrote: I have the word for the month stored in the variable $month In this example $month may be equal to "June". I wonder if there is a way to use the DATE function to convert this into a numberical expression --- in this example 06 Ron Indeed there is: strtotime See http:

[PHP-DB] Converting the Month from a word into the numerical expression

2005-10-06 Thread Ron Piggott
I have the word for the month stored in the variable $month In this example $month may be equal to "June". I wonder if there is a way to use the DATE function to convert this into a numberical expression --- in this example 06 Ron -- PHP Database Mailing List (http://www.php.net/) To unsubsc

Re: [PHP-DB] Converting Date for mysql

2004-10-15 Thread Stuart Felenstein
Yes, my apologies to the list! Stuart --- David Robley <[EMAIL PROTECTED]> wrote: > May I suggest that as well as echoing mysql_error() > you also echo your > query; that way you can see _exactly_ what is being > passed to mysql and you > can resolve problems like this simply and without > resor

Re: [PHP-DB] Converting Date for mysql

2004-10-15 Thread David Robley
On Fri, 15 Oct 2004 17:26, Stuart Felenstein wrote: > See below: > --- John Holmes <[EMAIL PROTECTED]> wrote: > >> Are you sure it's the date that's causing the >> rejection? What does >> mysql_error() say? > > No, I'm not sure. At first the date was being > accepted but "wrong" in the database

Re: [PHP-DB] Converting Date for mysql

2004-10-15 Thread Stuart Felenstein
See below: --- John Holmes <[EMAIL PROTECTED]> wrote: > Are you sure it's the date that's causing the > rejection? What does > mysql_error() say? No, I'm not sure. At first the date was being accepted but "wrong" in the database. It was setting it to 1/1/2000. Someone suggested I add '' aroun

Re: [PHP-DB] Converting Date for mysql

2004-10-14 Thread John Holmes
Stuart Felenstein wrote: I have one of those widget calendars. Mysql keeps throwing back the date regardless of the way I format it. I'm passing session variables over to the database and have tried quotes ' around the date as well. Now I went ahead and changed this line: $_SESSION['f3k'] = $

RE: [PHP-DB] Converting Date for mysql

2004-10-14 Thread Bastien Koert
ubject: [PHP-DB] Converting Date for mysql Date: Thu, 14 Oct 2004 12:14:57 -0700 (PDT) I have one of those widget calendars. Mysql keeps throwing back the date regardless of the way I format it. I'm passing session variables over to the database and have tried quotes ' around the date as

[PHP-DB] Converting Date for mysql

2004-10-14 Thread Stuart Felenstein
I have one of those widget calendars. Mysql keeps throwing back the date regardless of the way I format it. I'm passing session variables over to the database and have tried quotes ' around the date as well. Now I went ahead and changed this line: $_SESSION['f3k'] = $_POST['DateAvailable'];

[PHP-DB] Converting an MS Access DateTime in PHP

2004-08-03 Thread Andrew
If I retrieve a DateTime variable from an MS Access database, how can I convert/format it in PHP? Thanks. andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread jeffreyb
UEST['this']; $that = $_SERVER['that']; etc... Jeffrey Baumgartner Date sent: Thu, 29 Apr 2004 11:40:14 +0200 From: "Kim Jacobs (Crooks) - Mweb" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sub

Re: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread John W. Holmes
From: "Kim Jacobs (Crooks) - Mweb" <[EMAIL PROTECTED]> > I have written some scripts to access my online > SQL db and I've tested the scripts on my machine > with PHP 4.3.6 and register_globals = On > Now where I host my site, uses PHP 4.3.5 and has > register_globals = Off which means of course,

Re: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Ignatius Reilly
nt to design a page so that it can be called indifferently by POST or GET. Just my 2 Belgian francs. Ignatius _ - Original Message - From: "Mikael Grön" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 29, 2004 12:42 PM Subject:

Re: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Mikael Grön
ot;Kim Jacobs (Crooks) - Mweb" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 29, 2004 11:54 AM Subject: Re: [PHP-DB] converting scripts for register_globals=Off What register_globals does (Please correct me if I'm wrong) is convert i.e. $_POST['variable_

RE: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Peter Lovatt
> -Original Message- > From: Kim Jacobs (Crooks) - Mweb [mailto:[EMAIL PROTECTED] > Sent: 29 April 2004 10:40 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] converting scripts for register_globals=Off > > > if any of you could help me out, I would greatly appreciate it..

Re: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Ignatius Reilly
- Mweb" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 29, 2004 11:54 AM Subject: Re: [PHP-DB] converting scripts for register_globals=Off What register_globals does (Please correct me if I'm wrong) is convert i.e. $_POST['variable_name'], $_GET[

Re: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Mikael Grön
What register_globals does (Please correct me if I'm wrong) is convert i.e. $_POST['variable_name'], $_GET['variable_name'] and so on to $variable_name. which isn't very good from my point of view. I suggest you make sure you use $_GET['your_variable'] when ever you're fetching a GET variable,

[PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Kim Jacobs (Crooks) - Mweb
if any of you could help me out, I would greatly appreciate it... I am an absolute beginner to php (2 weeks now) and dont know what I dont know... I have written some scripts to access my online SQL db and I've tested the scripts on my machine with PHP 4.3.6 and register_globals = On Now where I

Re: [PHP-DB] converting function to class and function (object)

2003-07-03 Thread Becoming Digital
day, 02 July, 2003 08:34 Subject: [PHP-DB] converting function to class and function (object) Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44, moxilla 1.0.1 Can someone help converting a function to a class and function. The included function in example 1 w

[PHP-DB] converting function to class and function (object)

2003-07-02 Thread ed anderson
Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44, moxilla 1.0.1 Can someone help converting a function to a class and function. The included function in example 1 works as expected but the include class and function in example 2 does not. What can I do to fi

RE: [PHP-DB] Converting Dates...

2003-03-05 Thread John W. Holmes
> I need help. I need to convert a Date column in MySQL where the date is > stored like "2003-01-15" to the following seconds "1042621252 ". SELECT TO_UNIXTIME(date_column) AS formatted_column FROM yourtable WHERE ... The TO_UNIXTIME() function will convert the date to the format you need that

[PHP-DB] Converting Dates...

2003-03-05 Thread Doug Coning
Hi, I need help. I need to convert a Date column in MySQL where the date is stored like "2003-01-15" to the following seconds "1042621252 ". I'm connecting the database through PHP to third party solution that requires this. Here is the only information that was given:

[PHP-DB] converting a Recorset into an XML string

2003-01-25 Thread Octavio Herrera
Hello everybody, I make a function that lets you convert a recordset obtained via mysql_query() into an XML string: maybe could be helpfull to yours this is the function it have 3 parameters: $rs is the recordset you want to convert $padre is the name for the

Re: [PHP-DB] converting from form -> dropdown box

2003-01-14 Thread xxx xxxx
hi, all you have to do is to extract values from the database with a query. i suppose you know... after that you have to do all you have done till now except the dropdown toolbox(that is called actually a listbox). for the list box you have to write like this: $records_returned[$i].'; ?> so th

[PHP-DB] converting from form -> dropdown box

2003-01-13 Thread Dzung Nguyen
Anybody could hep me converting the following form to dropdown box? The easier task (I assume) is to populate the box with the all possible values of a column in mySQL table (I don't know what how to do this yet, though). I also haven't been able to find the dropbox's equivalent of form's inp

Re: [PHP-DB] Converting Databases

2002-12-01 Thread Marco Tabini
Simple solution, if you only have one or two tables: dump them in comma delimited format and then use the LOAD command from the MySQL shell frontend. Alternative: use the MySQL ODBC component and export from access to that (it works like a charm if you use the latest version). Either way should m

[PHP-DB] Converting Databases

2002-12-01 Thread peter
Hi, I am pretty much new to the field of php/mysql programming, however a future project of mine may involve the importing of a large database of products. I am expecting this database to be in MS Access form and am looking for solutions in advanced. Now the question, are there any methods for exp

Re: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread Steven Dowd
Mauch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 9:27 PM Subject: Re: [PHP-DB] Converting database from MS Access to MySQL on Linux > Matthew Hildebrand <[EMAIL PROTECTED]> wrote: > > > http://www.devhood.com/Tools/tool_details.a

Re: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread Michael Mauch
Matthew Hildebrand <[EMAIL PROTECTED]> wrote: > http://www.devhood.com/Tools/tool_details.aspx?tool_id=759 > I've been very happy with this tool, and it is well worth the cost. If you are the author of the tool, you want perhaps add a note that "the tool" can convert _from_ Access _to_ MySQL on L

RE: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread SELPH,JASON (HP-Richardson,ex1)
Sent: Tuesday, October 29, 2002 10:14 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting database from MS Access to MySQL on Linux Oops... my mistake. I gave the wrong link. Here's the correct link: http://www.devhood.com/Tools/tool_details.aspx?tool_id=758 --Matthew -Origin

RE: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread Matthew Hildebrand
bject: Re: [PHP-DB] Converting database from MS Access to MySQL on Linux He wants Access to MySQL, not MySQL to Access...unless the tool does both? John - Original Message - From: "Matthew Hildebrand" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, Octobe

RE: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread Matthew Hildebrand
EMAIL PROTECTED] Subject: [PHP-DB] Converting database from MS Access to MySQL on Linux Sir, Can u pls help in "Converting database from MS Access to MySQL on Linux". Pls send the code for converting. Bye Som __ Do you Yahoo!? HotJobs - Search

Re: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread 1LT John W. Holmes
> Can u pls help in "Converting database from MS Access > to MySQL on Linux". Pls send the code for converting. http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=Converting+database+f rom+MS+Access+to+MySQL+on+Linux ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To u

[PHP-DB] Converting database from MS Access

2002-10-29 Thread Soma Shekhar K
Sir, Can u pls help in "Converting database from MS Access to MySQL on Linux". Pls send the code for converting. Bye Som __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- PHP Database Mailing List (http://www.p

[PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread Soma Shekhar K
Sir, Can u pls help in "Converting database from MS Access to MySQL on Linux". Pls send the code for converting. Bye Som __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- PHP Database Mailing List (http://www.php

[PHP-DB] converting a string to a date

2002-06-26 Thread Seth Yount
I am trying to find an example of converting a string to a date format suitable for MySQL input. for example... ' 2002 March 15 ' needs to be converted to ' 02-03-15 ' I can reverse this process fine, but am having trouble doing it this way -- Seth -- PHP Database Mailing List (http://www.p

RE: [PHP-DB] Converting values from text to numerical

2002-06-21 Thread Adam Royle
Hi Matt, I think this might be the answer to your problem. It basically checks if the string is an integer. I generally love the PHP automatic type conversion, but sometimes it can trick ya :) if (intval($val) == $val){ // integer stuff } else { // string stuff } Adam > H

RE: [PHP-DB] Converting values from text to numerical

2002-06-20 Thread Russ
sweet-as Russ -Original Message- From: Matthew Nock [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting values from text to numerical Hi Russ, thanks for the reply ... if that will evaluate whether a (in this case

RE: [PHP-DB] Converting values from text to numerical

2002-06-20 Thread Matthew Nock
[mailto:[EMAIL PROTECTED]] Sent: Friday, 21 June 2002 3:04 PM To: Matthew Nock; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting values from text to numerical Matthew: um how about using the is_int() function to decide if the value from your DB is a number or not? http://www.php.net/manual

RE: [PHP-DB] Converting values from text to numerical

2002-06-20 Thread Russ
th it.."; } else { echo "This aint a number so it must be a string, so do stringy things with it..."; } Any good? Russ -Original Message- From: Matthew Nock [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 1:00 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Co

RE: [PHP-DB] Converting values from text to numerical

2002-06-20 Thread Matthew Nock
alculation) then display the result, otherwise, just display the text. -Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 June 2002 2:53 PM To: Matthew Nock; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting values from text to numerical "is it possible to

RE: [PHP-DB] Converting values from text to numerical

2002-06-20 Thread Russ
pipes, and pick out the values (integers in this case) from the resultant array that explode() provides you with. Hope this helps you out some. Russ -Original Message- From: Matthew Nock [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 12:43 PM To: [EMAIL PROTECTED] Subject: [PHP

[PHP-DB] Converting values from text to numerical

2002-06-20 Thread Matthew Nock
I am about to build a database of products that will store features fore ach product in a separate table. I need to be able to store both text and numeric values in this table, but be able to perform mathmatical functions on the numeric variables. is it possible to have PHP covert numbers that a

[PHP-DB] Converting non latin characters

2002-06-04 Thread Andy
Hi there, I have a table containing cities of the world. Now I am running into problems because people are starting to complain that some mayor cities are not in the db like Tokyo. After checking my table I discovered that there lots of cities are written with some non latin characters. Tokyo is

Re: [PHP-DB] converting

2002-04-12 Thread Andrey Hristov
update some table set some_field='X' where ((some_field IS NULL) OR (some_field!="")); HTH Andrey - Original Message - From: "Natividad Castro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 2:47 PM Subject: [PHP-DB

[PHP-DB] converting

2002-04-12 Thread Natividad Castro
Hi to all, I'm having a lot of problems doing something that for some of you might be simple. I'm selecting fields from a table that can have an 'A', 'B' or 'C' as their value e.g. FIELDNAME_1 = 'A' FIELDNAME_1 = 'B' FIELDNAME_1 = 'C' FIELDNAME_2 = 'A' AND SO ON what I'm trying to d

[PHP-DB] Converting from FoxPro to MySQL

2002-04-03 Thread ST Ooi
How can I convert from FoxPro to MySQL, any tools to help ? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Converting Image Data Directly from MySQL

2002-03-04 Thread Josh Trutwin
Hello list, I've been stumped on this for a while, I have a large project where I am storing image data in a MySQL db for reasons I will not get into. The images are displayed as thumbnails in a table which are hyperlinks to a large file. The larger file is stored in the db as a BLOB type in GI

Re: [PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread Jason Wong
On Friday 08 February 2002 00:14, Raquel Rice wrote: > On Thu, 7 Feb 2002 17:07:35 +0100 > > Andy "Andy" <[EMAIL PROTECTED]> wrote: > > Hi there, > > > > I have a tabel with 250 entries showing a country code lik "CA" > > > > Now my application does not work on linux, because they have to be > > i

RE: [PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread JD Daniels
strtolower() -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 8:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Converting upper case letters to lower case because of db?? Hi there, I have a tabel with 250 entries showing a country code lik &qu

RE: [PHP-DB] Converting upper case letters to lower case because ofdb??

2002-02-07 Thread Gurhan Ozen
Andy, You can do it with PHP's strtolower() function.. See: http://www.php.net/manual/en/function.strtolower.php Gurhan -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Converting upper

Re: [PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread Raquel Rice
On Thu, 7 Feb 2002 17:07:35 +0100 Andy "Andy" <[EMAIL PROTECTED]> wrote: > Hi there, > > I have a tabel with 250 entries showing a country code lik "CA" > > Now my application does not work on linux, because they have to be > in lower > case. > > Can I make anyhow an bufix, or even better crea

[PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread Andy
Hi there, I have a tabel with 250 entries showing a country code lik "CA" Now my application does not work on linux, because they have to be in lower case. Can I make anyhow an bufix, or even better creating a php function to change all 250 entries to lower case. I could not find the propper f

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

[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

[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

Re: [PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Mark C. Farrington
Ok, the answer was staring me in the face. I have it all figured out now. Thanks for the help. - Original Message - From: "Mark C. Farrington" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 11:59 AM Subject: Re: [PHP-DB] Converting My

Re: [PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Daniel Barton
unit_name. > I see how the code snippet creates the dropdown box but I'm still fuzzy on > how to pass the query results. > > - Original Message - > From: "Richard Hillström (GIS)" <[EMAIL PROTECTED]> > To: "'Mark C. Farrington'" <[E

Re: [PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Mark C. Farrington
wn box but I'm still fuzzy on how to pass the query results. - Original Message - From: "Richard Hillström (GIS)" <[EMAIL PROTECTED]> To: "'Mark C. Farrington'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 9:

Re: [PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Mark C. Farrington
- Original Message - From: "Richard Hillström (GIS)" <[EMAIL PROTECTED]> To: "'Mark C. Farrington'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 9:31 AM Subject: RE: [PHP-DB] Converting MySOL query resul

RE: [PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Richard Hillström (GIS)
ursday, November 29, 2001 3:25 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Converting MySOL query results into form elements. What I need to do is query a MySQL db and turn the results into a dropdown box on a form. I've been paging through my books and I've come accross the command wri

[PHP-DB] Converting MySOL query results into form elements.

2001-11-29 Thread Mark C. Farrington
What I need to do is query a MySQL db and turn the results into a dropdown box on a form. I've been paging through my books and I've come accross the command writeOptionList which seems to be what I'm looking for but I'm not sure how to use it. Self taught programming is a joy eh? Mark C. Fa

RE: [PHP-DB] Converting Date Form Fields

2001-11-16 Thread Zach Curtis
ur database - obviously if the input to $date_month is "Jan", you need a case statement, or something like that to make sure you change it to "01". Hope it helps ;) Matt -Original Message- From: Zach Curtis [mailto:[EMAIL PROTECTED]] Sent: 16 November 2001 16:02 To: [EMAIL

RE: [PHP-DB] Converting Date Form Fields

2001-11-16 Thread matt stewart
ut to $date_month is "Jan", you need a case statement, or something like that to make sure you change it to "01". Hope it helps ;) Matt -Original Message- From: Zach Curtis [mailto:[EMAIL PROTECTED]] Sent: 16 November 2001 16:02 To: [EMAIL PROTECTED] Subject: [PHP-DB]

[PHP-DB] Converting Date Form Fields

2001-11-16 Thread Zach Curtis
I have two HTML form fields birthMonth (e.g., Jan=1, Feb=2...) and birthYear (e.g., 2001=2001, 1999=1999...). How can take these two individual form fields, then add in a default value of "1" for the birthDay (this is not asked in the form), and put this data into a MySQL table field birthDate wit

RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Christian Sandfeld
doh! ofcourse... that actually works. Thanks a bunch :) /Christian -Original Message- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 16:11 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting "text" fields to "integer&q

RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Gonzalez, Lorenzo
PROTECTED] Cc: Subject: RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file Lorenzo, That was a good suggestion (had forgotten about the between function)

RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Christian Sandfeld
01 14:57 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file Some of the databases I work with would support this as 'between' on two text fields that are sortable a

RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Gonzalez, Lorenzo
To: '[EMAIL PROTECTED]' Cc: Subject: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file Hi list, I wonder if anyone can help me out here. I'm pullin

[PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file

2001-11-15 Thread Christian Sandfeld
Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER > 37010)

[PHP-DB] Converting a FoxPro database to mySQL

2001-09-06 Thread Er Galvão Abbott
Is it possible? Is there any ready php script that does that? I only need the info that is stored in a DBF file - that I can easily access trough PHP's DBF functions and the info stored in a FPT (???) file. And, oh, I need that the client uploads the files from time to time, so that's why I ask

Re: [PHP-DB] Converting MS Access to MySQL

2001-07-20 Thread John Lim
CTED]... > yeah, cut and paste, jk, im curious too > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 19, 2001 2:15 PM > Subject: [PHP-DB] Converting MS Access to MySQL > > > > Can anyone sugge

RE: [PHP-DB] Converting MS Access to MySQL

2001-07-19 Thread Hoover, Josh
You can use ODBC to go from Access to MySQL. Get the MyODBC driver for Windows and setup your datasource so you can get to it via Access. You can do a direct export from Access to the MySQL database that way. There may be some differences, but I'm not sure of what all of them would be. Hope th

Re: [PHP-DB] Converting MS Access to MySQL

2001-07-19 Thread Taylor \"Cody\" Fletcher
yeah, cut and paste, jk, im curious too - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 2:15 PM Subject: [PHP-DB] Converting MS Access to MySQL > Can anyone suggest a good utility for converting database from MS

[PHP-DB] Converting MS Access to MySQL

2001-07-19 Thread mati
Can anyone suggest a good utility for converting database from MS Access to MySQL? Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Converting an Access DAtabase to..

2001-07-09 Thread Michael Rudel
D] > Subject: [PHP-DB] Converting an Access DAtabase to.. > > > Hey can anyone help me on how to export an Access datbase to > a .sql file > which I could just dump into my websites DB? I've tried to but when I > attempt it it wants my server, password, login etc and I dont want

[PHP-DB] Converting an Access DAtabase to..

2001-07-07 Thread Ali Khan
Hey can anyone help me on how to export an Access datbase to a .sql file which I could just dump into my websites DB? I've tried to but when I attempt it it wants my server, password, login etc and I dont want to give all that I just want a file made. Friends have done it before so I know its poss