How to display query

[rrsub]

I have a simple query where there is only one answer.

$idx = mysql_query( "SELECT * FROM name_servers WHERE index like $dns1no"



$idx_result = mysql_result($idx,0,server);

echo $idx_result;

How can I display $idx_result?

$dns1no corresponds to an index field value from another table.

2 columns in name_servers are index and server

When $dns1no = the index, I want to see the value in the server column.

 

[sleipnir214]

I'd first make sure that PHP understands that your use of the string "server" in your mysql_result() invocation is actually a string.

To do that, I'd place quotes around the word server.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!