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 i
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.
>>
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 s
At 14:40 -0700 7/25/02, Mark Middleton wrote:
>Hi there,
>
>I've got a Form I'm building, and would like the drop down boxes to contain
>the values for one of the fields of type "enum" (not from the actual records
>in the DB, but the definition of the enum field in MySQL)
>
>For example: A field
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 = '1
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
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 w
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
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 cont
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
h
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:
>/* 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 = get
At 17:45 -0400 6/7/02, Blaine Dinsmore wrote:
>
>
>Results Test
>
>
>
>
>$server = "mdotlims";
>$user = "httpuser";
>$pass = "pass";
>
>
> $db = @mysql_connect($server,$user,$pass);
> if (!$db) {
> echo( "Unable to connect to the " .
> "d
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 possib
At 18:09 -0600 4/7/02, Gale & Tammy Allen wrote:
>Hello,
> I'm pretty new to MYSQL, but wanted to share this info. With the
>most recent OS X Security update, MYSQL 4.1.2 is installed. I had
>installed the update
MySQL 4.1.2 doesn't exist. I think you mean PHP 4.1.2.
>prior to this security
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 transact
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 unsubsc
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);
>ech
ize it due to having
not tried a sufficient range 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]]
>Sen
conversion.
None 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 1
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
>
nting it? Storing it into the
database? Storing it into the database so 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]
>Subj
oing in to db, stripslashes() coming out :)
>> HTH Joe :)
>>
>>
>> Todd Williamsen <[EMAIL PROTECTED]> wrote in message
>> 002601c1b033$382a4700$f6b2d83f@goofy1">news:002601c1b033$382a4700$f6b2d83f@goofy1...
>> > Paul,
>> >
>&g
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 this is BLUE
>
>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 the notes, then
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 PROTECTE
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 + "mor
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 = mysql_fetch_a
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
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.
On Wed, Dec 19, 2001 at 12:24:02PM -0700, Zach Curtis wrote:
> I have a form for a user to request their forgotten username and password by
> entering their email address. I then process this and use mail() to send
> them their username and password. However, the password is stored in an
> encrypt
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 "" .
On Fri, Dec 07, 2001 at 09:30:47AM +0550, [EMAIL PROTECTED] wrote:
> Can anyone tell me how would i replace the following query with a "="
>
> SELECT * from table_name WHERE name LIKE "%name%";
>
> I want to have the same functionality like "LIKE" but having no LIKE word in
> it.
> Basically i w
At 7:08 PM -0800 12/3/01, chip wrote:
>I have an existing database, created a while back, which I need to add a id
>field to, there isn't one currently. Will simply adding a new auto-increment
>field be okay? Will the existing rows receive id numbers and will they be
>numbered properly? Or will it
At 4:16 PM -0700 4/8/01, Jonathan Underfoot wrote:
>I'm getting an Invalid Query error after inputting the following
>
>
>
>
>$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,
>com_rating=$com_rating, com_body
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]
>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
>seco
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 d
At 2:04 AM +0100 11/9/01, MPropre wrote:
>//.../... 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
At 9:25 AM + 11/8/01, Russ Michell wrote:
>1: Rid any whitespace between '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 for using and registering,
At 5:31 PM -0600 11/7/01, Paul DuBois wrote:
>At 12:23 AM +0100 11/8/01, Christian Sage wrote:
>>Your best bet is probably to hunt around for a freeware utility. There's
>>bound to be something somewhere on the net.
>
>For Windows, a free version of cron is
At 12:23 AM +0100 11/8/01, Christian Sage wrote:
>Hi,
>
>> Harpreet wrote:
>>
>> > I have run JOBs in sql server and was wondering if we have ne thign
>similar
>> > in mysql or use PHP to write a script that would automatically run
>every 10
>> > minutes.
>>
>> Unix has cron: 'man crontab'
>>
le (so that you can, for example, avoid generating a page for 'X'
if no names begin 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,
t;field?
No.
The MySQL 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 addit
very first record in the table.
The first 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 Mail
t;--
>
>Ventsyslav Vassilev
>Comel Soft Multimedia
>Sofia, Bulgaria
>ICQ UIN: 11199819
>e-mail: [EMAIL PROTECTED]
--
Paul DuBois, [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
F
hone\",
>HomePhone = \"$HomePhone\",
>Mobile = \"$Mobile\",
>EmailName = \"$EmailName\",
>Birthday = \"$Birthday\"
>WHERE ContactID = \"$ContactID\"
>";
>
>
>$result = @mysql_query($update_contact_sql, $connection) o
a way to do this?
>|
>| WHERE fieldname LIKE "%$string%"
>|
>| Chris
>|
>
>[EMAIL PROTECTED]
>
>SeaPortNetHosting: Reliable Web Hosting
>Plans from $17.95 www.yourname.com
>http://www.SeaPortNet.com/
>1(209)551-7028
--
Paul DuBois, [EMAIL PROTECTED]
--
PHP Database M
/mysql_errno()
after a failed connection 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-
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, [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]
quot;
>
> Russ Michell
> Anglia Polytechnic University Webteam
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
> t: +44 (0)1223 363271 x 2331
>
> www.theruss.com
>
>#---#
>
>
>--
>
,
because you don't use negative numbers 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-4
you can connect to.
>
>-Adam Lundrigan
> CEO, VPU
> http://www.vpu-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
hree at once.
>Don't you now 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
On Wed, Apr 18, 2001 at 06:55:57PM +0100, Russ Michell wrote:
> Do you mean like:
>
>
> The script this value gets passed to will now have available the
> varible: pswd with a value of the password field..
As will any user who knows about their browser's View Source command. :-)
>
> ???
>
ot;/",
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
>TECHNOLO
n values, then use them 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,
(open db connection)
>> >
>> > $query = "SELECT count(*) FROM Movie";
>> > $result = mysql_query($sql, $dbLink);
>> > $myrow = mysql_result($result);
>> > echo $myrow;
>> >
>>
> > $myrow = mysql_result($result,0,"count(*)");
--
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]
57 matches
Mail list logo
