Is there a way to print to the browser from a mysql query?

[shedokan]

Is there a way to print to the browser from a mysql query?

 

I heard that on the mysql command line you can do:

mysql> print "something"

 

so is there a way to do it from mysql, so i don't have to get a mysql array and echo it?

 

thanks.

[Maq]

Can you explain exactly what you're trying to accomplish so we can provide the best solution for your situation?

[shedokan]

I am currently doing this:

<?php
$r=mysql_query('SELECT FROM names WHERE id='.$id);
$a=mysql_fetch_array($r,MYSQL_ASSOC);
?>
Your Name Is <?=$a['name']?>

 

Where $id is the user's id.

 

so I am looking for a way to do it easier.

[BLaZuRE]

Is there a way to print to the browser from a mysql query?

 

I heard that on the mysql command line you can do:

mysql> print "something"

 

so is there a way to do it from mysql, so i don't have to get a mysql array and echo it?

 

thanks.

 

The MySQL command line won't do that for you.  Think of it as similar to the Windows command prompt or the Linux terminal.  MySQL is just like any other language, verbal (English, French) or computer (PHP, C++).  You have to learn the language to use its functionality, there's no shortcut.

[shedokan]

I'm not asking for a shortcut, I am asking for a different way of doing something.

 

[BLaZuRE]

I'm not asking for a shortcut, I am asking for a different way of doing something.

To my knowledge, there's no "easier" way to do this.

Basically, you have to:

1) Get and choose the data from the database (which you did using a MySQL query)

2) Format your data so that PHP can handle it (which you did by saving only the first row into a variable)

2) Output the data into a presentable format (which you did by echo'ing)

 

If you're looking for alternatives though, you may want to look at mysql_fetch_assoc() or mysql_fetch_row().

Please further clarify your question if it wasn't answered.

[fenway]

Well, from the CLI, you can specify how you want your output to be show -- either with \G or with pager.