[SOLVED] Need to SELECT a record and echo

[nscherneck]

Whats the simplest way to select a record from a table that has three columns?  Thank you.

[Hybride]

SELECT record FROM table

Is that what you're looking for?

[nscherneck]

well yes, but how to echo the data that comes from that SQL command.

[js_280]

<?php

$con = mysql_connect("database host", "username", "password");

$query = "SELECT col_1, col_2, col_3 FROM table";

$result = mysql_query($query, $con);

while($data = mysql_fetch_array($result))
{
  echo($data['col_1'].' '.$data['col_2'].' '.$data['col_3'].'<br />');
}

?> 

 

You'll have to substitute your database login information, column names, and table name of course...

[nscherneck]

perfect, thank you!