Jump to content


Photo

How to get data from mysql using php from 2 tables


  • This topic is locked This topic is locked
1 reply to this topic

#1 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 06 March 2006 - 10:48 PM

Hi, i need to extract info and display it. The only thing is i have 2 tables. As you can see below this code works when extracting info from one table.

$query_food = "SELECT * FROM stock WHERE
tariff='$_POST[interest]' AND
prodDesc = 'paygo' ORDER BY tariff";
$result = mysql_query($query_food,$connect)
or die ("query_food: ".mysql_error($connect));

This works as when the user selects a certain 'tariff' the above code selects the correct products. However i also want to do a query using the manufacturer name. But the 'maufacturer' is stated in another table called stock_item. (if i therefore swap 'manufacturer' for 'tarrif' in the above code it wont work as 'manufacturer' is in a different table). So how do i do this?? The tables i have used are:

stock(stockID, colour, modelnum, tariff, pic)
stock_item(modelnum, manufacturer)

Thanks.


#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 06 March 2006 - 11:38 PM

Don't double-post. Read the forum guidelines.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users