html - How can i retrieve the ordered products by user, and display them? using SESSION PHP -

how can retrieve ordered products user, , display them?

i have 2 tables: orders_good & users, if register wil go users, , if order product go in orders_good.

everything working fine, except 1 thing.

after user submit order, want see ordered products on page.

so let want : if user logged in, search name in table: ('orders_good").. , if find name in table search if has products orders, if yes: show orders, row row, if no show: no orders yet .....

the table: orders_good, haves 2 columns: user_name & product_order

i tyring this, user_name session working.

but how can show users ordered products row row???

$sql = "select * orders";  $result = mysql_query($sql);  if (!$result) { echo "could not run query ($sql) db: " . mysql_error(); exit; }  if (mysql_num_rows($result) == 0) { echo "no rows found, nothing print exiting"; exit; }   session_id($id); session_start(); echo $_session['user_name']; echo $row["product_order"]; 

this db structure:

okay,

first general warning. mysql functions deprecated. use mysqli or pdo.

then.. should not link tables usernames. happen if have 2 users te same name? things mixed through each other.

so first thing give user table , order table primary key autoincrement. , call column user_id , order_id.

so user table:

• user_id (primary key / autoincrement / integer)
• name (varchar)
• email (varchar)
• ...

for orders table need "foreign key" users table.

this foreign key stores user_id .

so order table:

• order_id (primary key / autoincrement / integer)
• user_id (integer)
• order_date (datetime)
• ...

you need orderrule table stores 1 article belongs order

• orderrule_id (primary key / autoincrement / integer)
• order_id (integer)
• quantity (integer)
• description (varchar)
• amount (decimal 10,2)

schematic:

user 1: --> order 1: --> orderrule 1                      --> orderrule 2                      --> orderrule 3          --> order 2: --> orderrule 4                      --> orderrule 5  user 2: --> order 3: --> orderrule 6                      --> orderrule 7                      --> orderrule 8                      --> orderrule 9          --> order 4: --> orderrule 10