Jump to content

Archived

This topic is now archived and is closed to further replies.

recset

Indexing a recordset

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.