Displaying data (Please Help)

[Daddy]

what i am trying to do is put the data returned from mysql into the traditional command line format on a web page like this:

+------------+------------+
| field1 | field2 |
+------------+------------+
| result1 | result2 |
+------------+------------+

am i mistaken, or is there a php function that does this??

[edwardsbc]

Hmm. Doesn't seem to be an equivalent to [man]odbc_result_all()[/man] for the mysql functions.

You could actually just run the mysql client and capture the output. Check out the program executions functions at the manual: PHP Manual

[Daddy]

thanks for replying edward, i may be wrong, but i thought there was a function that allowed you to print the raw results to the screen just as it appears in mysql.

[Crix_Talra]

couldnt you use the passthru function to run the command on the server?

$sql = Passthru("<commandhere>");
         echo $sql;