insert multiple data in single field in mysql

Question

$sql="INSERT INTO sales ( date, po ) 
VALUES
('$_POST[date]','$_POST[po]')

select('$_POST[date]'.'$_POST[po]')";

how can i insert multiple in "po" field

i want to insert more information in "po" just like the products, quantity, total amount! how would i insert multiple data in "po"

will i use another table on this!

pls help me on this!

if i could just attached image i love it but stackoverflow didnt allow new user to attached image

edit: Reformatted codeblock

Taking all data in a single fields will give you and fellow other members to readablity and coding issues. only you can understand it.. make some extra tables fields where you can store other product details seperately.. This is the best practice.. As mentioned @FreudianSlip you can add the table fields — Rafee
– Rafee, Commented Mar 20, 2012 at 7:26

FreudianSlip · Accepted Answer · 2012-03-20 07:23:00Z

1

Without trying to sound "smart" here, you're going to need to re-evaluate how you store data. There are a few options here, but probably the easiest given your example is to have 2 tables, one a "header" and one a "detail".

The header table might contain the PO Number, Date, Supplier, Total etc... and the detail table would be something like, PO Number (link), Item Number, Description, Qty, Price, VAT Rate etc.

answered Mar 20, 2012 at 7:23

FreudianSlip

2,92030 silver badges27 bronze badges

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

1 Comment

darwinboy Over a year ago

FreudianSlip OK example under "PO" is the quantity, unit ,product and the amount! example the customer has 2 order example 2 box spoon $1000 and 3 box for $1500! how would i code it using PHP, thanks so much

yehuda · Accepted Answer · 2012-03-20 07:22:33Z

0

You can either use a comma delimited set of brackets for more of the same structure, ie

 ('$_POST[date]','$_POST[po]'), ('$_POST[date]','$_POST[po]'), ('$_POST[date]','$_POST[po]')

You can add more fields to your table too to include other stuff.

answered Mar 20, 2012 at 7:22

yehuda

1,2822 gold badges11 silver badges21 bronze badges

Collectives™ on Stack Overflow

insert multiple data in single field in mysql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related