Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Mysql help
Name: Nirav Date: November 14, 2002 at 13:12:40 Pacific OS: win98 CPU/Ram: p3
Comment:
Hi: Im doing a project using PHP & MYSQL. i have a question regarding that. i have 2 tables in my database EMPLOYEE
Name: Don Arnett Date: November 14, 2002 at 14:08:48 Pacific
Reply:
That's not a problem since they are separate tables. The primary key applies only to the table that it is in.
If you do a query that involves both tables, you will have to differentiate which table's EMP_ID you mean.
Let's say that you wanted to get the password and employee name for a given id:
select emp_name, password from table1, table2 where table1.emp_id = table2.emp_id and table1.emp_id = "12345";
You don't HAVE to put the table name on 'emp_name' or 'password' since they exist in only one of the tables. Many times I do add the table name when more than one table is involved for documentation purposes.
Summary: Hi. i downloaded MYSQL and PHP. i get mysql to work.. but im not sure how to practice using php. where to i put all the codings into.. how do i get it to work etc.. can someone please help so i can ge...
Summary: The script that follows is intended to run when it is invoked by Paypal's IPN (Instant Payment Notification) but I have (somehow) broken it and despite repeated attempts cannot fix it. Can anyone P...
Summary: "It is my understanding that one needs to setup or have access to a database on their server and then the phpBB install program sets up the database tables." Yes, you need access to a database and a d...
0 
