bleemster Posted February 13, 2018 Share Posted February 13, 2018 I seem to be having trouble pulling in information from two tables... I can get all the info from the data table and display it in tables but how to i replace the code as shown with xxxxxxxxx with the FULLNAME field from the USER table which is associated with the USERNAME or $_SESSION Username? Thanks in advanced <?php error_reporting(E_ALL); ini_set('display_errors', '1'); session_start(); if(!isset($_SESSION['username'])){ header("Location:login.php"); } require('connect.php'); // create query $query = "SELECT * FROM data WHERE CREATOR='xxxxxxxxx' AND AVAILABILITY > 0 ORDER BY ID DESC"; $query2 = "SELECT * FROM user"; $query3 = "SELECT * FROM data WHERE CREATOR LIKE 'xxxxxxxxxx' AND AVAILABILITY = 0 ORDER BY ID DESC LIMIT 10"; // get results $result = mysqli_query($connection, $query); $result2 = mysqli_query($connection, $query2); $result3 = mysqli_query($connection, $query3); // Fetch data $data = mysqli_fetch_all($result, MYSQLI_ASSOC); $user = mysqli_fetch_all($result2, MYSQLI_ASSOC); $data2 = mysqli_fetch_all($result3, MYSQLI_ASSOC); // var_dump($user); // free result mysqli_free_result($result); mysqli_free_result($result2); mysqli_free_result($result3); // Close Connection mysqli_close($connection); ?> Link to comment Share on other sites More sharing options...
phpmillion Posted February 13, 2018 Share Posted February 13, 2018 Most likely you are looking for MySQL JOIN functionality. https://www.w3schools.com/sql/sql_join.asp Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.