Help with query

Hi,
I am doing a project with dreamweaver and i ran into a hitch with my select statement.
I have this

Code:

---

SELECT *
    FROM client, `statement`
    WHERE client.client_id = `statement`.client_id

---

when i execute this it selects everybody in the database. So i want to add another WHERE statement to this query, this time one that compares the client.username with the session variable "MM_Username".
Thank you in anticipation of solving this for me!
So I am looking at something like this

Code:

---

SELECT *
    FROM client, `statement`
    WHERE client.client_id = `statement`.client_id  AND WHERE client.username = '$_SESSION['MM_Username']'

---

The session php code is as follows

PHP Code:

---

<?php
    if (!isset($_SESSION)) {
      session_start();
    }
    $MM_authorizedUsers = "";
    $MM_donotCheckaccess = "true";
     
    // *** Restrict Access To Page: Grant or deny access to this page
    function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
      // For security, start by assuming the visitor is NOT authorized. 
      $isValid = False; 
     
      // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
      // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
      if (!empty($UserName)) { 
        // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
        // Parse the strings into arrays. 
        $arrUsers = Explode(",", $strUsers); 
        $arrGroups = Explode(",", $strGroups); 
        if (in_array($UserName, $arrUsers)) { 
          $isValid = true; 
        } 
        // Or, you may restrict access to only certain users based on their username. 
        if (in_array($UserGroup, $arrGroups)) { 
          $isValid = true; 
        } 
        if (($strUsers == "") && true) { 
          $isValid = true; 
        } 
      } 
      return $isValid; 
    }
     
    $MM_restrictGoTo = "myflog.php";
    if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
      $MM_qsChar = "?";
      $MM_referrer = $_SERVER['PHP_SELF'];
      if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
      if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0) 
      $MM_referrer .= "?" . $_SERVER['QUERY_STRING'];
      $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
      header("Location: ". $MM_restrictGoTo); 
      exit;
    }
    ?>

---

Hey,

I'm not really that experienced with PHP/MySQL but maybe you should try adding ` and ' accordingly.
Meaning:

Code:

---

SELECT
    FROM `client`,`statement`
    WHERE `client`.`client_id` = `statement`.`client_id`
    AND WHERE `username`='{$_SESSION['$MM_username']}'

---

Not really sure if this SQL statement will work properly with the "AND WHERE".

Also, if you have wamp or xampp set up, use phpmyadmin SQL query feature to see what's the problem ;)

Use a join

PHP Code:

---

SELECT client.*, statement.*
    FROM client INNER JOIN statement
    ON client.client_id = statement.client_id
    WHERE client.username = '".$_SESSION['MM_Username']."'; 


---

use Inner Join