ummm....:).....I'm now using fetch_rows, though I wasn't using anything
before.  Still, it's not working.  Here's the new script (thanks again for
your help):


<?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");

while ($row = mysql_fetch_row ($result))
{

print ("<tr
bgcolor=\"#ff9900\"><th>$CourseID</th></tr><tr><td>$CourseTitle</td></tr>");

}
print ("</table>");
?>


----- Original Message -----
From: Daniel Brunner <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 4:04 PM
Subject: Re: [PHP-DB] passing variables from one page to another


> Hello!!
>
> How are you fetching the rows???
>
> mysql_fetch_rows?? or mysql_fetch_object???
>
> Dan
>
>
> On Monday, July 8, 2002, at 02:52 PM, [EMAIL PROTECTED] wrote:
>
> > 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 <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > 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" <[EMAIL PROTECTED]> 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
> >
> >
> >
> >
> >
> > --
> > 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

Reply via email to