inner join two table on same id

[rutin]

Hi there,

I am trying to inner join two tables on the same id, which is " recipeid"

my tables are :

CREATE TABLE recipes (
  recipeid int(10) unsigned NOT NULL default '0',
  title varchar(255) default NULL,
  recipe text,
  userid int(10) unsigned default NULL,
  rating int(10) unsigned default '0',
  categoryid int(10) unsigned default NULL,
  date varchar(20) NOT NULL default '',
  story text,
  hits int(10) unsigned default '0',
  status char(1) default 'W',
  PRIMARY KEY  (recipeid),
  UNIQUE KEY recipieid (recipeid),
  KEY recipieid_2 (recipeid)
) TYPE=MyISAM



CREATE TABLE ingredients (
  recipeid int(10) unsigned NOT NULL default '0',
  ingredient varchar(255) NOT NULL default ''
) TYPE=MyISAM;

And my code is :

<?php

if (isset($_GET["id"]) && $_GET["id"] > 0) {

   mysql_connect("****","****","****"); 
    mysql_select_db("******"); 

    include ('class.ezpdf.php'); 
    $pdf =& new Cezpdf(); 
    $pdf->selectFont('./fonts/Helvetica'); 
    $pdf->ezText('Recipe Collection',14); 
    $pdf->ezText('© 2005 Recipe Collection, .',10); 
    $pdf->ezText('',12); 


$result=mysql_query("SELECT * FROM recipes LEFT JOIN ingredients ON (recipes.recipeid = ingredients.recipeid)  WHERE recipeid='$_GET[id]'"); 

   $i=0; 
    while( $row=mysql_fetch_array($result) ) 
    { 
        $data[$i]=array('title'=>$row['title'],'recipe'=>$row['recipe'],'ingredient'=>$row['ingredient']); 
        $i++; 
    } 

    $pdf->ezTable($data,"","",array('xPos'=>'left','xOrientation'=>'right','width'=>500)); 

    $pdf->ezStream(); 
    exit; 

} 


?>

This file is called pdf.php, ( generates pdf file from mysql) so once i execute this file in this way pdf.php?id=1, that should show records from recipes based on id=1, and in that insert the record from ingredients called ingredients

Can any1 help ?

Thank you,
Rutin

[pohopo]

1. You should not use *, type in every field you need and make sure to put recipes. or ingredients. in front of each field.

2. In the where put recipes. in front of the field

$result=mysql_query("SELECT * FROM recipes LEFT JOIN ingredients ON (recipes.recipeid = ingredients.recipeid)  WHERE recipes.recipeid='$_GET[id]'"); 

[rutin]

Thank you very much, that helped me.
I am getting some html tags, how can i strip them from my generated pdf ? like <br> ?

And in my ingredient table i have many lines, it showed me only one line ? How can i have it display all?

sample rows for id=2:

INSERT INTO ingredients VALUES (2, '1/2 cup warm water (110 degrees F/45 degrees C)');
INSERT INTO ingredients VALUES (2, '1/2 cup warm milk');
INSERT INTO ingredients VALUES (2, '1 egg');
INSERT INTO ingredients VALUES (2, '1/3 cup butter, softened');
INSERT INTO ingredients VALUES (2, '1/3 cup white sugar');
INSERT INTO ingredients VALUES (2, '1 teaspoon salt');
INSERT INTO ingredients VALUES (2, '3 3/4 cups all-purpose flour');
INSERT INTO ingredients VALUES (2, '1 (.25 ounce) package active dry yeast');
INSERT INTO ingredients VALUES (2, '1/4 cup butter, softened');

Thank you.