PHP - Default Value - Mysql

Hey guys.
Me again...

Essentially what i am doing is pulling data from a MySQL database about the number of thumbnails on a page.
The user can then change this using a <select> dropdown menu.

How ever, i want the <select> to default to the amount already specified by the Database.
I know i can do this by inserting a Selected attribute to one of the <options> but what is the best way of doing this?

Heres my code..
$NumberOfThumbnails = mysql_result($data, 0,"NumberOfThumbnails");
 <select name="numberofthumbnails"> 
    

<option value="0">None</option>
        <option value="2">2</option>
        <option value="4">4</option>
        <option value="6">6</option>
        <option value="8">8</option>
        <option value="10">10</option>
        <option value="12">12</option>
        <option value="14">14</option>
        <option value="16">16</option>
        <option value="18">18</option>
        <option value="20">20</option>
        <option value="22">22</option>
        <option value="24">24</option>
        <option value="25">25</option>
        <option value="26">26</option>
        <option value="27">27</option>
        <option value="28">28</option>
    </select>


Thanks - Danny

I am working on a project that uses a drop down list to chose the category when inserting new data into the database. What I want to do now is make the drop down list default to the chosen category on the list records page and the update page. I have read several tutorials, but they all say that I have to list the options and then select the default. But since it is possible to add and remove categories, this approch won't work. I need the code to chose the correct category on the fly.

There are two tables, one that has the category ID and category name.  The second table has the data and the catid which is referenced to the category id in the first table.

Code: [Select]
--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categories` varchar(37) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

-- --------------------------------------------------------

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
CREATE TABLE IF NOT EXISTS `links` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `catid` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `content` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;


Then is the list records file, I have

Code: [Select]
<?php
include ("db.php");
include ("menu.php");


$result = mysql_query("SELECT categories FROM categories") or die(mysql_error()); 
while ($row = mysql_fetch_array($result)) { 
$categories=$row["categories"];
$options.= '<option value="'.$row['categories'].'">'.$row['categories'].'</option>';
};



$id = $_GET['id'];
$query="SELECT * FROM links ORDER BY catid ASC";
$result=mysql_query($query);

?>
<table width="65%" align="center" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="7"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>Category ID</strong></td>
<td align="center"><strong>Category ID</strong></td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>URL</strong></td>
<td align="center"><strong>Content</strong></td>
<td align="center"><strong>Update</strong></td>
<td align="center"><strong>Delete</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td>
<SELECT NAME=catid>
<OPTION>Categories</OPTION>
<?php echo $options; ?>
</SELECT>
</td>
<td><? echo $rows['catid']; ?></td>
<td><? echo $rows['name']; ?></td>
<td><a href="<? echo $rows['url']; ?>"><? echo $rows['url']; ?></a></td>
<td><? echo $rows['content']; ?></td>
<td align="center"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>
<td align="center"><a href="delete.php?id=<? echo $rows['id']; ?>">delete</a></td>

</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>

So, how do I get this code
Code: [Select]
$result = mysql_query("SELECT categories FROM categories") or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$categories=$row["categories"];
$options.= '<option value="'.$row['categories'].'">'.$row['categories'].'</option>';
};

<SELECT NAME=catid>
<OPTION>Categories</OPTION>
<?php echo $options; ?>
</SELECT>

to give me an output that will be

something like if catid exactly matches categories.id echo categories.categorie  ???

so far everything I have done produces either a default category of the last category,  the catid (which is a number), all of the categories (logical since catid will always be = id, or nothing.  How do I get just the category name? 

I will keep reading and try to figure this out, but any help would be greatly appreciated.

Thanks in advance

Is it possible to put a multiplication problem in the mysql "default value" field?
In my script I need to take the unit amount * quantity, I know how to do this in php, but can I just put my equation in the "default value" field in MYSQL and make it equal to another field?... Like excell?

Thanks

Hi, I am trying to get the date and time that a particular table was last updated, which the code below does, but it doesn't seem to be putting it in the correct timezone, it is 5 hours behind, anyone know why this is? or how i can fix it? Thanks

Code: [Select]
<?php
date_default_timezone_set('Europe/London');
        $query = "SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'tffdb' AND TABLE_NAME = 'test_team_points'";
        $result = mysql_query($query) or die(mysql_error());
        
        $row = mysql_fetch_assoc($result);
echo $row['UPDATE_TIME'];

?>

Hi. I have drop down boxes for date and time that work. The year is a problem because I am using variables instead of fixed values.

Code: [Select]
<select name="Year" style="width:60px">
<option value="2010" >Test
<option value="<?=$ThisYear?>" <? if ($Year == "<?=$ThisYear?>"){?> SELECTED <?}?> ><?=$ThisYear?>
<option value="<?=$NextYear?>" <? if ($Year == "<?=$NextYear?>"){?> SELECTED <?}?> ><?=$NextYear?>
</select>

<select name="Hour" style="width:50px">
<option value="10" <? if ($_SESSION["Hour"] == "10"){?> SELECTED <?}?> >10
<option value="11" <? if ($_SESSION["Hour"] == "11"){?> SELECTED <?}?> >11
<option value="12" <? if ($_SESSION["Hour"] == "12"){?> SELECTED <?}?> >12
<option value="13" <? if ($_SESSION["Hour"] == "13"){?> SELECTED <?}?> >13
<option value="14" <? if ($_SESSION["Hour"] == "14"){?> SELECTED <?}?> >14
<option value="15" <? if ($_SESSION["Hour"] == "15"){?> SELECTED <?}?> >15
<option value="16" <? if ($_SESSION["Hour"] == "16"){?> SELECTED <?}?> >16
<option value="17" <? if ($_SESSION["Hour"] == "17"){?> SELECTED <?}?> >17
<option value="18" <? if ($_SESSION["Hour"] == "18"){?> SELECTED <?}?> >18
<option value="19" <? if ($_SESSION["Hour"] == "19"){?> SELECTED <?}?> >19
<option value="20" <? if ($_SESSION["Hour"] == "20"){?> SELECTED <?}?> >20
</select>

however this works

Code: [Select]
<select name="Year" style="width:60px">
<option value="2010" >Test
<option value="<?=$ThisYear?>" <? if ($Year == "2011"){?> SELECTED <?}?> ><?=$ThisYear?>
<option value="<?=$NextYear?>" <? if ($Year == "2012"){?> SELECTED <?}?> ><?=$NextYear?>
</select>

Can anyone help with this please
TIA

Desmond.