0

Hello

I was wondering if it is posible to show the user profile along with the products information let suppose if I had shown th the produtcs information can i show the information of the user who uploaded this prodcut.

$query2   = "SELECT * FROM users, products;
    $get_user = mysqli_query($connection, $query2);

    while ($row_user = mysqli_fetch_array($get_user)) { 
        echo "<div class='col-m'><h2 class='info-heading'>WATCH WORLD NYC</h2>";

        echo "<div class='prod-info'><div class='pbox-s'><span>ID:</span></div><div class='pbox-m'>". $row_user["u_id"] ;
        echo "</div><div class='clear'></div>";

        echo "<div class='pbox-s'><span>Name:</span></div><div class='pbox-m'>". $row_user["user_name"] ."</div><div class='clear'></div>";

        echo "<div class='pbox-s'><span>Phone:</span></div><div class='pbox-m'>". $row_user["phone"] ."</div><div class='clear'></div>";

        echo "<div class='pbox-s'><span>Fax:</span></div><div class='pbox-m'>". $row_user["fax"] ."</div><div class='clear'></div>";

        echo "<div class='pbox-s'><span>Mobile:</span></div><div class='pbox-m'>". $row_user["mobile"] ."</div><div class='clear'></div>";

        echo "<div class='pbox-s'><span>Email:</span></div><div class='pbox-m'>". $row_user["email"] ."</div><div class='clear'></div>";

        echo "<div class='pbox-s'><span>Location:</span></div><div class='pbox-m'>New York, NY</div><div class='clear'></div></div></div>";
    }   

products are already called this is the loop within the loop

please let me know if we can do this or not

3
Contributors
3
Replies
18
Views
2 Years
Discussion Span
Last Post by UK-1991
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.