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
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
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
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');
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
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
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
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
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
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 =
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);
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
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
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:
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
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
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
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
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
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
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
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
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
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 =
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
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.
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
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]
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,
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
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,
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
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
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
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
: 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]
$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
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
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
]
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
-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]
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
42 matches
Mail list logo