[PHP-DB] Image compositing

2003-11-18 Thread David Shugarts
This isn't exactly a database question, but I would guess that it pertains to a lot of people's database projects. Has anyone been successful with image compositing of the following general nature? I have a set of many dozens of images which depict various combinations of shapes/styles for prod

[PHP-DB] Possible solution to a simple newbie problem of JOINs

2003-07-01 Thread David Shugarts
My newbie problem is solved and it may help other newbies if I share it. The idea is to take two or more tables and combine their data into one table that you can query. Each of the source tables may only have one or two columns of overlap. You want records (rows) that do not fill in data in unu

FW: [PHP-DB] error checking question

2003-06-26 Thread David Shugarts
-- Forwarded Message > From: David Shugarts <[EMAIL PROTECTED]> > Date: Thu, 26 Jun 2003 18:53:53 -0400 > To: <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] error checking question > > Hi, David-- > > The question you are asking belongs to the topic or co

Re: [PHP-DB] Time input formatting in PHP-12 hour clock

2003-06-22 Thread David Shugarts
With help from the List, I have had some success in answering my question about formatting 12-hr vs. 24-hr time and I thought I would share these two examples of what is working for me. The first example keeps the user from inputting invalid data. In the second, I note that an error yields a "-1" b

[PHP-DB] Two-column display of data, second method

2003-06-19 Thread David Shugarts
When I went looking for a script that would give me a two-column layout that would list my faculty members in two roughly equal columns, alphabetized down the first column and then the second, I did not find such a script. [There was indeed a "two-column" script, but it fed the data row-by-row.] I

Re: [PHP-DB] MySQL editor

2003-06-19 Thread David Shugarts
Thus, the website to find Navicat is http://www.mysqlstudio.com. --Dave Shugarts > > Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are > very > nice packages. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > - Original Message - > From: "B

[PHP-DB] Time input formatting in PHP-12 hour clock

2003-06-13 Thread David Shugarts
Hi, All-- Has anyone already solved the problem of how to get a time input from the user in people time (12-hour clock) and format it to be INSERTed in a mySQL time field? The mySQL time field is 24-hour and of course it can be formatted in the SELECT statement to be displayed as 12-hour for the

Re: [PHP-DB] Re: Now, how about Roman Numerals?

2003-06-11 Thread David Shugarts
Hi, Hugh-- Thanks for both scripts! They are absolutely what I needed for my relatively simple case and they now work great. While I was thrashing around in my search for a conversion script, I found a number of items that were out there in the realm of Javascript and postgresql, etc. They were

Re: [PHP-DB] Re: Now, how about Roman Numerals?

2003-06-11 Thread David Shugarts
Hi, Hugh-- I am very grateful for your help and very impressed with this, but I am not sure that I am able to confirm that it works and I am not competent to fix it if it does not. Perhaps you can tell where I am going wrong. I stored your script as a separate php document, RomanDigit.php. Here i

[PHP-DB] Now, how about Roman Numerals?

2003-06-10 Thread David Shugarts
Second poser today: How to use either a MySQL select statement or PHP to produce a roman numeral, starting from an arabic (INT) number in a database? TIA Dave Shugarts -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Date Formatting in PHP

2003-06-10 Thread David Shugarts
This worked perfectly, is very simple for me to use, and I would never have come upon it in 10,000 years of trying. Thanks! Thanks also to everyone who offered ideas. > $f_date = date('F d, Y',strtotime($db_date)); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: htt

[PHP-DB] Date Formatting in PHP

2003-06-10 Thread David Shugarts
I have a simple need to reformat a variable coming in as $DatePick, brought forward from a MySQL select in the format: 2003-11-18 I need to convert it to the format November 18, 2003 I am trying to avoid having to mess with the MySQL select statement, as the output is being passed t

Re: [PHP-DB] - Shopping cart software

2003-05-30 Thread David Shugarts
A lot of hosted servers are already set up for Miva Merchant. The basic store/shopping cart is very quick to set up. --Dave Shugarts > > Can anyone recommend shopping cart software; does not have to be open > source. I need to set up pretty fast and be able to calculate the > different sales ta