On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering if there is a way to do an UPDATE query where only some of the
text changes.
The column I need to modify is named “toll_free”
What I need to search for is: 800-
I need it to replace it with is
I was wondering this Bastien. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Bastien Koert
Sent: Tuesday, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue
, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering if there is a way to do an UPDATE query where only some of
the text changes.
The column I need
How do you know it failed? What is the mysql_error() returning to you?
I'd also recommend you echo out the query to the browser window before
sending it so you can see exactly what's being sent to the database. That'll
help you troubleshoot SQL problems on your own.
-Original Message-
the select statement but that seamed to make
more errors
Thanks
Aaron
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 3:07 PM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Update Query
How do you know it failed
.
Rich
-Original Message-
From: Aaron Bryer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 3:18 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Update Query
I did that below is the exact excerpt from the source of the
web browser
!--insert into Temp (CompId) SELECT
$query1 = UPDATE news,autori SET
news.titolo='$titolo', news.testo='$testo',
news.data='$data', news.nome='$nome',
autori.mail='$mail' WHERE news.nome =
autori.nome AND id='$id';
You can't do an update across tables the last time I checked. Even if it's
possible in newer versions, using
: Monday, July 14, 2003 2:32 PM
Subject: Re: Re: [PHP-DB] UPDATE query
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$tmp = $_POST['sbcuid'].-.$_POST['system'][$a];
$update = UPDATE accounts SET atime='NOW()' WHERE
\id-sys\='.$tmp.';
echo $update;
$result1 = mysql_query($update, $Prod) or die(mysql_error());
echo mysql_affected_rows();
Try:
$update = UPDATE accounts SET atime=NOW() WHERE id-sys='$tmp';
is it a mysql field type of datetime?
if so, you may want to use this instead
$timestamp=date(Y-m-j H:i:s);
$update = UPDATE accounts SET atime='$timestamp' WHERE id-sys='$tmp';
that puts the current timestamp in mysql format for entry into your table.
Cheers
Jason
-Original Message-
SCOTT,
I am attempting to UPDATE a table and I have having absolutely ZERO
success. Here is the query:
$tmp = $_POST['sbcuid'].-.$_POST['system'][$a];
$update = UPDATE accounts SET atime='NOW()' WHERE
\id-sys\='.$tmp.';
echo $update;
$result1 = mysql_query($update, $Prod) or
. Thanks again for the help. Hopefully
someone will come up with something to help me get this working.
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB
. Holmes'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Update Query Help...
SCOTT,
The list's crystal ball filter is down for maintenance.
Show us the tbl schema and the debug print of $update.
Then we won't be firing blind!
=dn
I understand that the column name does not normally need quotes
I have definitely isolated the problem. If I change the column name
that the match is being performed on from 'id-sys' to 'id_sys' I can
execute
the query without having to worry about quoting the column name and
everything works. I think that I am just going to leave the column name
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
SET prod_desc = prod_desc + more info to tack on to end
but this is a mathematical function which returns 0!
update table set field = concat(field, more info) where id = 1;
find the string functions in the mysql manual...
with kind regards,
Joffrey van Wageningen
--
PHP Database Mailing
Hello Adv. Systems Design,
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 to tack on to end
but this is a
Hi,
The query code seems fine to me - did you try to otput $query to see if all
the variables you are using are OK. May be $order,$stationid or $orderNewsID
is misspeled or is not set properly.
HTH
Dobromir
-Original Message-
From: Jay Paulson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
18 matches
Mail list logo