Indexing a recordset

[recset]

I know this is a simple answer, and maybe because i have been glued to the computer is the reason why i can't see it, so here is the problem:

$query_ldevices = "SELECT * FROM literary_devices_hold WHERE MAXIMID = ID";

-- I want to change 'ID' to $row_Recordset1['ID'] from a table called 'wisdom';

The purpose is that for the MAXIMID's in the literary_devices_hold table to only show information for each recordset in table ID, as long as the MAXIMID'S and ID's are identical.

Can anyone help?

[HuggieBear]

I'm not sure I understand exactly, but if I do, then try this bit of code.

If it doesn't give the result you're expecting, we may need some additional clarification as to what you're after.

[code=php:0]
$sql = "SELECT * FROM literary_devices_hold WHERE maximid = (SELECT max(id) FROM wisdom)";
[/code]

Regards
Rich

[recset]

That actually works, thanks for the help!