LiveCode Forums.

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 ...

-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 ...

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 ...

Thank you sir bangkok.

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 ...

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 ...

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 ...