www.webdeveloper.com
Results 1 to 5 of 5

Thread: Help with query

Hybrid View

  1. #1
    Join Date
    Jan 2013
    Posts
    1

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

  2. #2
    Join Date
    Sep 2012
    Posts
    5
    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".
    Last edited by KirillTaylor; 01-17-2013 at 07:18 AM. Reason: addition

  3. #3
    Join Date
    Sep 2012
    Posts
    5
    Also, if you have wamp or xampp set up, use phpmyadmin SQL query feature to see what's the problem

  4. #4
    Join Date
    Aug 2012
    Posts
    155
    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']."'

  5. #5
    Join Date
    Jan 2013
    Posts
    2
    use Inner Join

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles