Ptsface12 Posted October 15, 2011 Share Posted October 15, 2011 Hello, I am trying to get a value from a MYSQL table, and echo it. It is a shopping cart, then tells you how much you have spent. Most other scripts have done, but I'm having some trouble getting the value back. Here's the code where I need it inserted: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>RC-Chemicals - <?php echo $title ?></title> <!--css --> <link href="./css/style.css" type="text/css" rel="stylesheet" /> <link rel="stylesheet" type="text/css" href="./fancybox/jquery.fancybox-1.3.4.css" media="screen" /> <!--js --> <script type="text/javascript" src="./js/jquery.js"></script> <script type="text/javascript" src="./js/chili-1.7.pack.js"></script> <script type="text/javascript" src="./js/jquery.cycle.all.2.72.js"></script> <script type="text/javascript" src="./js/cufon-yui.js"></script> <script type="text/javascript" src="./js/sansation.js"></script> <script type="text/javascript" src="./js/carusel.js"></script> <script type="text/javascript" src="./js/script.js"></script> <script type="text/javascript" src="./js/functions.js"></script> <script type="text/javascript" src="./js/jquery.sudoSlider.js"></script> <script type="text/javascript" src="./fancybox/jquery.mousewheel-3.0.4.pack.js"></script> <script type="text/javascript" src="./fancybox/jquery.fancybox-1.3.4.pack.js"></script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon"/></head> <body> <div id="wrapper"> <div id="header"> <a href="index.php"><img src="./images/logo.png" alt="" id="logo" /></a> <div class="right_header"> <div class="cart-box"> <div class="cart-left"></div> <?php if (!isset($_SESSION['user'])) { echo "<div class=\"cart-content\"> <ul> <li><a href=\"#\">00 item</a></li> <li><a href=\"#\"><span>50.00</span></a></li> </ul> </div> <div class=\"cart-right\"></div> </div>"; } else { echo "<div class=\"cart-content\"> <ul> <li>Please login to purchase.</li> </ul> </div> <div class=\"cart-right\"></div> </div>"; } ?> <div class="account_login"> <ul> <li><a href="login.php">Login </a></li> </ul> </div> <div class="search_field"> <input type="text" value="Enter keywords to search" onfocus="if(this.value == 'Enter keywords to search') { this.value = ''; }" onblur="if(this.value == '') { this.value = 'Enter keywords to search'; }" /> <a href="#">Search</a> </div> </div> <div id="nav"> <ul> <li><a href="#">Methoxetamine</a></li> <li><a href="#" class="active">Products</a> <ul> <li>MDAI</li> <li><a href="#">Methoxetamine</a></li> <li><a href="#">Methiopropamine</a></li> <li><a href="#">NRG-3</a></li> <li><a href="#">AMT</a></li> <li><a href="#">5-APB</a></li> <li><a href="#">Benzo Fury Pellets)</a></li> </ul> </li> <li><a href="#">Contact</a></li> <li><a href="#">Forums</a></li> </div> <br class="clear" /> </div> <div id="wrapper"> <div id="header"> <a href="index.php"><img src="./images/logo.png" alt="" id="logo" /></a> <div class="right_header"> <div class="cart-box"> <div class="cart-left"></div> <?php if (!isset($_SESSION['user'])) { echo "<div class=\"cart-content\"> <ul> <li><a href=\"#\">00 item</a></li> <li><a href=\"#\"><span>50.00</span></a></li> </ul> </div> <div class=\"cart-right\"></div> </div>"; } else { echo "<div class=\"cart-content\"> <ul> <li>Please login to purchase.</li> </ul> </div> <div class=\"cart-right\"></div> </div>"; } ?> Extra details: Table name: tbl_users Column name: cart WHERE: email='$_SESSION['user']' Thank you guys very much! Link to comment https://forums.phpfreaks.com/topic/249181-getting-value-from-mysql-table-and-echoing/ Share on other sites More sharing options...
Drummin Posted October 15, 2011 Share Posted October 15, 2011 I don't see any attempt to query the table. Why not give it a try and post back if you run into problems. Link to comment https://forums.phpfreaks.com/topic/249181-getting-value-from-mysql-table-and-echoing/#findComment-1279624 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.