Mysql Inner Join in Php

[DaveyMoyes]

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

[pritaeas]

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

[DaveyMoyes]

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