Re: [PHP-DB] pop up windows

2001-01-26 Thread Tom Carter
Hi John, The essential difference between PHP and JavaScript is that PHP is server-side and JavaScript client side. What this means is that when a user requests a PHP page, all the functions, commands etc are run on the server and then sent to the users machine, where as with JS the code is

Re: [PHP-DB] insert into mysql

2001-01-29 Thread Tom Carter
On Thu, 25 Jan 2001, Darryl Friesen wrote: It still didn't work. just says unable to add part $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; Another thought: Are ID and part character data of some sort? If not (i.e. if ID is an int) then remove the single

Re: [PHP-DB] php/mySQL and html select

2001-05-06 Thread Tom Carter
Hi Nick, Assuming you have the rest of the databse interaction, all you need to is store the value of the selection (the store script will recieve a varialbe $state=AK or whatever. To then display the users state do the following //Get the users state from the database //do this however

Re: [PHP-DB] Which state and country?

2001-07-02 Thread Tom Carter
This can give a fair idea of where that person has come from, and if they are international then the country may be obvious. I would be very surprised if you could collect meaningul information about which state they are tho. In my experience, however, lots of hosts turn off reverse DNS

Re: [PHP-DB] who's logged on / how to I find out about other sessions

2001-07-23 Thread Tom Carter
Hi Christian, What most sites do is to keep track of the latest time that a user requested a page (ie when a page is requested store the current time). Then a definitiion of logged-in is made usually this is has requested a page in the last 30 minutes so the query to count the users whose

Re: [PHP-DB] Limit Select Field Characters?

2001-08-01 Thread Tom Carter
left(timestamp,6) - Original Message - From: Jeff Oien [EMAIL PROTECTED] To: PHP-DB [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 11:33 PM Subject: [PHP-DB] Limit Select Field Characters? I have a timestamp field that looks like this 0109011754 but I only want to compare

Re: [PHP-DB] phpMyAdmin: delete table

2001-08-03 Thread Tom Carter
Don't know about phpAdmin, but in straight PHP, after you've connected to database, etc. $sql = drop table tablename; $result = mysql_query( $sql ); Do yuo use PHP anyway? the comment on that was probably it. Otherwise, if you ahve command line access to mysql then the above SQL (DROP

Re: [PHP-DB] Valid resource

2001-08-06 Thread Tom Carter
is $file the result of a fopen? - Original Message - From: Wilmar PĂ©rez [EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Sent: Monday, August 06, 2001 5:31 PM Subject: [PHP-DB] Valid resource Hi guys. I'm getting the following error and have no idea what the hell it means:

Re: [PHP-DB] Include

2001-08-19 Thread Tom Carter
Yes that is correct. On a security point of view therer is something extra you can do.. when using require you can require files that are outside the web tree...by this I mean are not accessible thru the internet. So if you site was in /home/web then you could setup a directory, say

Re: [PHP-DB] implementing php with IBM branded apache

2001-09-05 Thread Tom Carter
What OS are you running on it? I've used php on an rs6000 while at IBM. worked fine, I didn't install it tho, but I don't think they had any problems. HTH, Tom - Original Message - From: Marc Grober [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 05,

Re: [PHP-DB] SQL combine to summations queries?

2001-09-06 Thread Tom Carter
Hello, I don't understand the following, who can help? I have got two queries: SELECT SUM(fielda) FROM table1 and SELECT SUM(fieldb) FROM table2 I thought this would be the same as: SELECT SUM(fielda.table1),SUM(fieldb.table2) FROM table1, table2. But, itn't, why? I think you

Re: [PHP-DB] Backups, best practices

2001-09-07 Thread Tom Carter
you can get command line zip/compression packages for windows, although for *some* reason, as far as i know, not a command line version of winzip - the big one! err.. please correct me if I'm wrong, but isn't pkzip exactly that? or more exactly, winzip is a windows interface to it? it

Re: [PHP-DB] USA Attacks

2001-09-12 Thread Tom Carter
now isn't the time for these kind of discussions, and nothing can excuse the death of all those innocent people. America as a nation is far from innocent however, I agree with you on that Lars. My sincerest condolances to all those involved. Let's just hope that the crazy man bush doesn't do

Re: [PHP-DB] db's war

2001-09-18 Thread Tom Carter
Having worked in IBM and in Open Source community I feel I've know both systems very well. MySQL is different to the big boys of DB2 and Oracle. They are designed for enterprise level, and to handle a complexity and quantity of data which mysql just isn't there. The SQL used in mysql is vastly