define a variable in a query then use it within the same query?

Question

i made a class connection that will handle the query also then return all the data needed from the database :

the problem is how can define a variable within the query that will handle one value that i want to insert it in the same query !!

$invoice_connection_add = new connection("
SET @myvar := select `brand_name` from `brands` where `brand_code` = $_POST[brand_code]
insert into `invoices` (`brand_code`, `brand_name`, `quantity`, `price`,`date`, `salesman`) values ('$_POST[brand_code]',@myvar, '$_POST[quantity]', '$_POST[price]', '$_POST[date]', '$_SESSION[username]');","insert_update");

hard to understand. do you want a parameterized query? or some other construct - like a subselect? — Randy
– Randy, Commented Dec 10, 2012 at 15:54
that's what i need " $_Post['brand_name'] " , and i have to get it from another table where brand_code = $_POST['brand_code']; — user1892114
– user1892114, Commented Dec 10, 2012 at 15:58

Steve's a D · Accepted Answer · 2012-12-10 16:37:04Z

1

Nobody else seems to be answering so I'll give it a shot - you can do something like this. You might need to play with the quotations and stuff a little bit but it'll give you an idea of what you want to do.

INSERT INTO invoices (all your columns) 
  SELECT '$_POST[brand_code]', brand_name, '$_POST[quantity]', 
  '$_POST[price]', '$_POST[date]', '$_SESSION[username]' 
  FROM `brands` 
  WHERE `brand_code` = $_POST[brand_code]

edited Dec 10, 2012 at 16:37

answered Dec 10, 2012 at 16:03

Steve's a D

3,82111 gold badges43 silver badges61 bronze badges

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

4 Comments

user1892114 Over a year ago

well yes i thought about this but can i do the following :INSERT INTO invoices (all your columns) values ((select brand_name from brands where brands.brandcode = $_post[brand code]), $_post[], $post, $post ); i made this but it's taking select statement as text and insert it in the db

Steve's a D Over a year ago

@user1892114 Pretty sure you dont put it in values()

Popnoodles Over a year ago

there's a backtick at the end of the code. can't remove because SO insists at least 6 chars are replaced

user1892114 Over a year ago

thank you once again : ) , i spent 3 hours trying to do such tricky code but my brain is halted : )

Collectives™ on Stack Overflow

define a variable in a query then use it within the same query?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related