Raw SQL results

[®ed Eye Media - ®ichard Grove]

Hopefully someone can help.

If you query a mysql database with a command line, you get results.
eg: select * FROM table WHERE foo='bar' //would produce
+------------+
| foo |
+------------+
| bar |
+------------+
1 row in set (0.00 sec)

Is there anyway to use php to output this raw sql result?
I would simply like to echo out the whole lot (above)

Regards
Richard Grove

[rush]

"®ed Eye Media - ®ichard Grove" <in**@redeyemedia.co.uk> wrote in message
news:40***********************@mercury.nildram.net ...

Hopefully someone can help.

If you query a mysql database with a command line, you get results.
eg: select * FROM table WHERE foo='bar' //would produce
+------------+
| foo |
+------------+
| bar |
+------------+
1 row in set (0.00 sec)

If you need exactly that appearance, (wit -- + and |)I think you could
call from php shell command for mysql, and then capture output from it and
replace newlines with <br>. Look-up in manual for excuting shell commands.

rush
--
http://www.templatetamer.com/

[Pedro Graca]

®ed Eye Media - ®ichard Grove wrote:
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106

If you query a mysql database with a command line, you get results.
eg: select * FROM table WHERE foo='bar' //would produce
+------------+
| foo |
+------------+
| bar |
+------------+
1 row in set (0.00 sec)

Is there anyway to use php to output this raw sql result?
I would simply like to echo out the whole lot (above)

not tested on Windows

<?php
$data = `echo "select * from database.table where foo='bar';" | mysql -uusername -ppassword -t`;
echo "<pre>$data</pre>\n";
?>
 

--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[®ed Eye Media - Richard Grove]

"Pedro Graca" <he****@hotpop.com> wrote in message
news:c0*************@ID-203069.news.uni-berlin.de...

®ed Eye Media - ®ichard Grove wrote:
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106

If you query a mysql database with a command line, you get results.
eg: select * FROM table WHERE foo='bar' //would produce
+------------+
| foo |
+------------+
| bar |
+------------+
1 row in set (0.00 sec)

Is there anyway to use php to output this raw sql result?
I would simply like to echo out the whole lot (above)

not tested on Windows

 <?php
 $data = `echo "select * from database.table where foo='bar';" |

mysql -uusername -ppassword -t`;

 echo "<pre>$data</pre>\n";

 ?>