subject:"RE\: \[PHP\] Troubles Inserting into MYSQL"

RE: [PHP] Troubles Inserting into MYSQL

2002-09-09 Thread Jay Blanchard


[snip]
if ($update_type == update_Williams) {
mysql_query(INSERT INTO events ('user', 'detaildesc', 'index', 'reference',
'date_added') VALUES (\'$cookiewho\',
\'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
or die (could not do update);
}
[/snip]

Try this

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events (user, detaildesc, index, reference,
date_added)
VALUES (' . $cookiewho . ', ' . $add_Williams . ', '', ' . $row_num .
', ' . $last_update . '), $sql4)
or die (could not do update);
}

First of all, seems there is extra stuff in the query that shouldn't be
there (what is $sql4?) and you may have parentheses out of place.

HTH!

Jay



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Troubles Inserting into MYSQL

2002-09-09 Thread bbonkosk


If you read:
http://www.php.net/manual/en/function.mysql-query.php
You will see what $sql4 can be.

My guess would be he is connected to 2 or more different databases, and this is 
specifiying which one to execute the query on.
-Brad

 [snip]
 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events ('user', 'detaildesc', 'index', 'reference',
 'date_added') VALUES (\'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
   or die (could not do update);
   }
 [/snip]
 
 Try this
 
 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events (user, detaildesc, index, reference,
 date_added)
 VALUES (' . $cookiewho . ', ' . $add_Williams . ', '', ' . $row_num .
 ', ' . $last_update . '), $sql4)
   or die (could not do update);
   }
 
 First of all, seems there is extra stuff in the query that shouldn't be
 there (what is $sql4?) and you may have parentheses out of place.
 
 HTH!
 
 Jay
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Troubles Inserting into MYSQL

2002-09-08 Thread Paul Nicholson


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey,
Send the results of mysql_errno() please. :)
~Pauly

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
'reference', 'date_added') VALUES (\'$cookiewho\',
\'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
or echo mysql_errno()/*die (could not do update)*/;
}



On Sunday 08 September 2002 03:07 pm, you wrote:
 Hello,

 My code below always dies!  I've tried just about every iteration of the
 values, etc..  Can anybody show me how to insert into MySQL a value?

 INSERT INTO events ('user','detaildesc') VALUES ('$user','$details')

 I just don't get it!


 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES (\'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
   or die (could not do update);
   }

- -- 
~Paul Nicholson
Design Specialist @ WebPower Design
The webthe way you want it!
[EMAIL PROTECTED]

It said uses Windows 98 or better, so I loaded Linux!
Registered Linux User #183202 using Register Linux System # 81891
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9e6McDyXNIUN3+UQRAriZAKCTPYsBfypW7N6k8vpG+UDJEZ77BQCfVtEi
BmSkmFZDBbXuAm+g3nvw/tc=
=InFX
-END PGP SIGNATURE-

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Troubles Inserting into MYSQL

2002-09-08 Thread Steve Gaas



Parse error: parse error, unexpected T_ECHO in
/var/www/html/actionreg/doupdate.php on line 24

Forgot I had that function..  I don't understand the error though..

Steve Gaas
Sr. Systems Engineer, Carrier Markets
Riverstone Networks
972.668.8329 (follow-me)
877.713.7063 (pager analog dial)
[EMAIL PROTECTED] (interactive pager)

http://www.rstn.net / Nasdaq: RSTN
 
Wisdom begins in wonder.   -Socrates

-Original Message-
From: Paul Nicholson [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, September 08, 2002 2:21 PM
To: Steve Gaas; [EMAIL PROTECTED]
Subject: Re: [PHP] Troubles Inserting into MYSQL

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey,
Send the results of mysql_errno() please. :)
~Pauly

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
'reference', 'date_added') VALUES (\'$cookiewho\',
\'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
or echo mysql_errno()/*die (could not do update)*/;
}



