Re: Mysqli vs mysql

[Barry Galbraith]

Your code

/* Display results */ 
echo "<table border='1'><thead><tr>"; 
for($i = 0;$i < mysql_num_fields($result);$i++) 

{ 
echo "<th>".mysql_field_name ($result,$i) . 
"</th>"; 
}

You have 2 mysql() functions there instead of mysqli. As you made the connection with mysqli() you have to use mysqli() functions on that connection.
Look up the php refman for mysqli() syntax http://php.net/manual/en/refs.database.vendors.php


As PB says, any reference that shows to use mysql() should be archived. You should use a reference for mysqli() (or PDO).

Good luck,
Barry.