doing a query

[Anon]

I have a table called "stock" with rows called "Make | Model | Color" what is the query to send to mysql to find al entrys in color that have the word dublin, and then display the values for the other two rows.

Also how would i launch that from a web page.

Thanks for your help

[bengan]

The query would be something like

SELECT make, model FROM stock WHERE color LIKE '%dublin%'

The second part (wery plain):

<?php

$host = ""; // your hostname
$user = ""; // your username
$password = ""; // your password
$database = "" // your databasename

$connection = mysql_connect($host, $user, $password);

mysql_select_db($database, $connection);

$result = mysql_query("SELECT make, model FROM stock WHERE color LIKE '%dublin%'", $connection);

while ($row = mysql_fetch_row($result)) {
echo $row[make]." ".$row[model]."<br>";
}

?>

[Anon]

thanks that worked. Is that second part just put in a html file or is it saved as a php3 file and called from a html file. If the later what is the tag.

Once again thnks