[PHP] International Addresses and Telephones

2003-12-04 Thread Rankin, Randy
I have a form which captures US addresses ( address, city, state ) and telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I need to expand this to capture non-US info, so I was hoping for some guidance on forms and table structures. I have googled this to death and still have

[PHP] LAMP

2003-08-14 Thread Rankin, Randy
I am setting up a new Redhat Linux 9 box for use as a non-production test server. I prefer to use source files v. RPM's. Anyone know which of the newest versions of Apache, MySQL and PHP will play together nicely. Thanks Randy Rankin

[PHP] PHP, MySQL and Flash

2003-07-09 Thread Rankin, Randy
Does anyone know of any articles on integrating PHP, MySQL and Flash to perform a drag and drop routine for updating a db? Specifically, I have a client who is _INSISTING_ that I integrate a drag and drop feature into his railcar storage application. He wants to be able to view two railcar storage

RE: [PHP] connecting to mysql db

2003-03-25 Thread Rankin, Randy
Place the code in a file ( ie; dbcon.php ) and include that file in any page which may need it using an include statement: include("dbcon.php"); Randy -Original Message- From: Iggy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 7:50 AM To: [EMAIL PROTECTED] Subject: [PHP] connec

RE: [PHP] Limit the amount of returns in a MySQL query

2003-02-07 Thread Rankin, Randy
select * from mailaddresses where id < 10 LIMIT 10; -Original Message- From: Daniel Page [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:53 PM To: [EMAIL PROTECTED] Subject: [PHP] Limit the amount of returns in a MySQL query Hi All, Imagine I have a giant database table tra

[PHP] RE: [PHP-DB] Broken Links 2

2002-10-24 Thread Rankin, Randy
Thanks to everyone for the help. For those interested, I have posted the final code below. It functions beautifully with one exception: the resized image quality is rather poor. I am now reading through the php manual and newsgroups for a solution, but if anyone knows how to handle this it would

RE: [PHP] php/frontpage

2002-10-17 Thread Rankin, Randy
Yes. Frontpage can edit php files ( albeit not very gracfully ). So, if you must ... Open Front Page Select Tools | Options Select the Configure Editors tab and add the .php extension. HTH, Randy -Original Message- From: Shaun [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002

[PHP] Confused

2002-09-23 Thread Rankin, Randy
I have two MySQL tables, groups and users: groups: group_id, group_name users: user_id, user_name, group_id, etc. I would like to produce one table for each group which will list all the members for that particular group. For example: Blue (group_id 1) Tom (group_

[PHP] Date Concat?

2002-09-20 Thread Rankin, Randy
I have two fields of type date in a MySQL table called training: start_date end_date I can format the date using a select, for example SELECT DATE_FORMAT(start_date, '%M %d, %Y') as start_date, DATE_FORMAT(end_date, '%M %d, %Y') as end_date FROM training This