Referring to a row in a result set

Hanlie

Hi,

I'm trying to refer to a primary key in a result set so that I can mail it in a URL. However, I don't know how to refer to the variable without getting a parse error.

For example, if the query is named $report_details, I refer to a row in the result set using
$row_report_details = mysql_fetch_assoc($report_detail);

I've tried the following references and none of them worked:

$row_report_details['report_id']

$_POST['$row_report_details['report_id']']

$_GET['$row_report_details['report_id']']

echo $row_report_details['report_id']

Can someone help, please?

Thanks
Hanlie

tserbis

if the query is named $report_details

$row_report_details = mysql_fetch_assoc($report_detail); ??

Hanlie

Sorry, just a typo, it should be mysql_fetch_assoc($report_details );

However, I still sit with the original problem (this error was just in my post, not in my code on the web page).

tserbis

echo $row_report_details['report_id'];
It's correct.

Have you report_id field in youre SELECT ? :-)

Can you show echo mysql_error(); ??

Hanlie

It's not a MySQL error, it's a PHP error:

"Parse error: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\arms_data_model\requests\report_requested.php on line 15"

And on line 15 is the following code:

$url_name = echo $row_report_details['report_id'];

tserbis

echo $url_name = $row_report_details['report_id'];

njm

$url_name = echo $row_report_details['report_id'];

echo isn't a function, it doesn't return a value so this is why PHP is complaining. Do you mean a simple assignment:

$url_name = $row_report_details['report_id'];

or print to screen?:

echo $row_report_details['report_id'];

hth, njm

Hanlie

Your second suggestion worked, thank you.

I'd read in the manual that echo wasn't a function, but I didn't know what the implications were.

Thanks again for your help.