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."'";
above query has a two table sample & demo, from demo table i only want to fetch single row demo_description.DESCRIPTION, and where condition takes the input from text box and that input is in the date format.
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.