Php Error

[jaybeeb]

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:

Parse error: syntax error, unexpected '"' in C:\wamp\www\test1.php on line 20

<?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.

 

[MMJ]

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

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

 

[jaybeeb]

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

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

 

[MMJ]

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

Please post the code you are using.

 

[jaybeeb]

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

  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';

 

[MMJ]

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

 

[jaybeeb]

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

 

[MMJ]

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

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

    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>';

 

[Mudley]

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

 

[TheRobatron]

I only put in "Line 20" in my post to let you know where it is.

<!-- --> 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