Jump to content
bleemster

n00b help - pulling two sql tables

Recommended Posts

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

Edited by bleemster

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.