On Sunday 08 September 2002 03:07 pm, you wrote:
 Hello,

 My code below always dies!  I've tried just about every iteration of the
 values, etc..  Can anybody show me how to insert into MySQL a value?

 INSERT INTO events ('user','detaildesc') VALUES ('$user','$details')

 I just don't get it!


 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES (\'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
   or die (could not do update);
   }

- -- 
~Paul Nicholson
Design Specialist @ WebPower Design
The webthe way you want it!
[EMAIL PROTECTED]

It said uses Windows 98 or better, so I loaded Linux!
Registered Linux User #183202 using Register Linux System # 81891
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9e6McDyXNIUN3+UQRAriZAKCTPYsBfypW7N6k8vpG+UDJEZ77BQCfVtEi
BmSkmFZDBbXuAm+g3nvw/tc=
=InFX
-END PGP SIGNATURE-




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Troubles Inserting into MYSQL

2002-09-08 Thread Steve Gaas


This syntax fixes the syntax error..

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events_Williams ('user', 'detaildesc', 'index',
'reference', 'date_added') VALUES \'$cookiewho\',
\'$add_Williams\',\'\',\'$row_num\',\'$last_update\', $sql4)
or print mysql_error();
}

this is the output
You have an error in your SQL syntax near ''user', 'detaildesc', 'index',
'reference', 'date_added') VALUES \'sgaas-wil\', ' at line 1

Steve Gaas
Sr. Systems Engineer, Carrier Markets
Riverstone Networks
972.668.8329 (follow-me)
877.713.7063 (pager analog dial)
[EMAIL PROTECTED] (interactive pager)

http://www.rstn.net / Nasdaq: RSTN
 
Wisdom begins in wonder.   -Socrates

-Original Message-
From: Steve Gaas 
Sent: Sunday, September 08, 2002 2:26 PM
To: 'Paul Nicholson'; Steve Gaas; [EMAIL PROTECTED]
Subject: RE: [PHP] Troubles Inserting into MYSQL


Parse error: parse error, unexpected T_ECHO in
/var/www/html/actionreg/doupdate.php on line 24

Forgot I had that function..  I don't understand the error though..

Steve Gaas
Sr. Systems Engineer, Carrier Markets
Riverstone Networks
972.668.8329 (follow-me)
877.713.7063 (pager analog dial)
[EMAIL PROTECTED] (interactive pager)

http://www.rstn.net / Nasdaq: RSTN
 
Wisdom begins in wonder.   -Socrates

-Original Message-
From: Paul Nicholson [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, September 08, 2002 2:21 PM
To: Steve Gaas; [EMAIL PROTECTED]
Subject: Re: [PHP] Troubles Inserting into MYSQL

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey,
Send the results of mysql_errno() please. :)
~Pauly

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
'reference', 'date_added') VALUES (\'$cookiewho\',
\'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
or echo mysql_errno()/*die (could not do update)*/;
}



On Sunday 08 September 2002 03:07 pm, you wrote:
 Hello,

 My code below always dies!  I've tried just about every iteration of the
 values, etc..  Can anybody show me how to insert into MySQL a value?

 INSERT INTO events ('user','detaildesc') VALUES ('$user','$details')

 I just don't get it!


 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES (\'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
   or die (could not do update);
   }

- -- 
~Paul Nicholson
Design Specialist @ WebPower Design
The webthe way you want it!
[EMAIL PROTECTED]

It said uses Windows 98 or better, so I loaded Linux!
Registered Linux User #183202 using Register Linux System # 81891
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9e6McDyXNIUN3+UQRAriZAKCTPYsBfypW7N6k8vpG+UDJEZ77BQCfVtEi
BmSkmFZDBbXuAm+g3nvw/tc=
=InFX
-END PGP SIGNATURE-




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Troubles Inserting into MYSQL

2002-09-08 Thread Brad Bonkoski


Shoudn't it be:

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events_Williams ('user', 'detaildesc', 'index',
'reference', 'date_added') VALUES
('$cookiewho','$add_Williams','','$row_num','$last_update'), $sql4)
or print mysql_error();
}
You need the '(' and ')' in your query to group VALUES

