Ok, so i figured out, how to relate one table to another using ID's, now what i'm wondering is... how would I display the data, if I had multiple ID's in the same row, seperated by commas???
Here is my simple code:
<?
$sql = "SELECT category.*, newproject_data.*, projectdata_details.* FROM category, newproject_data, projectdata_details WHERE category.catID=newproject_data.catID AND projectdata_details.projID=newproject_data.detailID AND newproject_data.nprojectID=newproject_data.nprojectID";
$result = mysql_query($sql);
if (!$result) {
echo("ERROR: " . mysql_error() . "\n$sql\n");
}else{
$owners = mysql_fetch_array($result);
$id=$owners['nprojectID'];
$name=$owners['catSelect'];
$detail=$owners['description'];
echo "<span class=headers>$name</span><br>";
echo "$detail<br>";
echo "$nprojectID<br>";
}
?>
so this references a table with only 1 number in it, like 4, but what if the there were like 4, 23, 120???
