read entry from 2 different recordsets
I have 2 recordset. $row_rsArtist has all the artists (id, nameArtist) $row_rsProject has the projects (id, cat_id, nameProject).
To link the artist to a specific project I put $row_rsArtist['cat_id'] the same number as $row_rsProject['id'] .
Now I need to read the name of the Artist in my list of Projects, but I don't know how to do this!!?
<?php do { ?>
<a href="fotos.php?v=<?php echo $row_rsProject['cat_id']; ?>">HERE SHOULD BE the name of the Artist from rsArtist [nameArtist]</a><br />
<?php } while ($row_rsProject = mysql_fetch_assoc($rsProject)); ?>
Thank you for any help.
