Database help

[ldtiw]

Ok,

Im using this code for querys:

$conn = mysql_connect("$hostname", "$username", "$password");
mysql_select_db("$database", $conn);
$sql = "select * from gallery";
$result = mysql_query($sql, $conn);

And this for printing:

while ($newarray = mysql_fetch_array($result_gallery)) {
$title = $newarray['image_title'];
$cat = $newarray['gallery_id'];
$sold = $nearray['sold'];
Echo "Title = $title  -  Category = $cat  -  sold?<br>";

ok my question is this. In the table im connecting to it has gallery_id and i need another code like that above [top code] that wont clash to get the gallery_title that is assosiated with the gallery_id

Thanks,
Danny

[pete_bisby]

I'm going to call the second table "tblGallery", which contains the gallery_id and gallery_title fields, just to keep things simple.

You can now use the following query:

$sql = "SELECT A.image_title, A.gallery_id, A.sold, B.gallery_title FROM gallery A INNER JOIN tblGallery B ON A.gallery_id=B.galleryID";

The use of the letters before the field names and after the table names are called "aliases" - they help describe the tables and shorten the names of the tables.

They also help especially if you are using mulitple tables that have the same field name in both tables.