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:
Any ideas? I am a novice when it comes to PHP so it coulde be something simple.
Here is my error:
Parse error: syntax error, unexpected '"' in C:\wamp\www\test1.php on line 20
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';