Thanks Dave!
That was my problem. I have to commit that to long term memory now…I got a
faint Déjà vu after reading your reply :(
Thank Again!
Déjà vu
On Sep 23, 2013, at 3:03 PM, Dave Cragg dave.cr...@lacscentre.co.uk wrote:
But in a lc code stack with a button and two flds I get:
You
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
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
Hi Andrew, et al…
Still no luck. I've included the complete php script below:
?php
require_once('config.php');
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
$db = mysql_select_db(DB_DATABASE);
But in a lc code stack with a button and two flds I get:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '' at line 1
Button's script:
on mouseUp
post cd fld 1 to URL
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
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