What is going on?

[solconsult]

Dear readers,

I have two files:

file1.php and file2.php

file1.php looks like as follows:

...
echo "<a href = "\file2.php?course = ".$record->StudentID."\">course</a>";
....

file2.php

...
$get = HTTP_GET_VARS['course'];

connect($server, $user, $pass);
$query = "select * from course where StudentID like '$get'";
.....

The problem is:

The variable $get returns nothing.

I have defined StudentID as varchar[50]

I am using PHP and MySQL.

What is going on?

I need immediate help

Thank you,

Solomon

[cgraz]

on file2.php, what does the url look like?

If it doesn't look like

www.yourdomain.com/file2.php?course=value

then your problem is in file1.php. $record->StudentID has no value. You have to get the variable passed to the next page through the url.

If your url does look like that (although i'd put my money on the first one), then you'd have to be using the wrong predefined variable for your version of PHP. So instead of $HTTP_GET_VARS, you'd have to use $_GET

Check your url. I think the variable just isn't getting passed.

Cgraz

[press711]

//$get = HTTP_GET_VARS['course'];
use $HTTP_GET_VARS['course'];