Search found 41 matches
- Sun Sep 12, 2004 6:37 am
- Forum: Databases
- Topic: Search two or more tables
- Replies: 9
- Views: 633
Thanks for the reference, but it really didn't help my PHP problem. Can someone, in plain English, explain what each bit of that PHP code is doing? I can't tell what parts of the code need to be changed to suit my situation, or where the code gets placed on my page. mysql_select_db($database_connHP4...
- Fri Sep 10, 2004 10:04 pm
- Forum: Databases
- Topic: Search two or more tables
- Replies: 9
- Views: 633
- Thu Sep 09, 2004 1:11 pm
- Forum: Databases
- Topic: Search two or more tables
- Replies: 9
- Views: 633
Technically, there are no duplicate records as such. All are unique. Therefore the DISTINCT parameter has no effect on the output. Prior to including the new table via LEFT JOIN, there were 8 records in the database, one for each unique memno . After the join there are 11 records. Now, record 2 is a...
- Thu Sep 09, 2004 11:04 am
- Forum: Databases
- Topic: Search two or more tables
- Replies: 9
- Views: 633
- Thu Sep 09, 2004 8:47 am
- Forum: Databases
- Topic: Search two or more tables
- Replies: 9
- Views: 633
When I join the tables, I run into another problem, (besides the duplicates). The resulting display when there is no search being done, instead of showing all the records (including the duplcates added from the join) is only showing records that coincide with the data in the specialmem table. But, t...
- Thu Sep 09, 2004 7:42 am
- Forum: Databases
- Topic: Search two or more tables
- Replies: 9
- Views: 633
Search two or more tables
I'm not sure if this question belongs in this forum or the PHP Programming forum. I have a recordset called rs_members, that uses columns from a table called members. From this recordset, I set up simultaneous searches on columns for lastname, gender, eye color, hair color, age plus a few other colu...
- Wed Sep 08, 2004 6:17 am
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
- Tue Sep 07, 2004 11:45 pm
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
- Tue Sep 07, 2004 11:35 pm
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
- Tue Sep 07, 2004 11:14 pm
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
- Mon Sep 06, 2004 3:36 pm
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
- Mon Sep 06, 2004 1:44 pm
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
- Mon Sep 06, 2004 12:15 pm
- Forum: Databases
- Topic: Search all except...
- Replies: 12
- Views: 1091
Search all except...
I have a database with a newly added column called SINGER. The column can contain any of a dozen or so items (alto, soprano, etc.) selected from a dropdown list. One of those items is n/a , meaning that this person is NOT a singer. On the search form I want to add an option to search for singers by ...
- Thu Aug 12, 2004 9:31 am
- Forum: Databases
- Topic: Confused about default values when using WHERE statement.
- Replies: 50
- Views: 2008
- Wed Aug 11, 2004 7:53 pm
- Forum: Databases
- Topic: Confused about default values when using WHERE statement.
- Replies: 50
- Views: 2008