[Year 12 SofDev] php mysql error

[WEIR Andrew]

Dear all,
One of my students has come across the following error in MYSQL when
trying to relate two tables together.
I can't seem to find an explanation for him.

Is anybody able to give me some ideas of what I am looking at.

Basically they need to relate customerID from one table to another. This
is similar to what students did as part of the learning activities in
Kevorks PHP book but I have not come across the error before.

I have already checked the permissions for each user and they are fine.
But out of the class of six only 2 get this error the others seem to be
fine. That is their relationships are in place.

I am thinking it is a rather simple fix (as most things are) but just
can't see it.

Regards 
Andrew Weir




Andrew Weir

Information Technology Co-ordinator

 

Thomas Carr College

35 Thomas Carr Drive,

Tarneit, VIC 3029

(P) (03) 8734 2566

(F) (03) 9748 4388

(E) andrew.weir at thomascarr.vic.edu.au

 

IMPORTANT! This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Thomas Carr
College does not represent or warrant that the attached files are free
from computer viruses or other defects. The attached files are provided,
and may only be used, on the basis that the user assumes all
responsibility for any loss, damage or consequence resulting directly or
indirectly from the use of the attached files, whether caused by the
negligence of the sender or not. Any representations or opinions
expressed in this email are those of the individual sender, and not
necessarily those of Thomas Carr College.

Please consider the environment before printing this email 

 



-------------- next part --------------
A non-text attachment was scrubbed...
Name: error 121.jpg
Type: image/jpeg
Size: 149676 bytes
Desc: error 121.jpg
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20080813/bfb61bc5/error121-0001.jpg