Also, as far as I know: $result = mysql_query("SELECT urladdress, urltitle FROM urllist WHERE docid = '$doccode'");
$doccode won't evaluate to anything but the string $doccode in this query because you have encased it in ' ' I believe. I'm not sure what version of PHP on-rev is using, but if it's one of the newer versions and you want to build a php based api for your database, I can't recommend this enough. http://net.tutsplus.com/tutorials/php/laravel-4-a-start-at-a-restful-api/ Regards, Andrew On Mon, Sep 23, 2013 at 8:28 AM, Andrew Kluthe <and...@ctech.me> wrote: > 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 > -- 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