having problem while running a insert query using select query through php code

Question

INSERT INTO `C301554_myroom`.`visitor` (
`Name` ,
`Address` ,
`City` ,
`State` ,
`Country` ,
`PIN` ,
`no_of_males` ,
`no_of_females` ,
`no_of_childrens` ,
`mail` ,
`Phone_no` ,
`Senior_Citizens` ,
`ID` ,
`date_from` ,
`date_to` ,
`Visitor_ID` ,
`Vehicle_No` ,
`Purpose`
)
VALUES (
'Jaspreet', 'D-66', 'Rohtak', 'HR', (

SELECT Country_Name
FROM country_code
WHERE Country_Code = "IN"
), '124001', '1', '1', '1', '', '2324342', 'Y', 'passport', '3/7/2011', '6/7/2011', 'null', '22', 'For Admission'

Above query is running on mysql but when i am trying to execute the query through php it is giving mysql error. -----here the code is------

$sql="INSERT INTO `C301554_myroom`.`visitor` (
`Name` ,
`Address` ,
`City` ,
`State` ,
`Country` ,
`PIN` ,
`no_of_males` ,
`no_of_females` ,
`no_of_childrens` ,
`mail` ,
`Phone_no` ,
`Senior_Citizens` ,
`ID` ,
`date_from` ,
`date_to` ,
`Visitor_ID`,
`Vehicle_No`,
`Purpose`
)

VALUES('$jName','$jAddress','$jCity','$jState',(select Country_Name from country_code where Country_Code=".$jcountry."),'$jpin','$jmale','$jfemale','$jchildren','$jemail','$jphone','$jSenior_Citizen','$jid','$jfrom','$jto','$RID','$jvehicle','$jpurpose')";

I think that Country_Code is string, so you should add quotes to Country_Code='".$jcountry."' — Alex Pliutau
– Alex Pliutau, Commented Jul 4, 2011 at 7:35
i know where is the error when the subquery executes (select Country_Name from country_code where Country_Code=".$jcountry.") it will return a variable (for eg india) now to execute the whole query the value teturned(INDIA) should be in double quotes("INDIA") and i am unable to do that.How to concatenate double quotes with it.I tried it many times using . operator but still getting error — Jaspreet Singh
– Jaspreet Singh, Commented Jul 4, 2011 at 7:37

Francois Deschenes · Accepted Answer · 2011-07-04 07:36:09Z

2

You're missing single quotes around the $jcountry in the sub-query that select the country code.

(select Country_Name from country_code where Country_Code='".$jcountry."')

answered Jul 4, 2011 at 7:36

Francois Deschenes

25.1k4 gold badges67 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Álvaro González Over a year ago

@Jaspreet Singh - Use prepared statements and you will no longer need to care about single quotes.

Collectives™ on Stack Overflow

having problem while running a insert query using select query through php code

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related