Search found 7 matches

by markdub
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...
by markdub
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...
by markdub
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...
by markdub
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.
:o
by markdub
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...
by markdub
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...
by markdub
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 ...