Start New Discussion within our Web Development Community

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,, p.price
 		from sms_countries c, sms_prices p
 	where = '$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

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

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

This question has already been answered. Start a new discussion instead.