Snytax problem?

[rp_joe]

I am getting an error:

SQL error:

 

Query:

insert into Inven ( h_num, upc, cs_upc, descript) values ( 5067 , 34998, 05000042634, FANCY FST SLC BEEF )

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FST SLC BEEF )' at line 4

 

Here is the code :

insert into Inven (

        h_num, upc, cs_upc, descript)

 

        values ( 5067  , 34998,  " . $real_upc_cs .", ". $descript ."

                ) ;

 

If I take descript out it runs fine. I thought its must be defined wrong in the table,  so I changed it from a var char to a char. Same result.

[F1Fan]

You need quotes around text.

[flyhoney]

I believe you need quotes around FANCY FST SLC BEEF

 

insert into Inven ( h_num, upc, cs_upc, descript) values ( 5067 , 34998, 05000042634, 'FANCY FST SLC BEEF' )

[rp_joe]

I have quoutes around the varible, Is that enough?

[premiso]

Nope.

 

Insert into Inven (
        h_num, upc, cs_upc, descript)

        values ( 5067  , 34998,  " . $real_upc_cs .", '". $descript ."'
                 ) ;

 

You need single quotes around all text being entered into a SQL database. 

[kenrbnsn]

Please post your code between

tags. This will make it much easier to read.

 

Ken

[rp_joe]

Amazing !!! Thank you.