1,105,288 Community Members

Mysql Inner Join in Php

Member Avatar
DaveyMoyes
Junior Poster
122 posts since May 2009
Reputation Points: -1 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi Everyone, I have been trying to understand mysql a little further - with some small steps in the right direction.

but I have come across a problem I am unable to fix / get working.

I have a form, that has a variable $country -

I am trying to get the sms text message price for the varible $country

Below is my attempt - to get the sms price

(table field name (price) from tbl (sms_prices))
(table field name (name) from tbl (sms_countries))

$query = "select c.country_id, c.name, p.price
 		from sms_countries c, sms_prices p
 	where
  		c.name = '$country' and
  		c.country_id = p.country_id";	 
			
			$result = mysql_query($query) or die(mysql_error());
			while($row = mysql_fetch_array($result)){
			$smsprice = $row['price'];		
	}

Hope someone can point me in the righr direction and explain where I am going wrong.

Thanks in advance

Member Avatar
pritaeas
mod_pritaeas
11,285 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,829 [?]
Skill Endorsements: 154 [?]
Moderator
Featured
Sponsor
 
0
 

Your query looks just fine to me. What is the problem you have with it? Have you tried it in phpMyAdmin?

Member Avatar
DaveyMoyes
Junior Poster
122 posts since May 2009
Reputation Points: -1 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi, I have found the issue, country name was incorrect in table - Typo that has cost me 4 hours of head scratching - :) Grrrrrrrrrrrrrrrr

Question Answered as of 2 Years Ago by pritaeas
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: