Jump to content

WesL

Members
  • Posts

    7
  • Joined

  • Last visited

    Never

Posts posted by WesL

  1. I did something similar with a sight that I'm working on right now. I was pasing the 'order number' on to the following page(s) and calling certain fields from the MySQL db.

     

    I used a variable of $ID as the variable to track

     

    I used a hyper link:

    echo "<a href='phpscript.php?pid=$id'> Click here to continue with order # $id </a>";
    

     

    Using a '?' after the *.php page name allows to you send variables to the next page and have those variables acted on.

     

    Next, we need to receive the info:

    $id = $_GET['pid'];
    
    
    $result=mysql_query("SELCT * FROM images WHERE id={$id}");
    

     

    Good Luck

     

  2. I have a log-in script that after loging in takes the user to a 'product page.' On that 'product page' it says "Welcome 'username' " and that part works fine.

     

    What I'm trying to add to the page for a list of the users $rows in a MySQL db to show on the page also.

     

    This is the code I'm using welcome or kick the user. (this one works fine)

    <?php 
    if(!$_SESSION['username'] && !$_SESSION['password']) {
    echo '<span style="border: #000 1px solid; background-color: #CCCCCC">
         <center>Welcome, <b>'.$username.'</b>  
         Redirecting you....</center></span>
         <meta http-equiv="refresh" content="2;URL=pass/index.php" />';
      }
    else { echo 'Welcome  '.$_SESSION['username'].'';
    }?>

    This is the code I trying to use that'll pull the info from the db

    <?php 
    $query = "SELECT * FROM images WHERE user="$_SESSION[.'username'.]" Order By id";
    
    include("config.php");
    
    $result = mysql_query($query) or die(mysql_error());
    
    mysql_close();
    
    $output = "
    <html>
    <body>
    <table>
    
    <thead>
    <td>Id/Order</td>
    <td>Address</td>
    </tr>
    </thead>
    ";

     

    I might mention that the 2nd bit of code works fine when I hard code in a User's ID...so I know that it's seeing the db, it just when I try to re-use the variable of username that I get this error.

    Unknown column 'username' in 'where clause

    Any suggestions would be great.

×
×
  • Create New...

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.