[PHP-DB] php / xml

2003-11-26 Thread stefan bogdan
hello i'm trying to make a pattern for an economic document using xml ex document id='unique' name='document_1' fixpart field id= 'id' visible='true' name='id' type='numeric' htmltype='textbox' /field filed id='name' visible='true' name='name' type='select' htmltype='select'

Re: [PHP-DB] php / xml

2003-11-26 Thread Ignatius Reilly
The standard way is XSLT, for which PHP has excellent support. However, it takes some effort to learn the language. Get yourself XSLT by Michael Kay, Wrox Press. HTH Ignatius _ - Original Message - From: stefan bogdan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

[PHP-DB] Re: php / xml

2003-11-26 Thread Andrei BEJENARU
For an open source PHP-based XML/XSLT developement platform you could look at Krysalis (http://www.interakt.ro/products/Krysalis/index.php). Andrei Stefan Bogdan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hello i'm trying to make a pattern for an economic document using xml ex

[PHP-DB] Optimizing query for public search engine

2003-11-26 Thread Evan Morris
Hi all I'm using Firebird as the back-end for a web site. The search engine is written in PHP, using bog-standard SQL queries. Here's the problem: In order to make the results listing work well, the page needs to know how many records match the search criteria. This is so I can a) display '1 to

Re: [PHP-DB] Optimizing query for public search engine -- SORT OF SOLVED

2003-11-26 Thread Evan Morris
In case anyone is interested, I have (sort of) solved this problem. Importantly, I learned that Firebird does not support PEAR DB functions like numRows(), so you can't do it that way (at least, my version of Firebird doesn't). So what I have done is run the SELECT FIRST 15 SKIP x etc query - ie

[PHP-DB] PHP and XML Parsing

2003-11-26 Thread Rick Dahl
I have a piece of xml that has characters like and other non-normal ones. When I use the $this-parser = xml_parser_create(); functions it doesn't read the entire character sting inside the tag/tag. It stops at the . If I take out the it works perfectly. Any ideas on how I can fix this?

Re: [PHP-DB] PHP and XML Parsing

2003-11-26 Thread Ignatius Reilly
If your is meant as a content data, as opposed to an entity call, then your XML is probably not valid. To write as a character, you can either: - use #x26; directly - declare an amp; entity having the value #x26 and write amp; in your document HTH Ignatius _ -

[PHP-DB] convert date in german format

2003-11-26 Thread Ruprecht Helms
Hi, how can I convert a date stored in a mysql-database for output in the german format (dd.mm.yy). I tried date (d.m.y,$row-from); but I still get the english-format stored in the database. The databasefield is type date. Regards, Ruprecht -- PHP Database Mailing List

Re: [PHP-DB] convert date in german format

2003-11-26 Thread Hans Lellelid
how can I convert a date stored in a mysql-database for output in the german format (dd.mm.yy). I tried date (d.m.y,$row-from); the second parameter to date() should be a unix timestamp (integer). Did you convert your MySQL date to a timestamp? Try: date(d.m.y, strtotime($row-from)); if

Re: [PHP-DB] convert date in german format

2003-11-26 Thread Ignatius Reilly
at the top of your script, do: setlocale ( LC_TIME, 'de_DE' ) ; (assumes your machine has German support installed) HTH Ignatius _ - Original Message - From: Ruprecht Helms [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 16:58 Subject:

Re: [PHP-DB] convert date in german format

2003-11-26 Thread CPT John W. Holmes
From: Ruprecht Helms [EMAIL PROTECTED] how can I convert a date stored in a mysql-database for output in the german format (dd.mm.yy). I tried date (d.m.y,$row-from); but I still get the english-format stored in the database. The databasefield is type date. That's because date() wants a

Re: [PHP-DB] convert date in german format

2003-11-26 Thread Chris Boget
That's because date() wants a Unix timestamp. MySQL has it's own format. You have two options. Option 1 is to use DATE_FORMAT() in your query to retrieve the date already formated. DATE_FORMAT() works similar to the PHP date() function. Look it up in Chapter 6 of the MySQL Manual. Option 2 is

Re: [PHP-DB] convert date in german format

2003-11-26 Thread Hans Lellelid
at the top of your script, do: setlocale ( LC_TIME, 'de_DE' ) ; (assumes your machine has German support installed) Yes, this is really the right way to do date display for different locales, but it also requries that you use the strftime() function instead of date(). Like date(),

Re: [PHP-DB] convert date in german format

2003-11-26 Thread CPT John W. Holmes
From: Hans Lellelid [EMAIL PROTECTED] Using MySQL DATE_FORMAT() would work, but it's a hack solution; if you ever wanted to create an English version of your site you would have to make changes to your data-layer queries -- and that's just not where that logic belongs. So use UNIX_TIMESTAMP

RE: [PHP-DB] Re: send email

2003-11-26 Thread redhat
Thanks to all for the input. I will attempt to make this work. I am not a programmer but like to hack around when I can. If I get lost I will probably shoot another email out. thanks, DF On Tue, 2003-11-25 at 16:24, Jack van Zanen wrote: Hi my example earlier does not show the email

RE: [PHP-DB] Re: send email

2003-11-26 Thread Dan Brunner
Hello!! Sorry I missed you first post. But you want an auto-email sent out after someone inserts data into the database, Right?? And of course you want this to be transparent as much as you can. So do your insert statements to the database then using an IF-ELSE statement to check if the

[PHP-DB] testing--no message

2003-11-26 Thread Karen Resplendo
no message! - Do you Yahoo!? Free Pop-Up Blocker - Get it now

[PHP-DB] a LITTLE bug with my CSV importer :-)

2003-11-26 Thread Chris Payne
Hi there everyone, OK So I kind of have my CSV utility working nicely, except for one thing - if I import the file with PHPMyADMIN it imports over 1000 rows (Which is correct) but with the below code on the same file, it's only importing 92 rows, can anyone see anything obvious that's wrong?

Re: [PHP-DB] a LITTLE bug with my CSV importer :-)

2003-11-26 Thread Chris Payne
Hey there Roger, I just put that in (Will keep it in anyway) but I get the same problem. Could it be there's some kind of illegal char in one of the array fields? If so, how can I do checking and fix bad characters when going through the array? I know if I remove the LoDesc fields (Which is

[PHP-DB] Fixed CSV import problem

2003-11-26 Thread Chris Payne
Hi there everyone, Just a note to say i've fixed the CSV import problem, I had to excape the ' character that was in the array and now it imports all 1081 rows properly. Now I can relax and pass out LOL :-) Thanks for all the help, very appreciated. Chris

[PHP-DB] Empty Table command?

2003-11-26 Thread Chris Payne
Hi there everyone, Just a quick question which I can't for the life of me find the answer for on MySQL's website (Probably as i'm looking for the wrong term?) I want to know how to empty a table, is there an empty command or should I just tell it to delete everything? Chris

[PHP-DB] Decent Search Engine (for MySQL)

2003-11-26 Thread Gavin Amm
Hi All, I'm after a tutorial, if you can point me to one I'd appreciate it. I want to create a search script that will look through tables/fields (that I specify) in a MySQL database. I don't want to use the MySQL full text searching (as I'm using an ISP database the default min word length is

Re: [PHP-DB] Empty Table command?

2003-11-26 Thread Rasmus Lerdorf
delete from table_name On Wed, 26 Nov 2003, Chris Payne wrote: Hi there everyone, Just a quick question which I can't for the life of me find the answer for on MySQL's website (Probably as i'm looking for the wrong term?) I want to know how to empty a table, is there an empty command or