I'm recieving the above error when I try to run this code, I have tried multiple solutions, using fetch_array too:
$conn = mysql_connect('localhost', '-----', '-----','-----')
or die('Error connecting to mysql');
$sql = "SELECT * FROM Subject";
$result = mysql_query($sql);
$row=null;
echo "<table>";
while( $row = $mysql_fetch_assoc[$result]){
echo "<tr><td>";
echo $data['SubjectNo'];
echo "</td><td>";
echo $data['SubjectName'];
echo"</td></tr>";
}
echo "</table";
echo"urnan";
?>
There is an error in the line
while( $row = $mysql_fetch_assoc[$result]){
mysql_fetch_assoc is a PHP function, not a variable. So no need to put a $ sign in front of it.
So it should read
while( $row = mysql_fetch_assoc($result)){
Error is clear undefined variable means you are using a variable that not defined anywhere in your code.
What is the issue in your code?
You are using $mysql_fetch_assoc as a variable that is not defined in your code.
More important, $mysql_fetch_assoc it not equal to mysql_fetch_assoc as my other mate mentioned in comments.
Modified Code:
This should be use as:
while( $row = mysql_fetch_assoc($result)){
// your stuff
}
And second issue in you code is these brackets [] it should be ()
Side Note:
I suggest you to use mysqli_* or PDO instead of mysql_* extension because its deprecated and not available in PHP 7.
References from PHP Manuals:
$mysql_fetch_assoc!==mysql_fetch_assoc....(the$makes a difference) - but you shouldn't be using the MySQL extension anyway..... it's 2016 now, not 2006