canadezo121

What I'm trying to get done is in the first LI tag ending in Alpha I want to display the first user. The second LI tag I'm trying to get the second user.

My Website design only allows for four results at a time. How do I only display only four users using PHP?

What's going on is I have 3 users in my Database(Eventually more). James, Dennis and Tony. The first <LI> element is <li class=\"frame-stuffbox col span_6 alpha\"> Notice the "alpha" after span_6. The second <li> class eliminates the word "alpha". And it repeats so on and so forth. Alpha, is the first listing which has special CSS functions that spaces the two li classes accordingly. The issue that I'm having is user James is being displayed in both LI classes, in Alpha and without Alpha. Username Dennis and Tony are having the same issue.

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); ?>