Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Paul DuBois
At 11:59 -0500 9/11/02, Rob Day wrote: Hi all, I have a table in MySQL with the following field: 'time_date' timestamp(14) NOT NULL When a record is inserted into the table, NULL is inserted into the time_date field giving me a normal timestamp with the time of the INSERT. That much is

Re: [PHP-DB] transactions and persitent connections

2002-09-01 Thread Paul DuBois
At 12:52 +0900 9/1/02, Jean-Christian Imbeault wrote: Paul Dubois wrote: I am worried that if I use persistent connections it might be possible for more than one PHP script to be inside the same transaction at the same time. Not at the *same* time, because although a persistent connect

Re: [PHP-DB] transactions and persitent connections

2002-08-31 Thread Paul DuBois
At 17:46 +0900 8/31/02, Jean-Christian Imbeault wrote: I'm a little confused/worried about database transactions, persistent connections and PHP. I am worried that if I use persistent connections it might be possible for more than one PHP script to be inside the same transaction at the same

Re: [PHP-DB] delete multiple records with one query

2002-07-01 Thread Paul DuBois
At 22:37 -0400 7/1/02, Matt Nigh wrote: hi, i'm trying to delete multiple records at once from a mysql db and can't seem to figure out how to do so. here's the code i've been trying to troubleshoot with: $result_insert = mysql_query(delete from $mysql_table where id = '8' AND where id = '18');

Re: [PHP-DB] Excel to MySQL??

2002-06-29 Thread Paul DuBois
At 15:21 -0600 6/29/02, Chase wrote: Does anyone know of a way that I can export an Excel spreadsheet to a file that I can import to MySQL? I found a program that will do this for Access, but I would rather leave Access out of this if possible. Thanks!! Chase Does it have to be written in

[PHP-DB] Re: XML

2002-06-27 Thread Paul DuBois
At 21:33 -0400 6/27/02, MikeParton wrote: Would be interesting to hear from Peter on why he feels the urge to store XML docs in MySQL (or, better said: I would be interested in hearing what he is trying to accomplish and why he...or someone...feels XML stored in a relational database is the way

Re: [PHP-DB] MySql password

2002-06-24 Thread Paul DuBois
At 14:58 -0400 6/24/02, Page Works Web Solutions wrote: Hi all, I have a Cobalt Raq 4 running Linux. I've installed the .pkg file RaQ3-RaQ4-MySQL-3.23.37-1.pkg I can telnet into the server and I type mysql, now I see that I'm in MySql, but when I type bin/mysqladmin -password and put a

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Paul DuBois
At 8:55 -0400 6/21/02, Steve Bradwell wrote: So should I be using Innodb tables or BDB tables? You have to be using *some* kind of transaction-safe tables (InnoDB and BDB qualify). If you use a table type like MyISAM, then all statements are committed as they execute, and use of a transaction

Re: [PHP-DB] how expensive is mysql_connect in performance

2002-06-21 Thread Paul DuBois
At 22:39 -0400 6/21/02, Michael Zornek wrote: I'm just getting into some stuff where I seem to be making a lot of mysql_connect and mysql_close calls. I wonder, how taxing is this on the server? Not very. MySQL's connection-establishment sequence is pretty efficient. mysql_pconnect() by

Re: [PHP-DB] resource id#2 - ????

2002-06-12 Thread Paul DuBois
At 11:42 -0600 6/12/02, Jas wrote: Not sure how to over come this, the result of a database query keeps giving me this: ?php /* Get Ip address, where they came from, and stamp the time */ if (getenv(HTTP_X_FORWARDED_FOR)){ $ipaddy = getenv(HTTP_X_FORWARDED_FOR); } else { $ipaddy =

Re: [PHP-DB] Anyone know why this won't return results?

2002-06-07 Thread Paul DuBois
At 17:45 -0400 6/7/02, Blaine Dinsmore wrote: html head titleResults Test/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php $server = mdotlims; $user = httpuser; $pass = pass; $db = mysql_connect($server,$user,$pass);

Re: [PHP-DB] translating password($var) back to text

2002-05-03 Thread Paul DuBois
At 15:47 -0700 5/3/02, John Hughes wrote: I am setting up a PHP-mySQL login script. One key feature I need is the ability automatically to e-mail people their password when they forget it. Obviously, I can store the password without using password() and retrieve it at any time. Is it possible to

Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Paul DuBois
At 2:00 +0800 2/10/02, Jason Wong wrote: On Sunday 10 February 2002 00:21, Miles Thompson wrote: Unless there has been a very recent development, MySQL doesn't support transactions. Use PostgreSQL, DB, etc. The v4 series of MySQL does support transactions. MySQL has supported transactions

Re: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
D] wrote in message 002601c1b033$382a4700$f6b2d83f@goofy1">news:002601c1b033$382a4700$f6b2d83f@goofy1... Paul, It is being inserted into a database -Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 5:41 PM To:

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
that you can print it as a Web page later? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:40 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: Re: [PHP-DB] addslashes() At 9:14 -0600 2/8/02, Todd Williamsen wrote: So if I: Going

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
At 10:06 -0600 2/8/02, Todd Williamsen wrote: Paul, Sorry for the confusion... Ok.. I have an application where it organizes candidates for positions for HR. There is a Notes field where they can update actions with the potential candidate. Now this can be when this person has been

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
of these are particularly attractive. It's an ugly problem; I suspect it has no pretty solution. I don't need the problem re-explained to me 8) -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:21 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
of values. If the one that works continues to work and the one that fails continues to fail, then clear they're not really *exactly* the same. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:34 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject

