Thanks Jason that has worked for me. But just as i felt i was getting this whole 2 tables (Inner Join) thing i get this
$query_RSresultsPets = sprintf("SELECT * FROM petdata WHERE id = %s", GetSQLValueString($colname_RSresultsPets, "int"));
$RSresultsPets = mysql_query($query_RSresultsPets, $petsCon) or die(mysql_error());
$row_RSresultsPets = mysql_fetch_assoc($RSresultsPets);
$totalRows_RSresultsPets = mysql_num_rows($RSresultsPets);
Could you show me where i would place Inner Join within this recodrset, as i have tried placing after (FROM petdata) but its not right? This is the recordset from my Details page, i know i have too pass on the `id` using a Querystring, as you have shown me this before.