Re: passing variables from one page to another

You're right--I did leave out that end quotation mark. Unfortunately, though, I'm still getting the same result after adding it. best, Matt ----- Original Message ----- From: Martin Clifford <MLC1@nrc.gov> To: <mgold1@gc.cuny.edu>; <php-db@lists.php.net> Sent: Monday, July 08, 2002 3:47 PM Subject: Re: [PHP-DB] passing variables from one page to another If that is your exact code, then you need to have an ending quote after the query is written. Like this: $query = "Select * from course, disc, instit, prof where course.CourseID = $CourseID and course.DiscID = disc.DiscID and course.InstitID = instit.InstitID and course.ProfID = prof.ProfID"; Martin >>> "Matthew K. Gold" <mgold1@gc.cuny.edu> 07/08/02 03:40PM >>> Hi Everybody, Please forgive the basic nature of this question--I have looked at the manual, but I found that much of it went over my head. I'm trying to create a second level of a website that displays course listings. The first level lists a bunch of courses. I'd like users to be able to click on the title of a course to go to a page that contains details about that course. From what I understand, I should do this by making the title of the course on the first page (courses.php) a link to the second page (courseinfo.php) with a query string attached--so that the link would look like <a href="courseinfo.php?CourseID=12">Accounting 101</a> What I'm having trouble doing is coding the second page. Here's what I've done. When I run this, I get a blank page in return...if anyone can help, I would greatly appreciate it. Thanks in advance. Matt <?php $db = @mysql_connect("host","user","pword"); mysql_select_db("dln", $db); if ( !$CourseID ) { print ("no course id included") exit; }; $query = "Select * from course, disc, instit, prof where course.CourseID = $CourseID and course.DiscID = disc.DiscID and course.InstitID = instit.InstitID and course.ProfID = prof.ProfID; $result = mysql_query ($query); echo "MySQL error number " . mysql_errno() . ": " . mysql_error(); print ("<table border=\"0\" cellpadding=\"5\" class=\"default\">\n"); print ("<tr bgcolor=\"#ff9900\"><th>$CourseID</th></tr><tr><td>$CourseTitle</td></tr></t able>"); ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php