[PHP-DB] commas

2003-07-17 Thread Chris Mach
Is there a function that will strip or add commas? I'm trying to do calculations with attendance numbers of football games... for example: 33,153 right now I don't have a comma for the numbers in the database. So the above example is 33153 in my database. If I put the comma in, when I try to do

RE: [PHP-DB] commas

2003-07-17 Thread Gary . Every
Check out the php function number_format($field,0) Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Chris Mach [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:43 AM

RE: [PHP-DB] commas

2003-07-17 Thread Edward Peloke
format_number() should do what you want http://us3.php.net/manual/en/function.number-format.php Eddie -Original Message- From: Chris Mach [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] commas Is there a function that will strip

RE: [PHP-DB] commas

2003-07-17 Thread Edward Peloke
sorry, I am a backwards today...number_format() -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 9:01 AM To: Chris Mach; [EMAIL PROTECTED] Subject: RE: [PHP-DB] commas format_number() should do what you want

[PHP-DB] Full text search

2003-07-17 Thread Angelo Zanetti
Hi guys can anyone point me to some resources with regard to doing full-text searches in php. I looked at the mySQL docs and there doesnt seem to be much there. TIA. Angelo

[PHP-DB] PHP Full Text SOLVED-dont worry

2003-07-17 Thread Angelo Zanetti

[PHP-DB] Oracle ODBC connection Problem

2003-07-17 Thread angel
i'm trying to connect to a oracle database using the odbc driver with the followin script: - ?php$user=user;$upasswd=password;$dsn = dsn; $query = select sysdate from dual;print pquery is:

[PHP-DB] PDF Implementation

2003-07-17 Thread dpgirago
Good Morning All , Has anyone successfully implemented PDF functionality within their PHP / MySQL projects? My needs are very basic, so I'd like to use something like ezPDF creation to avoid buying a license. But I haven't yet got ezPDF to work correctly. Set up is Win2k, PHP 4.3.2, Apache

[PHP-DB] osCommerce - which merchant service/payment gateway?

2003-07-17 Thread Becoming Digital
I'm in the midst of a project for which I am using the osCommerce shopping cart and I'm currently trying to find a merchant service and payment gateway that will integrate smoothly with it. I'm currently leaning towards payQuake (http://www.payquake.com) as their fee structure is quite

Re: [PHP-DB] osCommerce - which merchant service/payment gateway?

2003-07-17 Thread mike karthauser
on 17/7/03 3:07 pm, Becoming Digital at [EMAIL PROTECTED] wrote: I'm sorry for going slightly off-topic, but I'm sure many of you have experience with this issue. Every shopping cart *does* use a database, after all, and I'm sure someone else will find this useful, too. Thanks a lot.

Re: [PHP-DB] osCommerce - which merchant service/payment gateway?

2003-07-17 Thread Becoming Digital
Thanks, Mike. I should have specified that I'm in the States and accordingly need a US-based gateway. Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: mike karthauser

[PHP-DB] Re: commas

2003-07-17 Thread Chris Mach
Thanks guys! number_format() works great!! Chris Mach [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is there a function that will strip or add commas? I'm trying to do calculations with attendance numbers of football games... for example: 33,153 right now I don't have a comma

Re: [PHP-DB] PDF Implementation

2003-07-17 Thread Norma Ramirez - TECNOSOFT
Check out this page:http://www.ros.co.nz/pdf/, is a useful class and you can implement with any kind of database. Norma Ramirez Area de Desarrollo Web [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 9:01 AM Subject:

Re: [PHP-DB] PDF Implementation

2003-07-17 Thread Pierre-Alain Joye
On Thu, 17 Jul 2003 09:01:53 -0500 [EMAIL PROTECTED] wrote: Good Morning All , Has anyone successfully implemented PDF functionality within their PHP / MySQL projects? My needs are very basic, so I'd like to use something like ezPDF creation to avoid buying a license. But I haven't

[PHP-DB] Re: PDF Implementation

2003-07-17 Thread \[PHP-DB\] news.php.net
We have generated PDF files with de FPDF library from data stored in a MYSQL database. It's a pure PHP class with basic functionality, so it can be installed easely in a Hosting. www.fpdf.org [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Good Morning All , Has anyone

[PHP-DB] Insert/Update help needed

2003-07-17 Thread Mike Baerwolf
Hello all, I've been able to get the below to work pretty much. The only problem I have is when there is an apostrophe in the data of one of the fields like (You're the One). When this occurs nothing gets updated or inserted(tried both). I've done other things from forms inserting/updating

RE: [PHP-DB] Insert/Update help needed

2003-07-17 Thread Hutchins, Richard
Mike, Pretty sure your solution is to addslashes() around whatever data might contain the apostrophes. HTH, Rich -Original Message- From: Mike Baerwolf [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 11:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Insert/Update help needed

[PHP-DB] Access 95 ODBC Annoyance

2003-07-17 Thread J. Michael Roberts
I'll be the first to admit this is a rather backwards system and prone to be illogical, but it's what was handed to me and I can't do much about that. I've got an ancient Access 95 database that I've linked to via another A95 database which is queried via ODBC. It was done this way because I'm

Re: [PHP-DB] Access 95 ODBC Annoyance

2003-07-17 Thread Robert Twitty
If the other application opens the database exclusively, then you will not be able to open it, even for read only. The only solution to modify the sharing option used by the other application. Another problem you may encounter is that the ODBC driver for Access is not thread safe. -- bob On

RE: [PHP-DB] Access 95 ODBC Annoyance

2003-07-17 Thread Will Howard
JMR, The problem might be overcome by instructing the other users to make certain they do not open the database in exclusive. I no longer have a copy of Access 95 around, but I seem to recall that we had this problem when the database was opened by another user who had open exclusive checked in

Re: [PHP-DB] Access 95 ODBC Annoyance

2003-07-17 Thread J. Michael Roberts
I discovered the problem at had was in the network permissions set on the file (?) that was denying Apache to access it properly and the error code returned was the best thing the system could come up with. I changed my Apached service to 'run as' and authorized user (me) and it happily viewed

Re: [PHP-DB] Access 95 ODBC Annoyance

2003-07-17 Thread otherguy
If you're deleting or modifying or re-creating any linked tables, that might require exclusive access. Access will automagically put you into exclusive mode if you do something like this. Try closing out as soon as you've updated the DB. -Cameron Wilhelm On Thursday, July 17, 2003, at 02:21

[PHP-DB] Tricky Database Question

2003-07-17 Thread Sam Richardson
I'm developing an application that is going to deal with information about different animals, and breeds of those animals. So far it is quite straight forward, I've created four tables, [Species] (containing a ID and name) [Breed] (also containing an ID, Name and relative link to the Species)

Re: [PHP-DB] Tricky Database Question

2003-07-17 Thread Peter Beckman
What about a 5th table which stores metadata: table metadata: mdidmediumint unsigned not null auto_increment table varchar(15) not null xid mediumint unsigned not null name varchar(25) not null valvarchar(25) not null The table will have all the metadata you

Re: [PHP-DB] editing part of a field

2003-07-17 Thread JeRRy
Hi, But won't update update the what I input. I only need PART of the post to update, only the selected url area and want the remaining of the message to be unchanged. Won't the update change the whole message? I think it does, I only need part of the message to be edited and that is the URL