On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
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 1-800-
> - BUT I don’t
On 14 March 2011 15:42, Gary wrote:
> I have a table in a mysql db that has 3 columns that I want to insert
> (update) data if the row&column is empty (IS NULL). However I want to start
> at the first column, if this column is not null, then move to insert the
> data into column 2, if that is emp
I have a table in a mysql db that has 3 columns that I want to insert
(update) data if the row&column is empty (IS NULL). However I want to start
at the first column, if this column is not null, then move to insert the
data into column 2, if that is empty, then insert data into column 3.
I hav
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, Mar 8, 2011 at 11:16 AM, Ron Piggott
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
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
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
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 1-800-
> - BUT I don’t
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 1-800-
- BUT I don’t want to change instances of 1-800-
- I need to leave the rest of
Hi all,
I am new to php, I am just learning it at the moment. I hope you can help me
with my code.
Thanks in advance!
I want the page to allow users to edit or delete an existing uploaded file.
But after testing the script in the browser the delete option is working 10
out 0f 10;
but the
[ please always send to the mailing list ]
Emiliano Boragina wrote:
Hi Chris, thanks for your ask...
This doubt was beacause I have two tables... one with categories (category
id and category name), and the other with products (product id, product
name, category id which the prod belong). The cl
Emiliano Boragina wrote:
Hello everyone…
I dont know how to update a lot of registers on one table.
I have two tables: Students and Signatures
STUDENTS has got: id / name / signature
SIGNATURES has got: id / name / classroom
I want to use words and not numbers to write the si
Hello everyone
I dont know how to update a lot of registers on one table.
I have two tables: Students and Signatures
STUDENTS has got: id / name / signature
SIGNATURES has got: id / name / classroom
I want to use words and not numbers to write the signature on the STUDENTS
table.
:19 PM
> > To: php-db@lists.php.net
> > Subject: [PHP-DB] UPDATE instead of INSERT INTO
> >
> > I made an application which lets users rate web site content.
> > At the heart of the application is this mySQL query:
> >
> > INSERT INTO `ratings` ( `refere
Thanks
- Original Message -
From: "Waynn Lue"
To: "Ron Piggott" ;
Sent: Saturday, September 05, 2009 4:45 PM
Subject: Re: [PHP-DB] UPDATE instead of INSERT INTO
INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for.
On 9/5/09, Ron Piggott wro
INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for.
On 9/5/09, Ron Piggott wrote:
> I made an application which lets users rate web site content. At the heart
> of the application is this mySQL query:
>
> INSERT INTO `ratings` ( `reference` , `content_type` , `content_reference` ,
> `
I made an application which lets users rate web site content. At the heart of
the application is this mySQL query:
INSERT INTO `ratings` ( `reference` , `content_type` , `content_reference` ,
`language` , `ip_address` , `rating_timestamp` , `rating` ) VALUES ( NULL ,
'$content_type','$content_
-you-wanna-call-them are used to be
explicit with a name.
-TG
- Original Message -
From: "Gary Wardell" <[EMAIL PROTECTED]>
To:
Date: Thu, 13 Dec 2007 19:33:57 -0500
Subject: RE: [PHP-DB] UPDATE syntax
> Hi,
>
> I'm a beginner at PHP and MySql but a long
iod.
Gary
> -Original Message-
> From: Ron Piggott [mailto:[EMAIL PROTECTED]
> Sent: Thu, December 13, 2007 7:20 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] UPDATE syntax
>
>
> Can anyone see something wrong with this syntax?
>
> UPDATE `advertisement
Can anyone see something wrong with this syntax?
UPDATE `advertisements` INNER JOIN `advertisements_rate_plans` ON
`advertisements.rate_plan` = `advertisements_rate_plans.reference` SET
`advertisements.displayed` = 0 WHERE `advertisements.start_date` <=
'2007-12-13' AND `advertisements.end_date` >
Ron Piggott wrote:
Is it possible to do an UPDATE with an INNER JOIN --- I want the WHERE
to use 2 tables in selecting which rows are going to be updated in
table1.
http://dev.mysql.com/doc/refman/5.0/en/update.html
You can also perform UPDATE operations covering multiple tables.
However, you
Is it possible to do an UPDATE with an INNER JOIN --- I want the WHERE
to use 2 tables in selecting which rows are going to be updated in
table1.
Could you provide me with a simple example if this is possible using the
following variables:
table1 table2 table1.field1 table1.field2 table2.field1
'show table status' will return a record set that you can parse to get the
last update time
bastien
From: Pete Holsberg <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Update time/date stamp
Date: Wed, 2 Feb 2005 15:00:34 -0500 (EST)
On Wed, 2 Feb 2005, Bas
g with format, number of rows, row length and row size.
So the last-updated information is in A table but not the
table called directory.
Sorry for the confusion.
>
> >From: Pete Holsberg <[EMAIL PROTECTED]>
> >To: php-db@lists.php.net
> >Subject: RE: [PHP-DB] Update t
so select max(last_updated)
bastien
From: Pete Holsberg <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Update time/date stamp
Date: Wed, 2 Feb 2005 14:06:35 -0500 (EST)
On Wed, 2 Feb 2005, Bastien Koert wrote:
> is there a timestamp or data time field in the table? If
On Wed, 2 Feb 2005, Bastien Koert wrote:
> is there a timestamp or data time field in the table? If
> so just quuery that field for the max value
>
> select max(dateTimeFieldName) from TableName
No there isn't.
When I view the table with phpMyAdmin, it displays a table
that includes time/date s
is there a timestamp or data time field in the table? If so just quuery that
field for the max value
select max(dateTimeFieldName) from TableName
bastien
From: Pete Holsberg <[EMAIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: RE: [PHP-DB] Upda
On Wed, 2 Feb 2005, Bastien Koert wrote:
> any particular table? or just the db in general?
It has just one table.
---
Pete Holsberg
Columbus, NJ
---
"When the people are afraid of the government, that's
tyranny. But when the government is afraid of the people,
that's liberty." -- Thomas Jeffer
any particular table? or just the db in general?
bastien
From: Pete Holsberg <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Update time/date stamp
Date: Wed, 2 Feb 2005 10:56:08 -0500 (EST)
I would like to print the date and time my database was
last updated but don'
I would like to print the date and time my database was
last updated but don't know the query for that. Ilooked at
several websites that list MySQL variables but didn't find
any that seemed to be what I want.
Can anyone help?
Thanks.
---
Pete Holsberg
Columbus, NJ
---
"When the people are afrai
Stumbling across some posts online, I noticed [some of] my messages were
being sent as evil ugly HTML - so I'm going to do my best to post from
Thunderbird for the list. Gotta keep OE configured as is for all the
lovely meeting scheduling.
Stuart Felenstein wrote:
--- Jochem Maas <[EMAIL PROTE
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> > if (count($inds) > 0 AND is_array($inds)) {
> > $ind = "'".implode("','", $inds)."'";
> > }
>
> looks like you want to do a select statement with
> $ind in the form of
> "SELECT * FROM yourtable WHERE yourfield IN ($inds)"
>
Adding the IN cla
Stuart Felenstein wrote:
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
don't be sorry, be pro-active and rewrite it until
its idiot proof. its
in your own best interest - the clearer you state
your problem the
greater the chance someone will/can help you.
I don't know about anyone else, but I hav
Norland, Martin wrote:
-Original Message-
From: Jochem Maas [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 11:59 AM
Subject: Re: [PHP-DB] Update multiple records
...
That's what I get for troubleshooting before lunch!
My apologies to the list and to anyone unfortunate enou
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> don't be sorry, be pro-active and rewrite it until
> its idiot proof. its
> in your own best interest - the clearer you state
> your problem the
> greater the chance someone will/can help you.
>
Well I've started with a clean slate. Meaning I
ditc
Stuart Felenstein wrote:
Having a problem here with updating multiple records
in a table.
as Martin Norland (a heavy hitter on this list AFAIKT) already stated
you don't seem to be at the stage of actually doing an update, no big
deal - only you are doing yourself an injustice by given a misle
> -Original Message-
> From: Jochem Maas [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 11:59 AM
> Subject: Re: [PHP-DB] Update multiple records
[snip]
> > This line in particular clearly warrants attention. Cookie to
whoever
> > guesses what&
Norland, Martin wrote:
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 10:40 AM
Subject: [PHP-DB] Update multiple records
Having a problem here with updating multiple records in a table.
[snip]
Lets see - where to begin...
SELECT
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 10:40 AM
> Subject: [PHP-DB] Update multiple records
>
> Having a problem here with updating multiple records in a table.
[snip]
Lets see - where to begin..
Having a problem here with updating multiple records
in a table.
First the table is like such:
+-+--+
| RecordID [int] | IndID [int] |
+-+--+
There is no auto inc column. User has a record number
and then can have multiple rows in tabl
--- Andrew Kreps <[EMAIL PROTECTED]> wrote:
> On Thu, 6 Jan 2005 07:28:32 -0800 (PST), Stuart
> Felenstein
> <[EMAIL PROTECTED]> wrote:
> >
> > The problem I'm having a hard time getting my
> hands
> > around are those areas where they can have
> multiple
> > entries.
> >
> > One of the tables
On Thu, 6 Jan 2005 07:28:32 -0800 (PST), Stuart Felenstein
<[EMAIL PROTECTED]> wrote:
>
> The problem I'm having a hard time getting my hands
> around are those areas where they can have multiple
> entries.
>
> One of the tables allows for a user to enter up to 5
> choices. The table would look l
I am working on "update" areas for my end users. This
is where they can go in and update and / or edit
information in their profile.
The problem I'm having a hard time getting my hands
around are those areas where they can have multiple
entries.
One of the tables allows for a user to enter up
Hi all,
I made a toy database. Two tables are "students" (a collection of student
info) and "message" (private messages I want individual students to read).
The "message" table is indexed by a student's social security number.
student
last, first, ssn, address, city, state, zip, email
messag
From: "Khalid Judeh" <[EMAIL PROTECTED]>
I have a script that make changes to the database in more than
one sql statement, as i need to update more than one table at
the same time, I want to know if there is a method where all
of those changes are committed, or rolled back if some error
occured(let
On Wed, 25 Aug 2004 22:08:03 -0700 (PDT), Khalid Judeh
<[EMAIL PROTECTED]> wrote:
> Hello,
> I have a script that make changes to the database in more than one sql statement, as
> i need to update more than one table at the same time, I want to know if there is a
> method where all of those chang
Hello,
I have a script that make changes to the database in more than one sql statement, as i
need to update more than one table at the same time, I want to know if there is a
method where all of those changes are committed, or rolled back if some error
occured(lets say in the last sql statement
sold"];
print "";
print $row["income_in"];
print "";
print $row["income_out"];
print "\n";
}
print "\n";
?>
Please enter closing details;
Closed Date:
Option Close
Justin,
Is the code you posted all of the code or just a small snippet? You
don't appear to be setting $C or $G. Could you post a larger code dump
please?
-Sam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
: Thursday, 24 June 2004 2:55 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Update data problem
$E= "$C*$G";
Should be:
$E = $C * $G;
Never use quotation marks when doing math. Quotation marks are used
for strings. Hope that helps.
--
PHP Database Mailing List (http://www.php.net/)
To u
$E= "$C*$G";
Should be:
$E = $C * $G;
Never use quotation marks when doing math. Quotation marks are used
for strings. Hope that helps.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi there, I hoped someone might be able to tell me why this is not
working.
I have a form that updates the table 'media' with the 3 values below,
that and some other variables are the only data in the table. That works
nicely.
I then want to update one of the other columns ($E) based on the
hwee
- Original Message -
From: "Ricardo Lopes" <[EMAIL PROTECTED]>
To: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
Cc: "PHP DB" <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 5:41 PM
Subject: Re: [PHP-DB] Update Statement
> you could
PROTECTED]>
To: "DBList" <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 2:14 AM
Subject: [PHP-DB] Update Statement
hi all,
I would like to do the following:
update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no =
Table2.no
however, i found that multip
hi all,
I would like to do the following:
update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no
however, i found that multiple updates can only work for MySQL version 4.0.4 but mine
is 3.23.54... can anyone enlighten me on how I can achieve the same results with th
x27;FWO', Grp='IIM'
WHERE ZNum='112763'";
- Paul
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 5:17 PM
To: Kermit Short; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Update problems
you need quote
you need quotes around the name
FirstName="$fname"
otherwise it takes the value of $fname to be aa field name
HTH
Peter
-Original Message-
From: Kermit Short [mailto:[EMAIL PROTECTED]
Sent: 20 January 2004 22:28
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Update problems
I'm trying to update a record in a MSSQL database. When I execute the
following code on an IIS5 webserver, I get an error message that says:
PHP Warning: odbc_do(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid column name 'Tom'., SQL state S0022 in SQLExecDirect in
E:\web\php
be a push in the right direction (I
hope).
Hope this helps.
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 th
al 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? What is the mysql_error() returning to you?
I'd also recommend you
--Original Message-
> From: Aaron Bryer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 29, 2003 3:02 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Update Query
>
>
>
> Hello, I ma new to the list and looking for some help with
> the following
> query.
>
>
Hello, I ma new to the list and looking for some help with the following
query.
insert into Temp (CompId) SELECT distinct(company_id) from Associations
where product_id=9;
When I exe that statement directly on the mysql command line It exe's with
no problem. However when I
exe that through php $
Thanks to all. Single quotes around '$value' did the trick.
Robbie
CPT John W. Holmes wrote:
From: "Robbie Staufer" <[EMAIL PROTECTED]>
I'm writing an application that will display the contents of a db in the
browser, including the db-assigned id number. The user can then enter
the id numb
--- Original Message -
From: "Robbie Staufer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 5:20 PM
Subject: [PHP-DB] update db with variables
> Hi,
>
> I'm writing an application that will display the contents of a db in
From: "Robbie Staufer" <[EMAIL PROTECTED]>
> I'm writing an application that will display the contents of a db in the
> browser, including the db-assigned id number. The user can then enter
> the id number in a form and the browser will display the record
> corresponding to that id number, with t
put some single quotes around $value in your SQL statement.
-Original Message-
From: Robbie Staufer [mailto:[EMAIL PROTECTED]
Sent: 24 September 2003 16:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] update db with variables
Hi,
I'm writing an application that will display the conten
Hi,
I'm writing an application that will display the contents of a db in the
browser, including the db-assigned id number. The user can then enter
the id number in a form and the browser will display the record
corresponding to that id number, with the data in editable text fields.
The user e
As a separate issue, I would consider seperating the address field into
it's individual parts
Street,area,city etc.. All different fields
-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] U
on 23/9/03 1:03 pm, Shaun at [EMAIL PROTECTED] wrote:
> 1. How can I clean the table, so for example changing:
> Ashfield Business Centre The Idlewells Precinct
> Sutton-in-Ashfield
> to:
> Ashfield Business Centre, The Idlewells Precinct, Sutton-in-Ashfield,
>
> 2, Is there a way to make s
Hi,
I have a column in my table called address. When users add an address with a
textarea they sometimes press return for a new line and this seems to be
putting line breaks into the database, so I have 2 questions:
1. How can I clean the table, so for example changing:
Ashfield Business Cent
Hi,
I have (amogst others) three tables in my database named Bookings, User, and
Representative. A User and a Representative are different types of user,
however I now want to merge these tables into one - User. When a Booking is
made, the User_ID and the Rep_ID are stored in the Booking table. I
ED]>
Sent: 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
> $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, usin
i'm new in studing php/mysql so HELP ME! :) thx
the query doesn't flow...
What's wrong in this code?!
in the DB there are 2 tables, here you are the queries to create them:
-table autori:
CREATE TABLE autori (
nome varchar(50) NOT NULL default '',
mail varchar(50) default NULL,
PRIM
Daniela,
Why do you want to keep a calculated field inside your database?
--
Beverly Steiner
[EMAIL PROTECTED]
-Original Message-
From: Dani Matielo [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:18 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Update MD5
Hello, everybody
my problem is the following: I just imported a csv file to a MySQL database
that contains name and email fields. It has about 9k lines on it and I need
a new field that orinally didn't exist called "code" thats suposed to be
MD5(name.email)
I know how to do this for new data, bu
On Saturday 01 March 2003 14:27, Alawi shekh albaity wrote:
> What wrong with this SQL
> $SQLSTATEMENT["UPDATE_CAT"] = "
> UPDATE cats SET
> cat_name = '$cat_name',
Remove that trailing comma.
> WHERE cat_id = $catidforedit
> ";
> Error no : 1064
> Details :
>
> You have an error in your
awi shekh albaity [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 12:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Update errors
What wrong with this SQL
$SQLSTATEMENT["UPDATE_CAT"] = "
UPDATE cats SET
cat_name = '$cat_name',
WHERE cat_id = $catidforedit
&qu
Remove the comma at the end of this line:
> cat_name = '$cat_name',//remove this comma
> -Original Message-
> From: Alawi shekh albaity [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 01, 2003 1:27 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Update er
What wrong with this SQL
$SQLSTATEMENT["UPDATE_CAT"] = "
UPDATE cats SET
cat_name = '$cat_name',
WHERE cat_id = $catidforedit
";
Error no : 1064
Details :
You have an error in your SQL syntax near 'WHERE cat_id = 2 ' at line 4
Db : mysql
--
PHP Database Mailing List (http://www.php.ne
, February 05, 2003 1:44 PM
Subject: Re: [PHP-DB] UPDATE doesn't work
> On Wednesday 05 February 2003 12:50, Le Hoang wrote:
>
> >
> > // Add 1 view to the view column
> >
> > $v = $row[view];
> > $vplus = $v+1;
> > $view = mysq
On Wednesday 05 February 2003 12:50, Le Hoang wrote:
>
> // Add 1 view to the view column
>
> $v = $row[view];
> $vplus = $v+1;
> $view = mysql_query("update photoshop_tutorial where id=$id set
> view=$vplus"); // Problem here!
You should ALWAYS check the result of a call to mysql_query():
if
Hello all,
I'm a graphic designer making a site for giving tutorials, but since i'm just a newbie
in coding, tons of problems have fallen on me.
This is my photoshop_tutorial table structure
id int not null auto_increment,
title varchar(255) not null,
author varchar(55) not null,
descr
;[EMAIL PROTECTED]>
>To: "Ike Austin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Tuesday, February 04, 2003 2:17 PM
>Subject: Re: [PHP-DB] update
>
>
>> UPDATE is for changing values in existing rows. It appears you want to
>> add new inf
To: "Ike Austin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 04, 2003 2:17 PM
Subject: Re: [PHP-DB] update
> UPDATE is for changing values in existing rows. It appears you want to
> add new information. Use INSERT.
>
> $query= "
UPDATE is for changing values in existing rows. It appears you want to
add new information. Use INSERT.
$query= "INSERT tablename SET (username, email, location) VALUES(
$username, $email, $location)";
Note that a WHERE condition is incorrect for INSERT.
Your UPDATE syntax is not correct either
Hello, Newbie question.
And can the same SQL portion of the code be written something like...
query= "UPDATE taablename SET (username, email, location)
VALUEs( $username, $email, $location)";
Any reason why this Update command would not execute?
// BUILD AND EXECUTE QUERY TO SAVE USER INFO INTO
On Friday 31 January 2003 15:31, nikos wrote:
> I've download some patches for PHP 4.0.6. and I dont know how to use it.
> For example rfc1867.c.diff-4.0.6 file how can I "run" it and do the update?
> I have PH 7,2 Linux and Apache 1,32
> Thank you
If there's no compelling reason for you to be st
Hello list
I've download some patches for PHP 4.0.6. and I dont know how to use it.
For example rfc1867.c.diff-4.0.6 file how can I "run" it and do the update?
I have PH 7,2 Linux and Apache 1,32
Thank you
On Sunday 15 December 2002 09:24, Hartleigh Burton wrote:
> Hi,
>
> I am having a small problem when it comes to updating some tables that I
> have. tblmembers and tbloptions are both linked together with the exact
> same userid #. here is the code i have been using...
>
> mys
Hi,
I am having a small problem when it comes to updating some tables that I
have. tblmembers and tbloptions are both linked together with the exact
same userid #. here is the code i have been using...
mysql_query("UPDATE tbloptions SET
strColorPref='$tmpColorPref' strText
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> Sent: 10 December 2002 20:02
>
> 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 witho
> 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
> ch
, SCOTT V (SBCSI); '1LT John W. 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 th
> To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Update Query Help...
>
>
> > $tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
> > $update = "UPDATE accounts SET atime='NOW()' WHERE
> > \"id-sys\&q
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] Update Query Help...
> $tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
> $update = "UPDATE ac
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
le.
Cheers
Jason
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:35 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Update Query Help...
I am attempting to UPDATE a table and I have having absolutely ZERO
success.
> $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
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
Hi..
I'm having some problem with an if condition when I'm trying to insert data
into a mysql table..
the script works fine with no parse errors..but the table doesn't get
updated like I want it to be..
and i'm almost certain that the code is correct...
Here is part of the script..
I have a form w
> Quick questionis it possible to do an update query w/ a join yet?
If
> not, what is your preferred method? Would you take care of it on the
PHP
> side?
Probably depends on your database, but MySQL doesn't support it. I think
MySQL 4.0 might.
> I need to update a table w/ data from another
1 - 100 of 151 matches
Mail list logo