+---------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+----------------+ | user_id | int(11) | NO | PRI | NULL | auto_increment | | user_uname | varchar(255) | YES | | NULL | | | user_email | varchar(255) | YES | | NULL | | | user_password | varchar(255) | YES | | NULL | | | user_fname | varchar(255) | YES | | NULL | | +---------------+--------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) +---------+------------+----------------+---------------+------------+ | user_id | user_uname | user_email | user_password | user_fname | +---------+------------+----------------+---------------+------------+ | 1 | test | test@test.com | testpassword | testfname | | 2 | mattg | mattg@test.com | test123 | matt | +---------+------------+----------------+---------------+------------+ 2 rows in set (0.00 sec) +------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------+------+-----+---------+----------------+ | prod_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | prod_name | varchar(127) | YES | | NULL | | | prod_img | varchar(127) | YES | | NULL | | | prod_description | varchar(511) | YES | | NULL | | | prod_price | decimal(10,2) | YES | | NULL | | | prod_rating | tinyint(3) unsigned | YES | | NULL | | | prod_sku | char(32) | YES | | NULL | | | prod_stock | int(10) unsigned | YES | | NULL | | +------------------+---------------------+------+-----+---------+----------------+ 8 rows in set (0.00 sec) +---------+------------------------------------+------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+-------------+------------+------------+ | prod_id | prod_name | prod_img | prod_description | prod_price | prod_rating | prod_sku | prod_stock | +---------+------------------------------------+------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+-------------+------------+------------+ | 1 | Star Wars IV A New Hope | starwars4.png | Luke Skywalker joins forces with a Jedi Knight, a cocky pilot, a Wookie, and two droids to save the galaxy from the Empire's world-destroying battle station, while also attempting to rescue Princess Leia from the mysterious Darth Vader | 14.99 | 5 | 1234567890 | 10 | | 2 | Star Wars V The Empire Strike Back | starwars5.png | After the Rebels are brutally overpowered by the Empire on the ice planet Hoth, Luke Skywalker begins Jedi training with Yoda, while his friends are pursued by Darth Vader. | 14.99 | 4 | 1258974025 | 0 | | 3 | Jaws | jaws.png | When a killer shark unleashes chaos on a beach resort, it's up to a local sheriff, a marine biologist, and an old seafarer to hunt the beast down. | 4.99 | 3 | 0147963824 | 2 | | 4 | Deadpool | deadpool.png | This is the origin story of former Special Forces operative turned mercenary Wade Wilson, who after being subjected to a rogue experiment that leaves him with accelerated healing powers, adopts the alter ego Deadpool. | 19.99 | 4 | 9873254084 | 8 | | 5 | Deadpool 2 | deadpool2.png | Foul-mouthed mutant mercenary Deadpool brings together a team of fellow mutant rogues to protect a young boy with supernatural abilities from the brutal, time-traveling cyborg, Cable. | 24.99 | 5 | 0186318724 | 1 | | 6 | Indiana Jones and the Last Crusade | indianajones.png | Set in 1938, after his father goes missing while pursuing the Holy Grail, Indiana Jones finds himself up against Nazis again to stop them obtaining its powers. | 9.99 | 3 | 4583216790 | 5 | +---------+------------------------------------+------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+-------------+------------+------------+ 6 rows in set (0.00 sec)