Query Result (MySQL)

[Namadoor]

After performing a MySQL database query in PHP, is there a way to get the MySQL result just like what MySQL gives you after doing a query from a command line?

For example, if you said CREATE TABLE test
(id int(11) auto_increment primary key,
name varchar(255)); on the command line MySQL would give you Query OK, 0 rows affected (0.01 sec). I want to get this text in a PHP varible. Is there a way to do this?

Thanks for your help.

[elementaluk]

yup, but you'll most likely have to write it yourself.

mysql_affected_rows() (returns affected rows)

mysqlerror() & mysqlerrno() (returns any errors)

Not too sure about the time taken though. I'm sure the PHP manual or MySQL manual has something regarding that.