(And what's with all the escaping with '\'?  They don't appear to be
needed and make it look very cluttered, i.e. not very readable.

HTH
-Brad

Steve Gaas wrote:
 
 This syntax fixes the syntax error..
 
 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events_Williams ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES \'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\', $sql4)
 or print mysql_error();
 }
 
 this is the output
 You have an error in your SQL syntax near ''user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES \'sgaas-wil\', ' at line 1
 
 Steve Gaas
 Sr. Systems Engineer, Carrier Markets
 Riverstone Networks
 972.668.8329 (follow-me)
 877.713.7063 (pager analog dial)
 [EMAIL PROTECTED] (interactive pager)
 
 http://www.rstn.net / Nasdaq: RSTN
 
 Wisdom begins in wonder.   -Socrates
 
 -Original Message-
 From: Steve Gaas
 Sent: Sunday, September 08, 2002 2:26 PM
 To: 'Paul Nicholson'; Steve Gaas; [EMAIL PROTECTED]
 Subject: RE: [PHP] Troubles Inserting into MYSQL
 
 Parse error: parse error, unexpected T_ECHO in
 /var/www/html/actionreg/doupdate.php on line 24
 
 Forgot I had that function..  I don't understand the error though..
 
 Steve Gaas
 Sr. Systems Engineer, Carrier Markets
 Riverstone Networks
 972.668.8329 (follow-me)
 877.713.7063 (pager analog dial)
 [EMAIL PROTECTED] (interactive pager)
 
 http://www.rstn.net / Nasdaq: RSTN
 
 Wisdom begins in wonder.   -Socrates
 
 -Original Message-
 From: Paul Nicholson [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, September 08, 2002 2:21 PM
 To: Steve Gaas; [EMAIL PROTECTED]
 Subject: Re: [PHP] Troubles Inserting into MYSQL
 
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Hey,
 Send the results of mysql_errno() please. :)
 ~Pauly
 
 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES (\'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
 or echo mysql_errno()/*die (could not do update)*/;
 }
 
 On Sunday 08 September 2002 03:07 pm, you wrote:
  Hello,
 
  My code below always dies!  I've tried just about every iteration of the
  values, etc..  Can anybody show me how to insert into MySQL a value?
 
  INSERT INTO events ('user','detaildesc') VALUES ('$user','$details')
 
  I just don't get it!
 
 
  if ($update_type == update_Williams) {
  mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
  'reference', 'date_added') VALUES (\'$cookiewho\',
  \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
or die (could not do update);
}
 
 - --
 ~Paul Nicholson
 Design Specialist @ WebPower Design
 The webthe way you want it!
 [EMAIL PROTECTED]
 
 It said uses Windows 98 or better, so I loaded Linux!
 Registered Linux User #183202 using Register Linux System # 81891
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.0.6 (GNU/Linux)
 Comment: For info see http://www.gnupg.org
 
 iD8DBQE9e6McDyXNIUN3+UQRAriZAKCTPYsBfypW7N6k8vpG+UDJEZ77BQCfVtEi
 BmSkmFZDBbXuAm+g3nvw/tc=
 =InFX
 -END PGP SIGNATURE-
 
   
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Troubles Inserting into MYSQL

2002-09-08 Thread Steve Gaas


Ohmygosh.. That works...

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events_Williams (user, detaildesc, indexx,
reference, date_added) VALUES ('$cookiewho',
'$add_Williams','','$row_num','$last_update'), $sql4)
or print mysql_error();
}

inserts perfectly..



Steve Gaas
Sr. Systems Engineer, Carrier Markets
Riverstone Networks
972.668.8329 (follow-me)
877.713.7063 (pager analog dial)
[EMAIL PROTECTED] (interactive pager)

http://www.rstn.net / Nasdaq: RSTN
 
Wisdom begins in wonder.   -Socrates

-Original Message-
From: Brad Bonkoski [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, September 08, 2002 2:43 PM
To: Steve Gaas
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP] Troubles Inserting into MYSQL

Shoudn't it be:

