Hello All,
I have created the following PHP script which always returns more than one record with 3 fields per record...
Code:
<?php
$DBhost = $_POST['DBhost'];
$DBname = $_POST['DBname'];
$DBuser = $_POST['DBuser'];
$DBpass = $_POST['DBpass'];
$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBname,$connect);
$query = "SELECT CREW.Name, CREW.Service, RANK.Rank";
$result = mysql_query($query, $connect);
$Crew_Number = mysql_num_rows($result);
echo "&Crew_Number = " . $Crew_Number;
while ($row = mysql_fetch_array($result))
{
$FinalData =
"&CREW_Name = " . $row['Name'] .
"&CREW_Service = " . $row['Service'] .
"&CREW_Rank = " . $row['Rank'];
echo $FinalData;
}
mysql_close($db);
?>
This works fine when running the script on my webserver, but how can I display the data, record by record in my Opus Pro 5.5 publication.
For one record it is no problem when I use the Post Web Data action applied at a On Show trigger, but how do I get all the records one by one?!
Any help is highly appreciated...
Jan
Login
FAQ
Search
