php syntax checkboxes, radio button

Thikho

Hi i have 3 radio button that hold a priority of my queries , but i have save them as tinyint(4) on the database and it show the 1, 2 ,3 which is Low, High and Med, so i want my priority to show High , Low and Med instead of 1, 2 and 3 when i lits my queries How can i do that using php

here with the code

$sql="SELECT * FROM query WHERE ticket=$ticket";
$get=mysql_query($sql);
$info=mysql_fetch_array($get);
$category=$info[category];
switch($info[priority])
      {
      case 3:
        $oldpri=3;
        break;
      case 2:
        $oldpri=2;
        break;
      case 1:
        $oldpri=1;
        break;
      }
$sql="select * from tech";
$get=mysql_query($sql);
echo "<form method=post action='addresolved.php'>";
echo "<input type=hidden name=ticket value=$ticket>";
echo "<input type=hidden name=editquery value=$editquery>";
echo "<input type=hidden name=useremail value=$info[email]>";


echo "</td></tr></select>";
// Set Priority of query
echo "<table>";
echo "<tr><td><b>Priority:</b></td>";
echo "<td><input type='radio' name='priority' value='1'";
if ($oldpri==1)
  echo " checked";
  echo "><b>High</b></td>";
echo "<td><input type='radio' name='priority' value='2'";
if ($oldpri==2)
  echo " checked>";
  echo "<b>Medium</b></td>";
echo "<td><input type='radio' name='priority' value='3'";
if ($oldpri==3)
  echo " checked";
  echo "> <b>Low</b></td></tr>";

please help

bradgrafelman

Why not use the ENUM column type?

Thikho

you mean like this ALTER TABLE helpdesk.query MODIFY COLUMN priority ENUM NOT NULL;

because now my table structure looks like this , do i have to create a new table that will hold my priorities , i am avoiding another table but to work on this one so should i just change a column type to enum

bradgrafelman

Well, you'd need a complete column definition (e.g. see the manual page I linked to - you specify the options "high" or "low" or whatnot within the column definition).

Afterwards, you could either leave your radio box values as 1, 2, or 3, or you could instead change them to "High", "Medium", or "Low" - whichever you prefer.

Thikho

u mean like this priority ENUM('Low', 'Med', 'High') NOT NULL,

I have made this changes on my database but it is giving me errors like this as soon as a add a new query it will add and show Low on the priority i dont want o show priority Low before i assigned it Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/test/IT/indexticket.php on line 65 this is the file where my queries get listed

To make my life easier my program works fine but on the priority it shows 1, 2 , 3 there is no any other way i can do to make it Low. Med High just using php pls help me with dat this enum it only show Low all the time even when i edit my query it still shows Low