Thanks for the response. Here's what I see in the source code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=windows-1252" http-equiv=Content-Type></HEAD> <BODY></BODY></HTML>
I'm not actually testing the link--I'm just typing the following url into the browser: courseinfo.php?CourseID=12 Could that be the source of the problem? thanks, Matt ----- Original Message ----- From: Rich Hutchins <[EMAIL PROTECTED]> To: Matthew K. Gold <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 5:39 PM Subject: RE: [PHP-DB] passing variables from one page to another > Just wanted to eliminate one possible problem area. If the query works, then > the problem must be in the PHP or the HTML. What do you see if you right > click and view source on the blank page you get? If you see something there, > copy it into a reply. Might be nothing important, but it'll show us what's > being parsed by the browser. > > -----Original Message----- > From: Matthew K. Gold [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 08, 2002 5:07 PM > To: Hutchins, Richard; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] passing variables from one page to another > > > It works from the command line if I leave out course.CourseID = $CourseID > in the where line of the select clause. I assume that I'd have to leave > that out when working from the command line because it's defined in the php > file... > > But I think that that is where my problem is. As I've mentioned, I'm very > new at this, so the answer could be very basic. > > thanks, > > Matt > > ----- Original Message ----- > From: Hutchins, Richard <[EMAIL PROTECTED]> > To: 'Matthew K. Gold' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, July 08, 2002 4:35 PM > Subject: RE: [PHP-DB] passing variables from one page to another > > > > Matthew, have you tried running your query from the command line in MySQ L? > > If you can do that successfully, that'll prove that the query is > functioning > > properly and the problem can be tracked elsewhere. > > > > -----Original Message----- > > From: Matthew K. Gold [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 08, 2002 3:40 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] passing variables from one page to another > > > > > > 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
