title: Print Data from database in django
body: <p>I want to display data of two joined tables with a foreign key in django ,i have set it all up but it isn't displaying anything , here are my files:</p>
  
  <p>models.py:</p>
  
  <pre><code>from django.db import models
  from django.utils.encoding import smart_unicode
  
  class Course (models.Model):
  Course_name=models.CharField(max_length=120,null=False,blank=False)
  course_id=models.AutoField(primary_key=True)
  course_idtomatch=models.IntegerField(max_length=2)
  
  def __unicode__(self):
      return smart_unicode(self.Course_name)
  
  class Subjectsnames(models.Model):
  subject_name=models.CharField(max_length=50)
  course=models.ForeignKey(Course)
  
  
  def List item__unicode__(self):
      return smart_unicode(self.subject_name)
  </code></pre>
  
  <p>views.py:</p>
  
  <pre><code>from django.shortcuts import render
  from django.shortcuts import render_to_response
  from django.template import RequestContext
  from .models import Subjectsnames
  from .models import Course
  
  
  def Subjects(request):
  Subject = Subjectsnames.objects.get(id=id)
  
  subjects_data = {
      "subjects_names":Subject
  }
  
  print subjects_data
  return render_to_response("code.html",subjects_data,context_instance=RequestContext(request))
  </code></pre>
  
  <p>code.html:</p>
  
  <pre><code>&lt;html&gt;
  
  {% for name in Subjectsnames %}
  Name:{{name.subject_name}}
  Id:{{name.id}}
  {% endfor %}
  
  &lt;/html&gt;
  </code></pre>
  
  <p>And i have these data in my database:</p>
  
  <p><strong>Subjectsnames:</strong></p>
  
  <pre><code>+----+-----------------+-----------+
  | id | subject_name    | course_id |
  +----+-----------------+-----------+
  |  2 | Organic         |         1 |
  |  3 | inorganic       |         1 |
  |  4 | thermodynacmics |         2 |
  |  5 | vectors         |         2 |
  |  6 | trigo           |         3 |
  |  7 | algebra         |         3 |
  |  8 | relational      |         3 |
  |  9 | c++             |         4 |
  | 10 | c#              |         4 |
  +----+-----------------+-----------+
  </code></pre>
  
  <p><strong>Course:</strong></p>
  
  <pre><code>+-------------+-----------+------------------+
  | Course_name | course_id | course_idtomatch |
  +-------------+-----------+------------------+
  | chemistry   |         1 |                1 |
  | pyhics      |         2 |                2 |
  | maths       |         3 |                3 |
  | computers   |         4 |                4 |
  +-------------+-----------+------------------+
  </code></pre>
  
  <p><strong>Ignore course_idtomatch</strong></p>
  
  <p>As much as i know, i might have done something wrong in for loop in code.html.
  If anyone knows please help me in solving it, Thanks in advance .</p>
  
  <p>I have updated my views.py something like this :</p>
  
  <pre><code>from django.conf import settings
  settings.configure()
  from django.shortcuts import render, render_to_response, RequestContext
  
  from django.db import models
  from .models import Course
  from .models import Subjectsnames
  
  def Subjects(request):
  Subject = Subjectsnames.objects.get(id=id)
  
  subjects_data = {
      "subjects_names":Subject
  }
  
  print subjects_data
  return render_to_response("code.html",subjects_data,context_instance=RequestContext(request))
  
  
  print Subject
  </code></pre>
  
  <p>but now when i run python views.py on terminal i get an error like:</p>
  
  <pre><code>Traceback (most recent call last):
  File "views.py", line 7, in &lt;module&gt;
  from .models import Course
  ValueError: Attempted relative import in non-package
  </code></pre>