[PHP-DB] Re: looping code

2003-08-24 Thread Jon Drukman
[EMAIL PROTECTED] wrote: Hello all I have a helpdesk application that was written in php and I would like to create a script that will e-mail the systems staff how many open helpdesk tickets they have. There are 10 users and I can wrtie a script no problem to do a count and then e-mail that

[PHP-DB] Re: Don't know why query works this way

2003-08-24 Thread Jon Drukman
Aaron Wolski wrote: Here's some functions I use in my development which save on connect and query calls for me. aaron: i do more or less the same thing. allow me to criticize your functions in one very important respect: you do not check the return value of your calls! i would suggest that

[PHP-DB] Re: Not sure where this messages goes, but I have a question

2003-08-24 Thread Jon Drukman
fred jones wrote: Okay the weird part is that everything seems kosher, (no errors, the output from the select statement prints out the data I entered), the only problem being when I look in the database (via a webadmin or bringing up the data in another form) it's not there! In another words I'm

[PHP-DB] sqlite functions

2003-08-24 Thread andu
The function sqlite_fetch_all() mentioned in the changelog of version 1.0 of the extension is not documented in php docs. I'd like to know what is the diference between sqlite_fetch_all() and sqlite_array_query() about which the docs say that [it] is best suited to queries returning 45 rows or

[PHP-DB] How to do error feedback when adding to indexed table?

2003-08-24 Thread -{ Rene Brehmer }-
I'm not sure how to explain this, I'm totally new to MySQL and SQL as a whole, this is my first ever code using SQL at all...so plz bare with me here... I'm working with PHP 4.2.3 and MySQL 4.something (not certain what version the end-server runs). For a game clan I'm in (MPE 1A in Earth:

Re: [PHP-DB] How to do error feedback when adding to indexed table?

2003-08-24 Thread Sebastian Haag
Rene, -{ Rene Brehmer }- said: I'm not sure how to explain this, I'm totally new to MySQL and SQL as a whole, this is my first ever code using SQL at all...so plz bare with me here... I'm working with PHP 4.2.3 and MySQL 4.something (not certain what version the end-server runs). For a

[PHP-DB] Importing CSV data

2003-08-24 Thread Chris Payne
Hi there everyone, I have a database with email addresses from people who sign up for a newsletter on my website. Now, I have a utility i've written where they can save the addresses as a CSV file on their computer if they are logged in and the admin. What I would love to know, is how can I

Re: [PHP-DB] Importing CSV data

2003-08-24 Thread John W. Holmes
Chris Payne wrote: Hi there everyone, I have a database with email addresses from people who sign up for a newsletter on my website. Now, I have a utility i've written where they can save the addresses as a CSV file on their computer if they are logged in and the admin. What I would love to

[PHP-DB] Re: I need these 2 files

2003-08-24 Thread David Haines
Thanks for your reply, everyone ! It turns out that when Apache 2 was installed with Redhat 9, the mod auth_mysql library was not installed. I followed everyone's advice and still did not get an error log - oddly enough. Well, in trying to cleanly remove Apache 2, in order to work with 1.3.x,