[PHP-DB] Am I missing something? Why doesn't php have a 'date' variable type?

2004-05-19 Thread Ross Honniball
Hello. I've been using php for about 5 months now. One of the first things I noticed it was missing was a standard in-built manner of handling dates. I assumed that, being inexperienced, I was probably missing something and in time all would become clear. It's a while later now and I still thin

[PHP-DB] sybase_set_message_handler not defined.

2004-05-19 Thread John Mund
Hello, I have set up php 4.3.6 with sybase support (running on apache 2.0.49 on solaris 8). I am able to connect to my sybase 11.9.2 server, log on and do queries. However when I try to set up a message handler with the sybase_set_message_handler() function I get the following error messag

[PHP-DB] MySQLi set_ssl method arguments

2004-05-19 Thread TJ Root
I was wondering if anyone could shed some light on what an appropriate set of arguments would look like for the ssl_set method on a MySQLi object. I am trying to connect to an SSL-enabled MySQL server without much luck. I am confident that I am passing the certificate paths correctly, but once I

[PHP-DB] MySQL to DBF

2004-05-19 Thread Emilio Alvarado
I need to make a dbf file with some mysql records The creation of the dbf with the dbase_create works FINE Now I need to fill the dbf, I have a mysql database with some of the data, I have the apropiate SQL to view that data but I need to make an array with that data and some "", 0. How can i do th

[PHP-DB] Re: MySQL to DBF

2004-05-19 Thread Torsten Roehr
"Emilio Alvarado" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I need to make a dbf file with some mysql records > The creation of the dbf with the dbase_create works FINE > Now I need to fill the dbf, I have a mysql database with some of the data, I > have the apropiate SQL to vie

[PHP-DB] Re: Subject: SQL Statement

2004-05-19 Thread Neil Smith [MVP, Digital media]
You're missing a closing quote at the end of the line, following the group by `calls`, it should end as , `calls`"; Since you are passing a string to PHP to hand off to the DB engine. Also, PHP function mysql_error($connection) is useful as this will return any errors generated by your database

[PHP-DB] PHP / MySQL Developer

2004-05-19 Thread Kenny
Hi All, This is just a request to all you programmers out there, I have been programming using PHP/MySql for approx 5 years now. I was involved in a motor car accident last year October and I broke my back in 3 places, this has left me paralyzed from the waist down but luckily my I can still co

[PHP-DB] PHP based telco billing/accounting software

2004-05-19 Thread Aaron Wolski
[OT] Hi all, I have a client who needs to implement telephone billing/account software for their clients. They're looking to have us develop a customize solution for them. However, I thought I'd check here and see if anyone knows of software (opensource or paid) that they could recommend me chec

[PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread Justin Patrin
Matt Perry wrote: I use the following php mail function in an online applicaiton program: mail($email, "application submitted", $message, "From: [EMAIL PROTECTED]"); This function does not always work when I modify $message. I have checked for null values for $message already but this does not

[PHP-DB] Re: Slow php-mysql

2004-05-19 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi Dez, I think I got exactly the same problem. I have W2003 Advanced Server running with IIS 6 and PHP 4.3.4. On a nother machine I have MySQL 4.1.0-alpha-nt. Now any connection from any other host in the network (e.g. running phpMyAdmin) to the DB works just fine (hosts running IIS or Apache). B

[PHP-DB] Re: search engine query

2004-05-19 Thread Torsten Roehr
"Bobo Wieland" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi! I'm new to this list. I usually try to get my answers at the php-win > mailing list... > > But since this is a mysql question I thought it would be better to ask i t > here; > > How do I get the best result from a simp

Re: [PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread J-Michael Roberts
This is something I've been dealing with for a little too long. AOL has a big list of methods they use to block what they think are spam. Some of these things are: - Reverse DNS Lookups: If you don't have an entry, your mail is dumped - Mail Formatting: If the format of your message is not RFC C

RE: [PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread Daniel . Brunner
Hello!! That's not always true. I just sent mail using php to my AOL account, and it worked. The smtp mail server doesn't have a reverse dns lookup. His problem might be that the SMTP server he is using my be on the black list. http://www.ordb.org/ This will cause a ton of problems. It to

[PHP-DB] Re: SQLite and PHP4

2004-05-19 Thread Eli White
Ok, I've solved my own problem ... leaving me with a question for anyone who is interested in answering it. It seems that the default .ini file changed location on me from PHP 4.3.4 to PHP 4.3.6 ... from the /php directory, to the /php/lib directory Any reason this change occurred? And that it

RE: [PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread Ryan Jameson (USA)
I'm quite sure it's not a problem with the mail function. It's probably the reverse dns configuration on your SMTP/sendmail server. AOL & Verizon have been two real sticklers for that. If you know the IP address that your server is sending the email from you can use this: http://www.dnsstuff.com/

[PHP-DB] search engine query

2004-05-19 Thread Bobo Wieland
Hi! I'm new to this list. I usually try to get my answers at the php-win mailing list... But since this is a mysql question I thought it would be better to ask i t here; How do I get the best result from a simple search (just one input box and a search button) from a mysql db with two tables cont

Re: [PHP-DB] explode() and a database call...?

2004-05-19 Thread Tristan . Pretty
Already doing that, and it works: (I have checked the overall value of > TPrsc> $row[bands] and it does contain "1, 4, 12, 32") Really bugging me now (no pun intended)! Any other ideas? It's gotta be simple..! "Torsten Roehr" <[EMAIL PROTECTED]> 18/05/2004 18:24 To [EMAIL PROTECTED] cc Sub