Search the Community

OK, I'm new to PHP & MySQL so try and bare with me. I attempted to grab information from a database, but the template that I downloaded has two span classes, one alpha and one without an alpha extension. They run back to back in <li> tags. The issue is when I run the code it's pulling the identical information twice. I know I coded it wrong; I know there's an easy solution to this. I just don't know it. Any help would be appreciated. <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = 'SELECT fname, email, phone, description, rate FROM advisors'; mysql_select_db('mobile-advice'); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) { echo "<li class=\"frame-stuffbox col span_6 alpha\">". "<div class=\"frame-stuffbox-wrap\">". "<div class=\"frame-stuffbox-container\">". "<div class=\"frame-stuffbox-vinecontainer\">". "<img src=\"assets/images/_shape_bootle.png\" alt=\"\">". "</div>". "<section class=\"frame-stuffbox-content\">". "<h5><a href=\"product.html\">{$row['fname']}</a></h5>". "<div class=\"frame-stuffbox-description\">". "<p>{$row['description']}</p>". "</div>". "<div class=\"frame-stuffbox-priceside\">". "<span class=\"frame-stuffbox-price\">{$row['rate']} $</span>". "<a href=\"javascript:void(0)\" class=\"frame-button icon\"><img src=\"assets/images/_icon_addtocart.png\" alt=\"\" />Call Now</a>". "</div>". "</section>". "</div>". "</div>". "</li>". "<li class=\"frame-stuffbox col span_6\">". "<div class=\"frame-stuffbox-wrap\">". "<div class=\"frame-stuffbox-container\">". "<div class=\"frame-stuffbox-vinecontainer\">". "<img src=\"assets/images/_shape_bootle.png\" alt=\"\">". "</div>". "<section class=\"frame-stuffbox-content\">". "<h5><a href=\"product.html\">{$row['fname']}</a></h5>". "<div class=\"frame-stuffbox-description\">". "<p>{$row['description']}</p>". "</div>". "<div class=\"frame-stuffbox-priceside\">". "<span class=\"frame-stuffbox-price\">{$row['rate']}</span>". "<a href=\"javascript:void(0)\" class=\"frame-button icon\"><img src=\"assets/images/_icon_addtocart.png\" alt=\"\" />Call Now</a>". "</div>". "</section>". "</div>". "</div>". "</li>"; } echo "Fetched data successfully\n"; mysql_close($conn); ?>