Hmmm. echo "<td><. $row['urladdress'] . </td>";
That line there doesn't quite look right. I'm not sure if you pasted this out directly or not. What's your reasoning for the table in the script? If I were going to use this as an http interface I would likely just use <br> tags to put them all in a nice list that livecode could process easily. The syntactcaly correct version of that echo would be. echo "<td>" . $row['urladdress'] . "</td>"; Also I believe you have an extra orphan </td> in the last line of the script you posted. You are getting something back from the url so livecode's url commands are fetching the right stuff, and you say this query works fine when peeked at from a browser window. I'd look at your loop a little closer. Andrew On Mon, Sep 23, 2013 at 12:20 AM, Earthednet-wp <proth...@earthednet.org>wrote: > John, > I use post and php for remote MySQL database interaction. To use the LC > MySQL commands directly, you have to open permissions to the database to > the world (assuming your app accesses it). This makes an extremely insecure > system. You can open an ssh tunnel using shell commands, but I find the php > solution more to my liking. > Good luck, > Bill > > William Prothero > http://es.earthednet.org > > On Sep 22, 2013, at 8:42 PM, JOHN PATTEN <johnpat...@me.com> wrote: > > > 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 > > _______________________________________________ > 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 > -- Regards, Andrew Kluthe and...@ctech.me _______________________________________________ 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