[PHP-DB] php and local printing

2003-03-03 Thread Rajesh Fowkar
Hello, What is the best way to print on a locally connected printer from php ? For printing we want to give the user three options : 1. Screen 2. Local Printer 3. Server Printer What you guys are using for printing on locally connected printer from php. Thanks in advance. Peace -- Rajesh

[PHP-DB] Help with a query

2003-03-03 Thread Jonathan Villa
I can't figure this query out. I want to pull data from 2 tables but using a primary key from one. Here is what I think it should look like. SELECT item_id, subtotal, quantity from shopping_cart WHERE order_id = (SELECT order_id FROM orders WHERE session_id = session_id()) AND customer_id =

[PHP-DB] Help with MySQL Logic

2003-03-03 Thread Rankin, Randy
Hello All, This may be a bit off topic. If so, my apololgies. A client of mine, a rail car storage company, has asked that I create a PHP/MySQL application in which they will maintain and track rail cars. I am having a bit of trouble however working through one of thier requirements. They need

[PHP-DB] Interbase and PHP locking (was: Interbase locking)

2003-03-03 Thread Koleszr Tibor
Hello everybody, Some days ago I've posted a question about interbase locking. I've solved the problem after searching at interbase developers network and php manuals. Let me drop some line about my experiences... Deadlock is when two (or more) transactions want update or delete a field in the

RE: [PHP-DB] Help with a query

2003-03-03 Thread Jonathan Villa
2) Have you tried echoing the query to see exactly what is being passed to the RDBMS? That is, perhaps session_id() or $customer_id is not giving a valid value. Yes the values are all their. I am using MySQL so I guess I will have to go a different route. I'll have to run 2 queries which is

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread Adam Voigt
Heh. Sounds like a programming class homework project. I would say through the clever use of where clauses's, like: UPDATE position SET posistion = (position-1) WHERE position $idremoved; Would work, assuming $idremoved containted the position of the car removed. On Mon, 2003-03-03

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread 1LT John W. Holmes
A client of mine, a rail car storage company, has asked that I create a PHP/MySQL application in which they will maintain and track rail cars. I am having a bit of trouble however working through one of thier requirements. They need to know in what position the rail car is on each track. For

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread bbonkosk
What about two tables, one would have this: carID carCompany carPayload etc... the second this: position carID This table would be static and if a car was not present in certain conditions they would contain (-1) for the carID. Then finding an empty slot to place an incoming car should be

RE: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread Hutchins, Richard
Coming from a non-programmer... If you were to take the cars' IDs and put them in an array named for the track a specific group of cars is on, that would give you indexes, thus positions, from 0-N depending on how many cars are there. Any time you have to add or delete cars, you should be able

[PHP-DB] Mapping objects to tables: the actual database object

2003-03-03 Thread Alexander Deruwe
Hey everyone, I'm investigating using PHP's OOP functionality instead of the traditional model to implement a project. I've been looking at information about mapping objects to tables, and have mostly found what I needed, but am left with a question I would like to ask here. If this is the

[PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
Does anyone know a reliable way to set an ODBC connection to timeout after a very short time? I've tried set_time_limit but when the query is running PHP does not drop out, I've also tried odbc_setoption on the connection before executing. Basically, I want it to just fail quicker if it is

RE: [PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
Ok I tried this another way but using the ms sql functions along with: ini_set(mssql.timeout,2); ini_set(mssql.connect_timeout,2); ... no change, it still takes about 7-8 seconds to decide it couldn't connect. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday, March 03,

[PHP-DB] GD support in 4.3?

2003-03-03 Thread nate hurto
According to the GD web site http://www.boutell.com/gd/, there is native GD support in v4.3.0. Anyone know how to enable this support? Thanks. Nate. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] GD support in 4.3?

2003-03-03 Thread Rasmus Lerdorf
Wrong mailing list. --with-gd On Mon, 3 Mar 2003, nate hurto wrote: According to the GD web site http://www.boutell.com/gd/, there is native GD support in v4.3.0. Anyone know how to enable this support? Thanks. Nate. -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] How to access a MS Access DB

2003-03-03 Thread Beverly Steiner
Hello, I'm new to this list and saw a past discussion in mid-Feb. about how to access an MS Access DB. I have Apache and PHP installed on my PC running XP Professional. I created a system DSN and got past the odbc_connect but it died in the odbc_prepare statement. Error message: Warning:

RE: [PHP-DB] How to access a MS Access DB

2003-03-03 Thread Jonathan Villa
I believe I posted that thread. Try odbc_exec instead of odbc_prepare Let me know if have more problems --- Jonathan -Original Message- From: Beverly Steiner [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:11 PM To: [EMAIL PROTECTED] Cc: Beverly Steiner Subject: RE:

[PHP-DB] Confusing Date...

2003-03-03 Thread Doug Coning
I have a MySQL column that was set to date. In my PHP page, I have a form and a field called 'Sch_StartDate'. I'm having difficultes understanding how to write to the date column in MySQL. If I send 03/04/02for March 4, 2002, the value that gets stored in the MySQL database is 2003-04-02 for

RE: [PHP-DB] Confusing Date...

2003-03-03 Thread Beverly Steiner
Doug, I know it works if you send the date as -mm-dd. For example yesterday, March 2, 2003 would be 2003-03-02 -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Doug Coning [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:29 PM To: [EMAIL

Re: [PHP-DB] Confusing Date...

2003-03-03 Thread 1LT John W. Holmes
I have a MySQL column that was set to date. In my PHP page, I have a form and a field called 'Sch_StartDate'. I'm having difficultes understanding how to write to the date column in MySQL. If I send 03/04/02for March 4, 2002, the value that gets stored in the MySQL database is

RE: [PHP-DB] Confusing Date...

2003-03-03 Thread Beverly Steiner
Doug, Here's an example of how to format the date: $date = 3/2/2003; $good_date= date(Y-m-d, strtotime($date)); -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Doug Coning [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:38 PM To: [EMAIL

[PHP-DB] Re: Update MD5 field

2003-03-03 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Dani Matielo) writes: my problem is the following: I just imported a csv file to a MySQL database that contains name and email fields. It has about 9k lines on it and I need a new field that orinally didn't exist called code thats suposed to be MD5(name.email) I know

RE: [PHP-DB] Re: Update MD5 field

2003-03-03 Thread John W. Holmes
[snip] If I understand you correctly, this is probably something like what you want to do: ALTER TABLE foo ADD bar VARCHAR(20); (don't know how long the field needs to be). MD5() result is always 32 characters. ---John W. Holmes... PHP Architect - A monthly magazine for PHP