[Year 12 SofDev] php mysql error

[WEIR Andrew]

Dear all
Seems that the issue is with students not using the same data types
across tables.
I redid the task myself and again had no error once I had data type set
correctly so thanks to John, Shane and others who responded.
Andrew 

-----Original Message-----
From: sofdev-bounces at edulists.com.au
[mailto:sofdev-bounces at edulists.com.au] On Behalf Of WEIR Andrew
Sent: Wednesday, 13 August 2008 11:22 AM
To: Year 12 Software Development Teachers' Mailing List
Subject: [Year 12 SofDev] php mysql error

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 

 



_______________________________________________
http://www.edulists.com.au
IT Software Development Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html  -
VITTA Victorian Information Technology Teachers Association Inc