I get error "Parse error: syntax error, unexpected T_VARIABLE..

[DougP]

full Error as follows:

Parse error: syntax error, unexpected T_VARIABLE in c:\Inetpub\

http://wwwroot\mydb.php

on line 10

here is my code

<?php
// Connecting, selecting database
$link = mysqli_connect('localhost:3306', '', 'mysql1', 'test')
   or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM sample'
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

any ideas

DougP, MCP, A+

 

[VBakias]

Hello again,

i can't aswear yet but i have found something.

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

Shouldn't you have used == instead of = ?
= is for assigning values
== is for checking a variables value
=== is @#$% , i know the word only in my language

 

[WoodyRoundUp]

No, it's not that one.
Normally this statement means that there is a missing ";".

This code is the problem.

$query = 'SELECT * FROM sample'

It should be:

$query = 'SELECT * FROM sample';