Member Avatar for adslgeek

Hi there,

If someone is able to help me out, I will be forever grateful!
All I am getting from the code is: Resource id #3

The SQL works sweet and is returning the correct result..

http://www.adslgeek.com/ispsearch.php

//IMPORT ISP DETAILS
	
		$sql="SELECT `ISPName`
				FROM `isps`
				WHERE `ID` = 4";
		$result = mysql_query($sql);
		$row = mysql_fetch_row($result);
		
//	ISP SQL SEARCH

		echo $sql ;
		echo $result ;
		echo $row['$ISPName'];
  • 3 Contributors
  • 5 Replies
  • 144 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Shanti C
Member Avatar for praveen_dusari

hi, you r getting that because u have echoed mysql_query remove echo $result and change mysql_fetch_row to mysql_fetch_assoc and try u may get the desired result

Member Avatar for adslgeek

Hey there,

I have worked it out with the help of an awesome friend...

http://www.adslgeek.com/isps

echo $row['$ISPName'];
Should have been:
		echo $row['ISPName'];
Member Avatar for praveen_dusari

oh, i didn`t notice that one any way u got the output:)

Member Avatar for adslgeek

Thanks heaps tho, this really is the friendliest forum!!

Member Avatar for Shanti C

yes, this is really friendliest forum!!
im also feeling like...........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.