if ($update_type == update_Williams) {
mysql_query(INSERT INTO events_Williams ('user', 'detaildesc', 'index',
'reference', 'date_added') VALUES
('$cookiewho','$add_Williams','','$row_num','$last_update'), $sql4)
or print mysql_error();
}
You need the '(' and ')' in your query to group VALUES

(And what's with all the escaping with '\'?  They don't appear to be
needed and make it look very cluttered, i.e. not very readable.

HTH
-Brad

Steve Gaas wrote:
 
 This syntax fixes the syntax error..
 
 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events_Williams ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES \'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\', $sql4)
 or print mysql_error();
 }
 
 this is the output
 You have an error in your SQL syntax near ''user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES \'sgaas-wil\', ' at line 1
 
 Steve Gaas
 Sr. Systems Engineer, Carrier Markets
 Riverstone Networks
 972.668.8329 (follow-me)
 877.713.7063 (pager analog dial)
 [EMAIL PROTECTED] (interactive pager)
 
 http://www.rstn.net / Nasdaq: RSTN
 
 Wisdom begins in wonder.   -Socrates
 
 -Original Message-
 From: Steve Gaas
 Sent: Sunday, September 08, 2002 2:26 PM
 To: 'Paul Nicholson'; Steve Gaas; [EMAIL PROTECTED]
 Subject: RE: [PHP] Troubles Inserting into MYSQL
 
 Parse error: parse error, unexpected T_ECHO in
 /var/www/html/actionreg/doupdate.php on line 24
 
 Forgot I had that function..  I don't understand the error though..
 
 Steve Gaas
 Sr. Systems Engineer, Carrier Markets
 Riverstone Networks
 972.668.8329 (follow-me)
 877.713.7063 (pager analog dial)
 [EMAIL PROTECTED] (interactive pager)
 
 http://www.rstn.net / Nasdaq: RSTN
 
 Wisdom begins in wonder.   -Socrates
 
 -Original Message-
 From: Paul Nicholson [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, September 08, 2002 2:21 PM
 To: Steve Gaas; [EMAIL PROTECTED]
 Subject: Re: [PHP] Troubles Inserting into MYSQL
 
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Hey,
 Send the results of mysql_errno() please. :)
 ~Pauly
 
 if ($update_type == update_Williams) {
 mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
 'reference', 'date_added') VALUES (\'$cookiewho\',
 \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
 or echo mysql_errno()/*die (could not do update)*/;
 }
 
 On Sunday 08 September 2002 03:07 pm, you wrote:
  Hello,
 
  My code below always dies!  I've tried just about every iteration of the
  values, etc..  Can anybody show me how to insert into MySQL a value?
 
  INSERT INTO events ('user','detaildesc') VALUES ('$user','$details')
 
  I just don't get it!
 
 
  if ($update_type == update_Williams) {
  mysql_query(INSERT INTO events ('user', 'detaildesc', 'index',
  'reference', 'date_added') VALUES (\'$cookiewho\',
  \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'), $sql4)
or die (could not do update);
}
 
 - --
 ~Paul Nicholson
 Design Specialist @ WebPower Design
 The webthe way you want it!
 [EMAIL PROTECTED]
 
 It said uses Windows 98 or better, so I loaded Linux!
 Registered Linux User #183202 using Register Linux System # 81891
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.0.6 (GNU/Linux)
 Comment: For info see http://www.gnupg.org
 
 iD8DBQE9e6McDyXNIUN3+UQRAriZAKCTPYsBfypW7N6k8vpG+UDJEZ77BQCfVtEi
 BmSkmFZDBbXuAm+g3nvw/tc=
 =InFX
 -END PGP SIGNATURE-
 
   
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Troubles Inserting into MYSQL

RE: [PHP] Troubles Inserting into MYSQL

Re: [PHP] Troubles Inserting into MYSQL

RE: [PHP] Troubles Inserting into MYSQL

RE: [PHP] Troubles Inserting into MYSQL

Re: [PHP] Troubles Inserting into MYSQL

RE: [PHP] Troubles Inserting into MYSQL

7 matches

Site Navigation

Mail list logo

Footer information