Re: [PHP-DB] Problem with php and mysql

2003-03-05 Thread 1LT John W. Holmes
One of our customers has written a php application that we are hosting. Basically, there is a province/state table which populates a combo box. When the form containing this combo box is submitted, the information is added into the database. The problem is that when nothing is selected from

Re: [PHP-DB] Problem with php and mysql

2003-03-05 Thread Kevin Demers DSL
Hi, thanks for the help, I just had a look at the db and they are just the default tables, so that must be it. I'll let them know to either change them over or add validation. Again, thanks for your help. On Wed, 5 Mar 2003, 1LT John W. Holmes wrote: Date: Wed, 5 Mar 2003 10:07:04 -0500 From:

RE: [PHP-DB] php and local printing

2003-03-05 Thread Matthew Moldvan
Have you looked into the exec() function? Maybe exec(lpr something or other) may work, though I haven't tried it myself ... Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/

Re: [PHP-DB] date functions (generates parse error)

2003-03-05 Thread David Rice
Sorry, I forgot to add the part at the bottom where I am calling the function = ? function tips($weekstart){ $start = date('Ymd',strtotime($weekstart));   $query = SELECT * FROM Rota WHERE date = $start and date = ($start +

[PHP-DB] ODBC/Paradox

2003-03-05 Thread Fabio Hur
Hi, I am trying access DB Paradox via php/odbc. Only get in W98/PWS or WME/PWS. And without success in Linux/php/odbc and Windows 2K/php/odbc. In W2K's Case, it appears following message: Warning: SQL error: [Microsoft][ODBC DRIVER for Paradox] The table external is not in the waited format.,

RE: [PHP-DB] date functions (generates parse error)

2003-03-05 Thread John W. Holmes
This is very weird. What are you using to create this code? If you remove all of the spaces (?) before $query, the code doesn't give a parse error. It shouldn't give one either way, though, if those are spaces or a tab before your $query = ... line. Even if you remove all of the text and only

Re: [PHP-DB] php and local printing

2003-03-05 Thread Jason Wong
On Wednesday 05 March 2003 13:20, Rajesh Fowkar wrote: On Tue, Mar 04, 2003 at 06:45:54AM -0800, Mark wrote: It dopesn't seem like you got an answer to this. Spot on. Yours is the first reply. Not surprising as this question really does not belong here. To print locally, you'll need to use

[PHP-DB] Column Sort Question

2003-03-05 Thread Jerry
Hi All, This is a newbie question. I am using PHP Version 4.2.3 with register_globals=off. I am trying to creating a simple address book with mysql as the backend. I have a form that passes what the user wants to query from the address book and it returns everything in a table with column

RE: [PHP-DB] Column Sort Question

2003-03-05 Thread Gary . Every
Shouldn't you be using $_GET or, since register_globals are set to off, $order_by should contain FIRSTNAME Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Jerry [mailto:[EMAIL

[PHP-DB] Storing browser stats

2003-03-05 Thread Bruce Levick
Is there a method for storing each users browser stats within a database table. So everytime someone visits the browser info is gathered and stored as a unique row in the 'browser' table in the database. Any advice?? Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[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:

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 is