best way

[mattotto77]

Hi im just looking on the best way to do the the following any tips would be appreciated

i have created a long query using union so for ease of use lets say the query

SELECT Name, Code, info FROM table1 where info = 'Y'

I have done some code to display the results on the page looping through the results, what i was enquiring is how is the best way to print something based on the results...

for instance if Code was equal to ZZ then to print blue pen or if Code equals TT print black paper and so forth.

Thanks 4 looking

[lazzerous]

while ($row=mysql_fetch_array($results))
  {
  switch($row[Code])
    {
    case "ZZ":
      echo "Blue Pen<br>\n";
      break;
    case "TT":
      echo "Black Paper<br>\n";
      break;
    }
  }

[mattotto77]

Thanks a lot just what i needed

[drawmack]

I would probably create a table in the database that mapped codes to what I would print (the filename of the image). Then it's just sql to select the filename instead of the actual code and loop through the data printing it out. You can also change what's printed with just a database update instead of a code update that way.