What is the significance of using the mysql_num_fields function in PHP when working with MySQL databases?

The mysql_num_fields function in PHP is significant when working with MySQL databases as it allows you to retrieve the number of fields (columns) in a result set from a query. This information is crucial for tasks such as dynamically generating HTML tables or iterating through query results. By using mysql_num_fields, you can accurately determine the structure of your query results and handle them accordingly in your PHP code.

// Connect to MySQL database
$conn = mysqli_connect("localhost", "username", "password", "database");

// Execute query
$query = "SELECT * FROM table";
$result = mysqli_query($conn, $query);

// Get the number of fields in the result set
$numFields = mysqli_num_fields($result);

// Output the number of fields
echo "Number of fields: " . $numFields;