[RESOLVED] Simple prob with field names in SQL-Query

[jokobe]

I have a query like this:

$my_query = "select * from my_table";

$my_result = mysql_query($my_query);
and I get the field names from this query:

$my_field_name[$j] = mysql_field_name($my_result, $j )
or die ("could not fetch field name ".mysql_error());

with $j looping.

Now I want to fetch from a second table translations for the field names with an
SQL query like this:

my_header = mysql_query("select usable from header
where original = '$my_field_name[$j]'");

The last query isn't returning the content from field usable, but

" Resource id #5"

Any helpful hint?

[paulnaj]

Try not embedding the variable into the string ...

$my_header = mysql_query("
  SELECT usable 
  FROM header
  WHERE original = '".$my_field_name[$j]."'
") or die ("Could not query: ".mysql_error());

That could be it.
Paul 🙂

[jokobe]

Thanks for your quick answer. It wasn't working, but made me think again - even harder than before :mad: - and I found the solution.

It was fairly easy - and you may as well call me stupid - but my error was:

even when retrieving only one field from a SQL query,
MySQL is returning more then one field.

So it had to be:

$my_display = mysql_fetch_array($my_header);	

And " $my_display[0];" contains the value I was looking for.