I tried to joining two table but getting error Undefined index: ID in /var/www/html/demo/Project/update.php below is my query.
Code: Select all
select baltimore.DATE,baltimore.JOBNAME,baltimore_description.DESCRIPTION,baltimore.TIME,baltimore.INITIALS from baltimore,baltimore_description where baltimore.ID=baltimore_description.ID && DATE='".$search."'";
my sample table has a row "DATE" , and from date is my condition (want to fetch a records for the particular date ), hope you all understand.
Please guys tell me what i did wrong,and how could i avoid this error.