[SOLVED] Can someone look my code over for any mistakes?

[djfox]

Here is my code:

 

$res = mysql_query("SELECT id, name, description, url, price, preview FROM collection WHERE id='$c[2]'");
$comico = mysql_fetch_row($res);
mysql_free_result($res);
{
echo "<a href='sell7.php?id=$comico[0]&p=$comico[4]'>";
echo "<img src='collection/$comico[5]' border=0></a>";
}

 

Here is my problem:

$comico[0] and $comico[5] appear fine but $comico[4] is not showing up.

 

Can someone look me over and see if I messed up somewhere?

[trq]

<?php

  if ($res = mysql_query("SELECT id, name, description, url, price, preview FROM collection WHERE id='{$c[2]}'")) {
    if (mysql_num_rows($res)) {
      $comico = mysql_fetch_row($res);
      mysql_free_result($res);
      echo "<a href='sell7.php?id={$comico[0]}&p={$comico[4]}'>";
      echo "<img src='collection/{$comico[5]}' border=0></a>";
    }
  } else {
    echo mysql_error();
  }

?>

[djfox]

No error message appears.

[paul2463]

the code seems ok to me and when i create an array as follows

$comico = ARRAY("me", "name", "desc", "url","20.44","preview");

 

which is what the query code does, but with your values from the database

and if I run your echo statements I get the following source code

 

<a href='sell7.php?id=me&p=20.44'><img src='collection/preview' border=0></a>

 

which, based on my array is exactly what it should say

[djfox]

Hm, ok, it must be something elsewhere in the code then. I`ll check over the whole file and see what I can find.

 

Thanks for checking it over.

[paul2463]

if the price isnt showing up check your query is correct or that there are actual values in the orice column

[djfox]

if the price isnt showing up check your query is correct or that there are actual values in the orice column

 

Ah that`s what it was. I was calling the price value from the wrong table.

 

Thanks much.