Re: [PHP-DB] Simple Display

2002-02-08 Thread Paul DuBois
At 7:46 +1300 2/9/02, Barry Rumsey wrote: I am trying to do a simple fetch of the lastest add name. I have the following code : $query = SELECT name FROM name ORDER BY name DESC LIMIT 1; $latename = mysql_query($query) or die(Select Failed!); $latename = mysql_fetch_array($latename); echo

Re: [PHP-DB] Round a float to the next highest value despite thevalue after the point

2002-02-08 Thread Paul DuBois
At 15:31 -0400 2/8/02, Renaldo De Silva wrote: how can I round a float to the next highest value reguardless of the value after the point, does anyone have any suggestion, any help would be apreciated. Define next highest value. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] addslashes()

2002-02-07 Thread Paul DuBois
At 16:54 -0600 2/7/02, Todd Williamsen wrote: Ok.. i tried it out... and it almost works like I want it... weird though 1. when I put in pfont color=bluethis is BLUE/p/font it prints it in like a bright green. but if i use the RGB # then its fine. weird 2. if there is an apostrophe in

Re: [PHP-DB] request and response objects?

2002-01-30 Thread Paul DuBois
At 12:30 -0600 1/30/02, Matthew Crouch wrote: basically a yes or no question my brother wants me to ask: Does PHP support these objects? If not, Can they be faked? What, like in Java servlets/JSP pages? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] UPDATE query to add to a field

2002-01-28 Thread Paul DuBois
At 9:06 -0800 1/28/02, Adv. Systems Design wrote: hello all: I need to be able to update a field in MySQL, the catch is that I have to add on to text that is already there and I have to be able to do it within MySQL (phpMyAdmin). My first idea was to do: SET prod_desc = prod_desc + more info

