MozgafD1
Last Activity: Jul 15 '15, 08:42 AM
Joined: Jul 12 '15
Location:
-
Thanks for reply, but this gives an alert even if the Php file has nothing to echo. Is there a way so that only when the if statement is true then echo is sent and alert is opened? -
Hey,
depending on what and how you use the information, you have two options.
option 1 have a table for each building. This will allow you to make the room number as primary key. to make sure there is no duplicates.
option 2 have everything in one table with all data. There would be 15000 records roughly which access can handle with ease but not other applications. you would also need add another column for ID to be a...Leave a comment:
-
how many buildings and how many rooms against them?
you could have something like this...
Buildings Rooms Users more details....
Bd1 Rm1 Usr1,User2
Bd1 Rm2 Usr1,User5
Bd1 Rm3 Usr1,User2
Bd1 Rm4 Usr1,User6
Bd2 Rm1 Usr4,User6
Bd2 Rm2 Usr1,User2...Leave a comment:
-
How to pop up an alert from a mysql result?
Hi, I am looking around this all day but cant find out a way.
Basically I have a html page with Jquery function that send data to a php file to retrieve data from a database.
Retrieving data to the html page works fine.
What I am trying to do is run a comparison between the value that is fetched from database and a set limit.
This is what I have so far.
Html file ...
No activity results to display
Leave a comment: