TutorialNinja

Most Popular189

Graphic Design17

Desktop Programming19

Web Development197

Operating Systems9

Video & Audio Editing0

App Development

Site Statistics

Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 613

0 Users • 5 Guests Online

Forum Index » PHP + MySQL » [REQ] - Advanced shop, by Skil

Posted on Wednesday 26th December 2 at 03:18 AM
Jozo Newbie	Hey there :P Theres a good piece of script here, for a Advanced Shop.. http://rmb-scripting.com/tutorials.php?tutorial&tid=212 But how would you make it so that you can see what you have bought? Thanks :D
Posted on Saturday 29th December 20 at 11:33 PM
Diablosblizz Senior Member	Well, you can select them like this: PHP Code 1 2 3 4 5 6 7 <?php $select = mysql_query("SELECT * FROM `user_shop_items` WHERE `owner` = '$username'"); // $username if it's rmbs login. while($get = mysql_fetch_array($select)) { echo "<img src='$get[image]'> - $get[name]"; } ?> Not tested, but it should work.
Posted on Saturday 29th December 20 at 11:33 PM
Diablosblizz Senior Member	Ah wait, forgot to include the config file. After the <?php add: PHP Code 1 `include("config.php");` Sorry!
Posted on Monday 4th February 2008 at 09:31 PM
new2old Junior Member	would it be $logged[username] not $username ?
Posted on Tuesday 5th February 2008 at 08:31 PM
ShadowMage Senior Member	Right, look at the shop makeover thing i posted ;)