[PHP-DB] Re: [PHP] PHP and MYSQL Security`

2002-01-27 Thread Paul DuBois
At 16:59 -0800 1/27/02, Fred wrote: If this file has a .php extension remote users will not have access to the variables because the file is parsed by php and they never see the actual file contents when requesting the document via the web. If you are concerned with users on localhost having

Re: [PHP-DB] Sum Columns

2002-01-25 Thread Paul DuBois
At 23:19 -0600 1/25/02, [EMAIL PROTECTED] wrote: Hello, I've been experimenting with adding decimal columns. From the mysql docs I got this SELECT sum(value) FROM pets; So I did this $result = mysql_query(SELECT sum(value) FROM pets,$db); $myrow =

Re: [PHP-DB] distinct - how to do

2002-01-19 Thread Paul DuBois
At 2:28 +1300 1/20/02, Barry Rumsey wrote: I have the following query: $query = SELECT * FROM xp_topics, xp_stories WHERE xp_topics.topicid = xp_stories.topicid AND xp_topics.artistname='Faith Hill' ORDER BY topictext DESC LIMIT 0,20; It returns the lot but a lot of doubles. I want to put a

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Paul DuBois
On Thu, Dec 20, 2001 at 11:40:14AM -0500, SpyProductions Support Team wrote: I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. On this question, you'd be better off just reading an HTML reference. It doesn't matter what the value of a checkbox is.

Re: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Paul DuBois
At 10:46 -0800 12/14/01, Richard S. Crawford wrote: At the risk of sounding like a browser-snob... The quotes probably don't matter in IE, but that's primarily IE allows (and, in my opinion, encourages) bad coding practices. Your echo command really ought to look like this: echo option

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-11-23 Thread Paul DuBois
Has this thread got anything at all to do with PHP? -- 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] PHP MySql

2001-11-23 Thread Paul DuBois
At 4:16 PM -0700 4/8/01, Jonathan Underfoot wrote: I'm getting an Invalid Query error after inputting the following connect to Server select DB $sql_query = UPDATE commentary SET com_num=$com_num, com_by=$com_by, com_band=$com_band, com_title=$com_title, com_release=$com_release,

Re: [PHP-DB] Combination of SQL statements invalid in MySQL?

2001-11-22 Thread Paul DuBois
At 4:08 PM +0100 11/22/01, Andy wrote: Hi there, I am trying to do a combination of SQL statements like described in a SQL b├Ťok. Is it possible, that mysql does not allow this syntax? According to the MySQL Reference Manual, subselects are not supported. Thanx Andy Error: Occured during

Re: [PHP-DB] Result is not empty

2001-11-22 Thread Paul DuBois
Take out the while statement-- i.e. simply use: $row = mysql_fetch_array($result); the way you have things constructed now, the while statement evaluates true on the first iteration and $row equals the result row from the query. Because the while returned true, it is evaluated a second time,

Re: [PHP-DB] Session Broken

2001-11-08 Thread Paul DuBois
At 9:25 AM + 11/8/01, Russ Michell wrote: 1: Rid any whitespace between '?php' and 'session_start()' 2: You need to populate the variable you wish to use as a session variable before registering it Is 2 actually true? The sessions chapter in the PHP manual doesn't seem to specify any order

Re: [PHP-DB] Not a valid MySQL result resource

2001-11-08 Thread Paul DuBois
At 2:04 AM +0100 11/9/01, MPropre wrote: ?php //.../... first part of the code is to connect to the right DB on a MySQL server. It works fine //This code to show the query. It runs well under MySQL and gives 1 result : $query=SELECT Login, Password FROM `user` WHERE user.login=''$login'' and

Re: [PHP-DB] MySQL alphabetical listing

2001-09-18 Thread Paul DuBois
with that letter), do this: SELECT DISTINCT LEFT(last_name,1) AS letter FROM tbl_name ORDER BY letter -- Paul DuBois, [EMAIL PROTECTED] -- 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

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul DuBois
record in the table, or the first record in the result set? Why is this and how can I get round it? Hard to say without seeing the surrounding context. Thanks. Jamie Saunders -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-DB] auto fill field with value from another

2001-08-07 Thread Paul DuBois
manual says default values must be constants: http://www.mysql.com/doc/C/R/CREATE_TABLE.html thanks, bill hollett -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] Grouping functions inside WHERE clause - may or not

2001-08-04 Thread Paul DuBois
: 11199819 e-mail: [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] -- 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] WHERE field = str

2001-07-25 Thread Paul DuBois
$17.95 www.yourname.com http://www.SeaPortNet.com/ 1(209)551-7028 -- Paul DuBois, [EMAIL PROTECTED] -- 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

[PHP-DB] mysql_[p]connect() and mysql_error()/mysql_errno()

2001-07-23 Thread Paul DuBois
is with *no* argument, because when a failure occurs $conn_id won't have any reasonable value and shouldn't be passed to those functions. -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

[PHP-DB] PEAR DB, prepare(), and placeholders

2001-06-30 Thread Paul DuBois
like $stmt is being munged? Question 2: How to you bind a NULL value to a placeholder? In DBI, you use undef to stick a NULL into a query; in PEAR DB, I tried both null and an unset variable, with the result that an empty string was placed into the query string in both cases. -- Paul DuBois

Re: [PHP-DB] MySQL Error???

2001-06-29 Thread Paul DuBois
in the column. Something like this: ALTER TABLE tbl_name MODIFY col_name INT UNSIGNED NOT NULL Thanks, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http

Re: [PHP-DB] MySQL connection: Change on syntaxis?

2001-06-29 Thread Paul DuBois
] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

Re: [PHP-DB] Is MySQL in 4.0.6?

2001-06-26 Thread Paul DuBois
-virtual.com/ ICQ # 73617446 [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] -- 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] Apache+PHP+MySQL installation at once - HOW?

2001-05-04 Thread Paul DuBois
where I can find it? Thanks Vojtech http://www.nusphere.com/ -- 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] -- Paul DuBois, [EMAIL

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Paul DuBois
RIGHT(d,4)) FROM t; -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK.." -- Paul DuBois, [EMAIL PROTECTED] -- P

Re: [PHP-DB] ENUM type

2001-01-15 Thread Paul DuBois
to construct a set of radio buttons or a popup menu in a web form. That way your form always presents exactly the legal options for the column. You can also use the column definition when validating submitted forms to make sure the value submitted is legal. -- Paul DuBois, [EMAIL PROTECTED] -- PHP