$query = "SELECT * FROM DUAL;"; $query .= "SELECT name FROM hotel.city";
/* execute multi query */ if ($maxdb->multi_query($query)) { do { /* store first result set */ if ($result = $maxdb->use_result()) { while ($row = $result->fetch_row()) { printf("%s\n", $row[0]); } $result->close(); } /* print divider */ if ($maxdb->more_results()) { printf("-----------------\n"); } } while ($maxdb->next_result()); }
$query = "SELECT * FROM DUAL;"; $query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */ if (maxdb_multi_query($link, $query)) { do { /* store first result set */ if ($result = maxdb_use_result($link)) { while ($row = maxdb_fetch_row($result)) { printf("%s\n", $row[0]); } maxdb_free_result($result); } /* print divider */ if (maxdb_more_results($link)) { printf("-----------------\n"); } } while (maxdb_next_result($link)); }
/* close connection */ maxdb_close($link); ?>
The above examples would produce the following output:
Warning: maxdb_multi_query(): -3008 POS(19) Invalid keyword or missing delimiter <...>