[php]

$db_host = ‘localhost’;

$db_user = ‘nemja22_tokyodb’;

$db_pwd = ‘Dusan011’;

$database = ‘nemja22_tokyodb’;

$table = ‘nemja22_clients’;

if (!mysql_connect($db_host, $db_user, $db_pwd))

die(“Can’t connect to database”);

if (!mysql_select_db($database))

die(“Can’t select database”);

$result = mysql_query(“SELECT OBJECT_NAME FROM nemja22_clients WHERE SHOW_WEB=1 and TYPE=’Ugostitelj’; “);

if (!$result) {

die(“Query to show fields from table failed”);

}

echo “Reference ugostiteljski objekti<br>”;

while($row = mysql_fetch_row($result))

{

echo $row[0].”<br>”;

}

echo “<br>”;

 

$result1 = mysql_query(“SELECT OBJECT_NAME FROM nemja22_clients WHERE SHOW_WEB=1 and TYPE=’Maloprodaja’; “);

if (!$result1) {

die(“Query to show fields from table failed”);

}

echo “Reference maloprodajni objekti<br>”;

while($row = mysql_fetch_row($result1))

{

echo $row[0].”<br>”;

}

[/php]