At 19:58 10.03.2001, John Vanderbeck said:
[snip]
$query = "UPDATE Users SET firstname='$firstname', lastname='$lastname'
WHERE username='$user' password='$password'";
[snip]
Try "AND" instead of "", this should
]]
Sent: Saturday, March 10, 2001 2:09 PM
To: PHP User Group
Subject: Re: [PHP] MySQL problem - stumped
At 01:58 PM 3/10/01 -0500, John Vanderbeck wrote:
You are using in your statement ... should be "AND"
.
The following code is giving an me problems, I can't figure it
out t
- Admin, GameDesign
-Original Message-
From: Rick St Jean [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 2:09 PM
To: PHP User Group
Subject: Re: [PHP] MySQL problem - stumped
At 01:58 PM 3/10/01 -0500, John Vanderbeck wrote:
You are using in your statement
The following code is giving an me problems, I can't figure it
out to save
my soul. The last line gives:
Here is the code:
$link = db_connect();
$query = "UPDATE Users SET firstname='$firstname', lastname='$lastname'
WHERE username='$user' password='$password'";
$result =
On Saturday 10 March 2001 19:58, you wrote:
The following code is giving an me problems, I can't figure it out to
save my soul. The last line gives:
Here is the code:
$link = db_connect();
$query = "UPDATE Users SET firstname='$firstname', lastname='$lastname'
WHERE username='$user'
with that
call.
- John Vanderbeck
- Admin, GameDesign
-Original Message-
From: Julian Wood [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 2:28 PM
To: John Vanderbeck; PHP User Group
Subject: Re: [PHP] MySQL problem - stumped
Well, PHP seems to think that $link is not working, so
..
Thanks again. Your a deadline saver :)
- John Vanderbeck
- Admin, GameDesign
-Original Message-
From: Christian Reiniger [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 2:32 PM
To: PHP User Group
Subject: Re: [PHP] MySQL problem - stumped
On Saturday 10 March 2001 19
Howdy,
I'm getting weird problems trying to INSERT to two different tables, in
consecutive mysql_queries. Before, I had 3 queries going, and only 2 would
work at any time. It seemed like it was 'rotating' the bad query - first
the 1st query would fail (the other two were fine), then I'd empty
Hello,
First a bit of background, I'm running apache 1.3.12, php 4.03 and MySQL
3.23.22 under the Windows platform.
My problem is simply that when I write stuff to database tables full stops
are represented as copyright symbols when I view the data again. This is
probably me just being stupid -
Hi, sorry to post this here, but it's driving me crazy. On my local
machine, the following works no furys:
create table category (category_id integer primary key auto_increment,name
varchar(255) );
But on the production machine, I get:
ERROR 1064: parse error near 'auto_increment,name
On Tue, 20 Feb 2001 10:57, Josh G wrote:
Hi, sorry to post this here, but it's driving me crazy. On my local
machine, the following works no furys:
create table category (category_id integer primary key
auto_increment,name varchar(255) );
But on the production machine, I get:
ERROR 1064:
, and hangovers to... suffering.
- Original Message -
From: "David Robley" [EMAIL PROTECTED]
To: "Josh G" [EMAIL PROTECTED]; "PHP User Group"
[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 11:41 AM
Subject: Re: [PHP] mysql problem
On Tue, 20 Feb 2001 10:57, Jos
Tuesday, February 20, 2001 11:42 AM
Subject: Re: [PHP] mysql problem
Nope, I've been using autoincrement on that box for a year or so.
It's not a copy/paste thing, cause I'm getting it when I type the lines
in by hand, too...
Gfunk - http://www.gfunk007.com/
I sense much bee
]]
Sent: Monday, February 19, 2001 17:00
To: PHP User Group
Subject: Re: [PHP] mysql problem
Ok, I've fixed the problem, it seems there's some major differences
between the linux / win32 ports of the client.
instead of
blah integer primary key auto_increment
which works on windows, I
I think if you echo the error (echo mysql_error();) you will see the exact
error you would get if connected directly to the db.
You can do something like:
$result = @mysql_query($sql_query); // hide any errors
If (!$result) {
echo "Error: " . Mysql_error() . "BR";
}
On 2/20/01 2:57 AM this
Are you adding slashes beforehand (or running magic quotes) ? Also I always do
a stripslashes() on the text fields I print out.
--Joe
On Sat, Jan 27, 2001 at 11:06:03PM -0500, [EMAIL PROTECTED] wrote:
if you goto
http://downloads.moddingcentral.com/add.php
you will see a simple form
this
=
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 9:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP] strange PHP/MySQL problem
if you goto
http://downloads.moddingcentral.com/add.php
you will see a simple form
this form takes
101 - 117 of 117 matches
Mail list logo