Jump to content

Archived

This topic is now archived and is closed to further replies.

OriginalSunny

Extracting info from database using php

Recommended Posts

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.

Share this post


Link to post
Share on other sites
I may not understand what you're trying to do, but wouldn't this work? Are you trying to retrieve the manufacturer from when the user selects the tariff? If that's the case, then you'd make a field in your form 'modelnum' and just use:
[code]
$query_man = "SELECT * FROM stock_item WHERE modelnum = $_POST['modelnum']";
$query_man_result = mysql_query($query_food, $connect) or die ("query_man: ".mysql_error($connect));
[/code]

Share this post


Link to post
Share on other sites
[!--quoteo(post=352289:date=Mar 6 2006, 05:38 PM:name=Pneumonic)--][div class=\'quotetop\']QUOTE(Pneumonic @ Mar 6 2006, 05:38 PM) [snapback]352289[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I may not understand what you're trying to do, but wouldn't this work? Are you trying to retrieve the manufacturer from when the user selects the tariff? If that's the case, then you'd make a field in your form 'modelnum' and just use:
[code]
$query_man = "SELECT * FROM stock_item WHERE modelnum = $_POST['modelnum']";
$query_man_result = mysql_query($query_food, $connect) or die ("query_man: ".mysql_error($connect));
[/code]
[/quote]

No not quite. The user is given a list of options to choose from. These options are now the list of manufacturers (previously they were tariff, thats why before the user selected the tariff and the products under that tariff were displayed). Now the manufacturers are displayed where $_POST['interest'] (interest is the manufacturer selected by the user). So i have to get the manufacturer and display the phones under the manufacturer, only the phone details are in the stock table and the manufacturer is in the stock_item table. The link from the stock table to the stock_item table is via [i]'modelnum'[/i]. Any suggestions??

Share this post


Link to post
Share on other sites
You need to join the two tables using the modelnum columns

[code]SELECT s.* , i.manufacturer
FROM stock s
INNER JOIN stock_item i
ON s.modelnum = i.modelnum
WHERE i.manufacturer = '$mfr'[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.