recset Posted September 10, 2006 Share Posted September 10, 2006 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? Link to comment https://forums.phpfreaks.com/topic/20299-indexing-a-recordset/ Share on other sites More sharing options...
HuggieBear Posted September 10, 2006 Share Posted September 10, 2006 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]RegardsRich Link to comment https://forums.phpfreaks.com/topic/20299-indexing-a-recordset/#findComment-89499 Share on other sites More sharing options...
recset Posted September 10, 2006 Author Share Posted September 10, 2006 That actually works, thanks for the help! Link to comment https://forums.phpfreaks.com/topic/20299-indexing-a-recordset/#findComment-89513 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.