Forum Moderators: open
Can anyone tell me how to use EXPLAIN witin my PHP-Mysql code? I dont want to run it from mysql root, I want to use it within my PHP.. what will be the syntax to echo EXPLAIN results in my browser?
Regards
$stmt = "EXPLAIN SELECT * FROM table";
$rows = mysql_query($stmt);
if ($row = mysql_fetch_assoc($rows)) {
print '<pre>';
foreach ($row as $key => $value) {
print "$key: $value\n";
}
print '</pre>';
}
