Search found 7 matches
- Mon Jan 06, 2014 9:29 am
- Forum: Databases
- Topic: [help] MySQL FTP server error
- Replies: 5
- Views: 5261
Re: [help] MySQL FTP server error
I use 000webhost.com as hosting for my database and they don't allow remote access connection on databases unless we pay them http://www.000webhost.com/faq.php?ID=27 About the username and database name, Yes. That's unfortunate... But how can you connect remotely to your database, if... the hosting...
- Mon Jan 06, 2014 9:10 am
- Forum: Databases
- Topic: [help] MySQL FTP server error
- Replies: 5
- Views: 5261
Re: [help] MySQL FTP server error
-check if you have a web "control panel" like CPanel for instance -if yes, then check for "remote MYSQL" : be sure to have your IP address as host, or the wild card "%" (if you want to allow any IP address to connect to your MySQL database) -if you don't have CPanel, then you need to check the priv...
- Mon Jan 06, 2014 4:17 am
- Forum: Databases
- Topic: [help] MySQL FTP server error
- Replies: 5
- Views: 5261
[help] MySQL FTP server error
I always got this error "cannot connect to mysql server on mysql13 . 000webhost . com" since I use webhost as my database server. put "mysql13 . 000webhost . com" (*no spaces) into tDatabaseAddress put "a9416334_pco" into tDatabaseName put "a9416334_pco" into tDatabaseUser put "urbandub123" into tDa...
- Sun Jan 05, 2014 10:17 am
- Forum: Databases
- Topic: $mysql_fetch_array value in LiveCode
- Replies: 6
- Views: 4962
Re: $mysql_fetch_array value in LiveCode
Thank you sir bangkok.


- Sun Jan 05, 2014 10:14 am
- Forum: Databases
- Topic: $mysql_fetch_array value in LiveCode
- Replies: 6
- Views: 4962
Re: $mysql_fetch_array value in LiveCode
Welcome. You should take an easier way with only 1 MySQL query. put "select teacherID from teachers where teacherUsername='"&field "FieldUsername"&"' and teacherPassword='"&field "FieldPassword"&"'" into tSQL put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tResult if tResult is not empty th...
- Sun Jan 05, 2014 10:12 am
- Forum: Databases
- Topic: $mysql_fetch_array value in LiveCode
- Replies: 6
- Views: 4962
Re: $mysql_fetch_array value in LiveCode
Hi markdub, Welcome to the forum :) Does anything get placed in the variables? Your code looks correct, what happens if you place "answer the result" after each query? Simon if put answer tteacherID to it. it will retrieve all the id. i think i shuould put check it first put revDatabaseQuery "Selec...
- Sun Jan 05, 2014 9:39 am
- Forum: Databases
- Topic: $mysql_fetch_array value in LiveCode
- Replies: 6
- Views: 4962
$mysql_fetch_array value in LiveCode
Hello Everyone. It's my first time to make a thread here in runrev forums. I would like to ask how to select or check a specific data(ex. username and password) Just like in a simple login module. here is my code. on mouseUp global gConnectionID global tteacherID local tUsername local tPassword put ...