I'm building a dynamic site that has 3 data bases. One DB contains all
of my store info ID#, Name, Address, Phone. Another DB contains member
info ID, Name, address, email,phone,etc...
The 3rd DB Tracks when a user logs in and logs out at a store. This DB
has the following columns Store ID, Member ID, log in time,log out
time, time in store.
The stores log in in the morning that starts a session-I need the
session to pull the store's info ID#, Name,etc... so when a user logs
in, in the store. The login page inserts the store ID, Store name, and
user ID into the 3rd DB.
There are a lot of stores how do I get the store variables to be
inserted into the DB?
Thanks in advance,
Greg 5 1758
The Cool Geek wrote: I'm building a dynamic site that has 3 data bases.
As I'm used to seen stupid solution in database design, the first
question is: Why?
And the second is: Is it possible to change it?
This DB has the following columns Store ID, Member ID, log in time,log out time, time in store.
Ok, this sounds like you are talking about an table. So I'm pretty much
confused. Do you know the difference between tables and databases and
are you sure you have 3 databases, not 3 tables in one database?
Answering to anything else is pointless before we know what you mean.
>I'm building a dynamic site that has 3 data bases. One DB contains all of my store info ID#, Name, Address, Phone. Another DB contains member info ID, Name, address, email,phone,etc...
Are we to assume that these 3 databases are at least potentially on
3 different hosts on 3 different continents under 3 different
administrations with 3 different operating systems with 3 different
database programs (e.g. MySQL, Oracle, and Postgres)?
Or do you mean that this data is in 3 different TABLES?
The 3rd DB Tracks when a user logs in and logs out at a store. This DB has the following columns Store ID, Member ID, log in time,log out time, time in store.
The stores log in in the morning that starts a session-I need the session to pull the store's info ID#, Name,etc... so when a user logs in, in the store. The login page inserts the store ID, Store name, and user ID into the 3rd DB.
PAGE? Is there a web server involved in this? And when you talk about
"session", do you mean a login to the MySQL server, or a PHP-style
session at the web server?
There are a lot of stores how do I get the store variables to be inserted into the DB?
You generally insert data into a SQL database with a SQL INSERT query.
Gordon L. Burditt
Gordon Burditt wrote: I'm building a dynamic site that has 3 data bases. One DB contains all of my store info ID#, Name, Address, Phone. Another DB contains member info ID, Name, address, email,phone,etc...
Are we to assume that these 3 databases are at least potentially on 3 different hosts on 3 different continents under 3 different administrations with 3 different operating systems with 3 different database programs (e.g. MySQL, Oracle, and Postgres)?
Or do you mean that this data is in 3 different TABLES?
The 3rd DB Tracks when a user logs in and logs out at a store. This DB has the following columns Store ID, Member ID, log in time,log out time, time in store.
The stores log in in the morning that starts a session-I need the session to pull the store's info ID#, Name,etc... so when a user logs in, in the store. The login page inserts the store ID, Store name, and user ID into the 3rd DB.
PAGE? Is there a web server involved in this? And when you talk about "session", do you mean a login to the MySQL server, or a PHP-style session at the web server?
There are a lot of stores how do I get the store variables to be inserted into the DB?
You generally insert data into a SQL database with a SQL INSERT query.
Gordon L. Burditt
Sorry guys I really screwed this up. I'm new at this. I have 1 DB
with three tables. It is on a web server running MySQL and Php. When
the store logs in I would like to pull the store's info using a session
or a cookie. Then when the members check in and out the store's ID#,
Name, and address from the session/cookie are inserted into the table
with the member information in the same row. I can get the members
information into the table but the variable I'm trying to use for the
stores doesn't insert any data into the table.
Apologies and Thanks.
The Cool Geek wrote: Sorry guys I really screwed this up. I'm new at this. I have 1 DB with three tables. It is on a web server running MySQL and Php. When the store logs in I would like to pull the store's info using a session or a cookie. Then when the members check in and out the store's ID#, Name, and address from the session/cookie are inserted into the table with the member information in the same row. I can get the members information into the table but the variable I'm trying to use for the stores doesn't insert any data into the table.
I'm still confused about the terms you use.
Is your problem that a query is failing? If so, what is the query and
what is the error message MySQL is producing from it.
If you don't know if the query is failing, check the result values from
php functions. By checking them you should find out what function call
fails to pinpoint the problem. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Shi Jin |
last post by:
Hi there,
I am now having a puzzle regarding what a function call actually does when
called.
I have a simple code to see what's going on. It is simply calling another
simple function from...
|
by: Jeronimo Bertran |
last post by:
Hello,
I am using a rendering aspx page to display a database image on an Image
control. When the database record is retrieved, I am saving the bitmap
to a session variable for the rendering...
|
by: MattC |
last post by:
I noticed when storing large amounts of information in the StateServer
Service that this does not increase in size, the worker process itself seems
to grow.
I set up a test case to try and prove...
|
by: Stu |
last post by:
Hi,
I want to be able to come up with some way
of navigating around a system that allows me to save certain screen info
(Say combo box setting) so that when returning to the screen from a link...
|
by: Anna |
last post by:
Hi,
I've got the same problem like many others: I need my Web Service to "push"
the data to its clients, ideally generate an event to which the clients
listen. Yes, I know that they are not...
| |
by: Bishop |
last post by:
Here is my situation. I'm building a web based store that will use the same
code base for every store using host headers to determine which data to
display. To prevent purchasing a SSL Cert for...
|
by: matt |
last post by:
hello,
i am having trouble doing something. when a user triggers a certain
event in my app, i need to initiate another web request to one of my
other webpages, programmatically. currently, i do...
|
by: Tarantulus |
last post by:
Hi,
ok, quick description of the problem, I'm trying to reference the postdata from some checkboxes. Unfortunately the checkboxes are dynamically generated therefore I don't know how many there...
|
by: itcassy |
last post by:
I would like to pull a random or alphabetical result on the home page
of a site and leave that same result on there for one week. The
closest example I have found online is Random Quote Version...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |