Hi Terry,
Thank you for your reply.
Ofcourse I've searched through the KB and the forum, but whatever I try, I can't get it to work. If I create a separate PHP file (
www.webserver-install.com/digitaalcentrum/test.php) and put my code in it, it works. But I'm not able to translate it to Breezingforms.
Jurgen.
<?php
$link = mysql_connect("localhost", "root", "1979N1");
mysql_select_db("digitaalcentrum", $link);
$query = "SELECT title, ordering FROM jos_content WHERE catid=36 ORDER BY jos_content.ordering ASC";
$results = mysql_query($query, $link) or die("Error performing query");
if(mysql_num_rows($results) > 0){
echo("<select name=\"selectItem\">");
while($row = mysql_fetch_object($results)){
echo("<option value=\"$row->record_id\">$row->title</option>");
}
echo("</select>");
}
else{
echo("<i>No values found</i>");
}
?>