[SOLVED] invalid syntax ?? with query

[ag3nt42]

can anyone tell me what is wrong with this query

 

<?php

$Inject[$y]="INSERT INTO [ClientsEmails] WHERE CompanyName='".$Company[$y]."' (username, password) VALUES ('".$username[$y]."','".$password[$y]."')";
?>

 

 

keep getting error saying syntax error near WHERE on line /\(that line)

 

[wildteen88]

IGNORE ME

[DarkWater]

You can't have a WHERE with an INSERT.  And why the [ ] around the table name?

[ag3nt42]

thats how it is in the DB and my DB wants me to use it..

 

also your sposed to be able to use a WHERE in insert statements

 

\/

 

http://www.sql-tutorial.com/sql-where-sql-tutorial/

 

The WHERE keyword can be used to insert, update and delete data from table(s

[DarkWater]

No you're not.  Are you trying to do an UPDATE instead...?  INSERT WHERE makes no sense.

[ag3nt42]

i spose i could use update..

 

but i'm not updating anything

[ag3nt42]

dark.. I like the fact that you try to be helpful..

 

but I can't stand how arrogant you are about it..

 

really irritating.

[DarkWater]

Then what are you doing...?

 

And I'm not being arrogant, believe me. o-O  How am I being arrogant by saying that INSERT WHERE makes no sense?  It doesn't.  You're inserting a new row.  There's nothing to WHERE about.

[ag3nt42]

its not always what you say man its how you say it

 

 

and if you want to get "makes sense" on it.. then yes it DOES make sense

 

cuz i'm not updating any information.. I'm INSERTING brand new information.

[DarkWater]

Yeah, but you can't tell how I'm saying something on a forum.   Believe me, I wasn't being arrogant.  Now, what exactly are you trying to accomplish with this code?

[ag3nt42]

sure you can.

 

[DarkWater]

Don't take every tutorial as pure truth.  There can be mistakes.  The MySQL manual for INSERT highlights the 3 syntax options as:

 

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [iGNORE]
    [iNTO] tbl_name [(col_name,...)]
    {VALUES | VALUE} ({expr | DEFAULT},...),(...),...
    [ ON DUPLICATE KEY UPDATE
      col_name=expr
        [, col_name=expr] ... ]

Or:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [iGNORE]
    [iNTO] tbl_name
    SET col_name={expr | DEFAULT}, ...
    [ ON DUPLICATE KEY UPDATE
      col_name=expr
        [, col_name=expr] ... ]

Or:

INSERT [LOW_PRIORITY | HIGH_PRIORITY] [iGNORE]
    [iNTO] tbl_name [(col_name,...)]
    SELECT ...
    [ ON DUPLICATE KEY UPDATE
      col_name=expr
        [, col_name=expr] ... ]

 

No WHERE. =P  It logically doesn't make much sense....

[ag3nt42]

thats just what I thought you'd say.. :-\

 

 

[DarkWater]

thats just what I thought you'd say.. :-\

 

 

 

Uhh....okay...?

[Jabop]

Why was this bumped? Dark got the point across and you DO NOT insert WHERE.

[DarkWater]

Why was this bumped? Dark got the point across and you DO NOT insert WHERE.

 

Thanks. 

[ag3nt42]

lol