taking data to next page??

KTM

could somebody help me please!!??

i am creating an on line enrolment system for my uni project.

a user has selected a course and then has to log in on the same page.

the user is then taken to a page where their name is displayed but i also want the chosen course to be taken to the next page and displayed too.

my coding is below, and i can take course details over but only the first course in my db, not the chosen course!!!

i have tried $colname_rsCourse = "%";
and $colname_rsCourse ="";
but i still get the first course.

can somebody please help?

$colname_rsCourse = "1";
if (isset($_GET['coursename'])) {
  $colname_rsCourse = (get_magic_quotes_gpc()) ? $_GET['coursename'] : addslashes($_GET['coursename']);
}
mysql_select_db($database_connEnrolment, $connEnrolment);
$query_rsCourse = sprintf("SELECT * FROM courses WHERE Name = '%s'", $colname_rsCourse);
$rsCourse = mysql_query($query_rsCourse, $connEnrolment) or die(mysql_error());
$row_rsCourse = mysql_fetch_assoc($rsCourse);
$totalRows_rsCourse = mysql_num_rows($rsCourse);

(im using php mysql and dreamweaver)

thanks in advanced 🙂

laserlight

is $_GET['coursename'] set?

KTM

set???

the code is what dreamweaver put, i assumed it was.

isnt it?

(can you tell i dont know much about php!!?)

laserlight

err... do you know what is a query string, or the GET method?

KTM

probably! 😕

the thing is its just a last bit of work i have to do for my uni project.
When i try it with dreamweaver it sometimes works if not, then i just fiddle around with it and it eventually works but not sure how or why!

not too keen on programming so i dont learn the terms etc

laserlight

Let's say your page is called index.php
Then go to:
index.php?coursename=2

The '?' indicates the start of the query string.
coursename=2 is a name/value pair.
$_GET['coursename'] should have the value of 2

Let's say you have some other name/value pair that you wish to pass.
Then you would use:
index.php?coursename=2&name=value
Where '&' separates name/value pairs in the query string.

Of course, if you are writing the URI to a page, you should use &amp; to replace &.

KTM

the coding i gave is on the second page where i want the data to be displayed.

sorry maybe i havent been clear, the course details dont get submitted with the login form they are just present on the page. when the user submits their username and password they are checked to exist in the database and are then displayed on the page. however i also want the corse detials to be shown too but they dont get 'submitted'

have i explained it better??