Hi All…
I would like to be able to pull data into a livecode project from an on-rev
mysql database. It currently works in a browser as a simple web app and is
built all on in php.
I thought I may be able to just use the post command, however when I try to
post some data to a php url that executes a query on the database and then
echoes back the results all I get in an "answer it" is the first header line,
"Assigned Resources," and no array results. Here is the abbreviated php code:
mysql_connect;
$result = mysql_query("SELECT urladdress, urltitle FROM urllist WHERE docid =
'$doccode'");
echo "<table border='1'>
<tr>
<th>Assigned Resources</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td><. $row['urladdress'] . </td>";
echo "</tr>";
}
echo "</td></table>";
This works fine in the browser, but I was hoping to use all these php database
connections in the web app within a stack and an iOS app. Any recommendations,
or should I abandon ship, and go in a different direction to access the mysql
data from within a lc stack?
Thanks in advance!
John Patten
SUSD
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
