[PHP-DB] how to get records from one table that are not in another table

hi all, can anyone pls help me out to make the query like.. if two tables have some comman records then how to find records from one table that are not in another table. eg... i have one table room type master (room_type_m) fields : room_type_id, room_type_name and other details and another

[PHP-DB] MySQL Session

I have just recently entered the world of PHP and MySQL. I'm used to code in ASP with Access databases and since I am not very familiar with PHP, I have run into a problem, which is probably quite easy to solve: Connecting to the database requires a couple lines of code, which I would rather not

RE: [PHP-DB] MySQL Session

Hi welcome to php :) in general you can use an include at the beginning of each page ?php include('database_conn.php' ) ; $query = 'select * from table' $result = ($query, $link) ? -Original Message- From: Morten Twellmann [mailto:[EMAIL PROTECTED] Sent: 27 July 2003 13:01 To:

Re: [PHP-DB] MySQL Session

Here's how I do it using functional PHP programming (you may prefer using OO PHP which I don't bother with) : I include a generic functions file in each page. You could take it further, opening and closing the database connection for every query, but this way is more efficient if more than open

Re: [PHP-DB] how to get records from one table that are not in anothertable

Smita Manohar wrote: can anyone pls help me out to make the query like.. if two tables have some comman records then how to find records from one table that are not in another table. eg... i have one table room type master (room_type_m) fields : room_type_id, room_type_name and other details

RE: [PHP-DB] how to get records from one table that are not in another table

I'd suggest you pick up an SQL book or do some more reading if you don't understand that. -- ---John Holmes... John, Do you have a good book recommendation for MySQL.. I'm looking for more knowledge on improving my queries, etc. LEFT JOINS were completely unfamiliar (still are) until you

Re: [PHP-DB] how to get records from one table that are not in anothertable

Aaron Wolski wrote: Do you have a good book recommendation for MySQL.. I'm looking for more knowledge on improving my queries, etc. LEFT JOINS were completely unfamiliar (still are) until you helped me with my 3 query into 1 problem I had last week. I've heard that MySQL, Second Edition by Paul

Re: [PHP-DB] how to get records from one table that are not in another table

thanks John, i was knowing that LEFT JOIN would work, but i was not knowing exact syntax where to put IS NULL. anyway, thanks ! still problem is not sloved :-( as u suggested following query worked fine SELECT A.room_type_id, room_type_desc FROM room_type_m A LEFT JOIN hotel_room_type_d B ON

Re: [PHP-DB] how to get records from one table that are not in anothertable

Smita Manohar wrote: but there is one more criteria, hotel_id from table hotel_room_type_d should be equal to some value i modified it like this... SELECT A.room_type_id, room_type_desc FROM room_type_m A LEFT JOIN hotel_room_type_d B ON A.room_type_id = B.room_type_id WHERE B.room_type_id

[PHP-DB] need help with repeated regions

Plz could some one help me how to create an horizontal repeated region in a php page using a mysql database for showing thumbnail without using a expensive plugin such like MXlooper for dreamweaver MX. plz sent me help over mail [EMAIL PROTECTED] thx -- PHP Database Mailing List

[PHP-DB] Your E-Book

The Revolutionary Book Your Boss Doesn't Want You to Read ! Does an extra $500 to $1000 a week sound exciting? HINT: It's not what you think Dear Friend: Everybody is looking to make more money online, but the biggest problem is that VERY few things actually work. We have an exclusive

Re: [PHP-DB] how to get records from one table that are not in another table

heyy... i put second condition (after AND) in the wrong place.. it should be after LEFT JOIN ON not after WHERE... following is the correct query... SELECT A.room_type_id, room_type_desc FROM room_type_m A LEFT JOIN hotel_room_type_d B ON A.room_type_id = B.room_type_id AND B.hotel_id =