Re: [PHP-DB] Damn Cookie

2001-01-26 Thread Tom Carter
what is probably happening is that your file, page.html is setting the variable user_name to a value at some point in the script. The URL you gave effectively is the same as making the first two lines of the file read $user_name='name'; $password='password'; Hence if a subsquent line in the scrip

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 effec

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

Re: [PHP-DB] Migrating MySQL Table Data

2001-02-04 Thread Tom Carter
The CREATE TABLE .. FROM ... SQL will do what you require, but I don't think this is included in MySQL (one to check)...however if performance is becoming an issue, ,then you may want to consider migrating to a different DBMS (mySQL is not so good at handling large record sets, and has a much cut-

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

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 approp

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 lookups...

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 who

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 comp

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 (DRO

Re: [PHP-DB] #usr showing up

2001-08-04 Thread Tom Carter
why is that line in there at all? The fact that the file has a .php extension and is going thru apache is enough... delete it and php should work fine. - Original Message - From: "Vipin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 02, 2001 12:48 PM Subject: [PHP-DB]

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 /home/web_v

[PHP-DB] phpMyAdmin (well mySQL) and listing DB's

2001-08-19 Thread Tom Carter
s all the dbs. Anyone have any advice? TIA, Tom Tom Carter Web Architect roundcorners ltd. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

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, Septem

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

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 cert

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 any

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