Php Error

Having trouble linking a mysql table/database through php, I have all my open, close and config php files setup correctly.

Here is my error:

PHP:

<?php

  include 'config.php';
  include 'opendb.php';

$query="SELECT User_Name,User_ID,Staff_ID,Problem,Problem_ID,User_email,Staff_email, FROM itsupport";
$result=mysql_query($query);
while($row=mysql_fetch_array($result, MYSQL_ASSOC))
    {
                 echo "User_Name :{$row[' User_Name ']} <br>" .     <!--LINE 20--> 
                    "User_ID : {$row[' User_ID ']} <br>" . 
                   "Staff_ID :{$row[' Staff_ID ']} <br>".
                       "Problem : {$row[' Problem ']} <br><br>".
                      "Problem_ID :{$row[' Problem_ID ']} <br>".
                    "User_email :{$row[' User_email ']} <br>".
                      "Staff_email :{$row[' Staff_email ']} <br>";
                      
                                        
        } 
        
        include 'closedb.php';


Any ideas? I am a novice when it comes to PHP so it coulde be something simple.

 

The error is probably because of the white-space in the array keys.

PHP:

while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "User_Name :{$row['User_Name']} <br>" .
    "User_ID : {$row['User_ID']} <br>" . 
    "Staff_ID :{$row['Staff_ID']} <br>".
    "Problem : {$row['Problem']} <br><br>".
    "Problem_ID :{$row['Problem_ID']} <br>".
    "User_email :{$row['User_email']} <br>".
    "Staff_email :{$row['Staff_email']} <br>";                        
}

 

Hi, Thanks for the suggestion, but the error still exists???

 

Please post the code you are using.

 

It is basically the same as the first time I posted just without the spaces that you said to get rid of.
Thanks for taking the time to look at it

PHP:

   <?php

  include 'config.php';
  include 'opendb.php';

$query="SELECT User_Name,User_ID,Staff_ID,Problem,Problem_ID,User_email,Staff_email, FROM itsupport";
$result=mysql_query($query);
while($row=mysql_fetch_array($result, MYSQL_ASSOC))
    {
                 echo "User_Name :{$row['User_Name']} <br>" .     <!--LINE 20--> 
                    "User_ID : {$row['User_ID']} <br>" . 
                   "Staff_ID :{$row['Staff_ID']} <br>".
                       "Problem : {$row['Problem']} <br><br>".
                      "Problem_ID :{$row['Problem_ID']} <br>".
                    "User_email :{$row['User_email']} <br>".
                      "Staff_email :{$row['Staff_email']} <br>";
                      
                                        
        } 
        
        include 'closedb.php'; 

 

Hmm... I tried the code and it worked fine. Make sure you remove <!--LINE 20--> before running the code.

 

lol, I only put in "Line 20" in my post to let you know where it is. I have tried the exact code on 3 different machines and keep getting the same error

 

1. Make sure the page is not cached (hit CTRL + F5).

2. If that doesn't work than use this code:

PHP:

    echo 'User_Name : '.$row['User_Name'] .'<br>' .
    'User_ID : '.$row['User_ID'] .'<br>' .
    'Staff_ID : '.$row['Staff_ID'] .'<br>'.
    'Problem : '.$row['Problem'] .'<br><br>'.
    'Problem_ID : '.$row['Problem_ID'] .'<br>'.
    'User_email : '.$row['User_email'] .'<br>'.
    'Staff_email : '.$row['Staff_email'] .'<br>';

 

you can also get rid of the comma after Staff_email in your select statement

 

<!-- --> is the HTML comment tag - PHP uses // for single line comments or /* comment goes here*/ for multiline comments. It's best to use these when posting extra information in your code so everyone knows it's not that causing the error