Welcome! Log In Create A New Profile

Advanced

student_course table - year and fmark

Posted by kreason_77840070 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
student_course table - year and fmark
May 16, 2013 08:49PM
Ok so my application is finished but I have these fields in the database and im doing nothing with them!?

what are you guys doing with these fields? the tutorial letter doesnt speak about this at all.

are they being updated in the edit student page>?>?

http://capetown-airport.co.za/
Re: student_course table - year and fmark
May 17, 2013 02:57AM
I think the 'year' goes with the date the student registered or was registered as the case may be. The only field that is left dormant is the 'fmark'(final mark); in fact, it's stated there as 'not used'.

78026962 afojonny
avatar
Mac
Re: student_course table - year and fmark
May 17, 2013 09:31AM
This is to to get you to insert/update/edit a field with no value as it impacts on your sql query
Re: student_course table - year and fmark
May 17, 2013 09:45AM
ohh-ohhh - I just assumes we leave it out. I didn't even include it on my insert statement.

I will have to modify my insert statement.
Re: student_course table - year and fmark
May 17, 2013 09:59AM
mmmm update/edit as well? that means we will have to add a field somewhere? is that necessary?
Re: student_course table - year and fmark
May 17, 2013 11:50AM
Hi Mac

Sorry, can you please be more clear with your response. i don't understand what you mean. if it has no value, why cant we just leave it blank? or should we be adding a default value?

http://capetown-airport.co.za/
Re: student_course table - year and fmark
May 17, 2013 02:23PM
Mac,

Please shed more understanding. I thought the year row is for when student register, and nothing more. Then the fmark should be left blank. Guess i was wrong.

78026962 afojonny
Re: student_course table - year and fmark
May 18, 2013 07:23PM
and isnt edit/update the same thing ? confused smiley I hope to get a clear response about this on Monday so i can code it as required and upload it. This is the only thing thats not done now

http://capetown-airport.co.za/
Re: student_course table - year and fmark
May 18, 2013 07:37PM
Yeah, they're the same but when you're querying your database you use "UPDATE table_name..." Of-course, i'm sure you know that already.

Do you grab?

78026962 afojonny
Re: student_course table - year and fmark
May 18, 2013 08:16PM
if the marks field has to be updated, i assume the lecture will have to do this. lecturers are only able to generate course profiles which means this will have to be updated somewhere in list.php or pages linked to this? - not the edit student page

http://capetown-airport.co.za/
Re: student_course table - year and fmark
May 18, 2013 08:54PM
Well, the extra info from the tutorial letter says "fmark(not used). So i guess it's just meant to appear in the database. I don't think there should be a reference to it in PHP; except Mac says otherwise.

78026962 afojonny
avatar Re: student_course table - year and fmark
May 20, 2013 08:26AM
I also saw that and did not implement it in mine.



afojonny Wrote:
-------------------------------------------------------
> Well, the extra info from the tutorial letter says
> "fmark(not used). So i guess it's just meant to
> appear in the database. I don't think there should
> be a reference to it in PHP; except Mac says
> otherwise.
Re: student_course table - year and fmark
May 20, 2013 03:48PM
Mac please give us some clarification ?

http://capetown-airport.co.za/
Sorry, only registered users may post in this forum.

Click here to login