If less than 2 dont show delete button

[Anon]

When admin is updating news i would like my script to not let you delete the last one if their are less than 1 in a database. I figure that somehow i have to say that if the num of ids in the database is less than 2 then it will get rid of the delete button i have at the bottom of the news.
Do you understand.

[rbenfield]

Im not sure that I do understand. I mean I assume you are already querying for the news items? if so (and this depends on what type of a database you use) then something like...

if (mysql_num_rows($result) > 1) {
echo "Delete Button Info";
}

That is an oversimplified code snip but if you need more then I will need more details.

Hope that helps,
Richard

[Anon]

If it helps. Here is the code for my script so far. I tried to add in the above statement you gave me.

<? include ("header.php")?>
<?
require ('config.php');
$date = date('Y-m-d H:i:0',mktime($hour,$minute,0,$month,$day,$year));
$connection = @mysql_connect($server, $user, $password) or die("Couldn't Connect.");
$db = @mysql_select_db($dbname, $connection) or die("Couldnt select database.");
$result = @("SELECT title, teaser, id, text, UNIX_TIMESTAMP(date) as date FROM news WHERE archive !='yes'") or die("Couldn't ececute query.");
if (mysql_num_rows($result) < 2) {
$deleteform='';
$adnews="You now have 1 article";
}else{
$adnews='';
$deleteform="<td width='973' class='text'>
<input type='checkbox' name='delete' value='delete'>
Delete Article </td>";
};
while ($row = mysql_fetch_array($result)) {
echo"<form action='review_news_done.php?id=$row[id]' method='post'>

<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr >
<td class='text'>
<div align='center'></div>

  <td class='text'>News Article Number : $adnews
    $row[id]
    <br>
    $row[title]<br>

<tr> 
  <td width=136 class=text valign='top' align='right'>Date:</td>
  <td width='973'> 
    <select name='month'>";?>
				<?		
				for ($x=1;$x<=12;$x++)
				{
					if ($x==date('n',$row[date]))
					{
						echo"<option value=".$x." selected='selected'>".date('M',mktime(0,0,0,$x,1,2000))."</option>";						
					} else {
						echo"<option value=".$x.">".date('M',mktime(0,0,0,$x,1,2000))."</option>";
					}
				}
				?>
			</select>
			<select name='day'>
				<?		
				for ($x=1;$x<=31;$x++)
				{
					if ($x==date('j',$row[date]))
					{
						echo"<option value=".$x." selected='selected'>".$x."</option>";						
					} else {
						echo"<option value=".$x.">".$x."</option>";
					}
				}
				?>
			</select>
			<select name='year'>
				<?		
				for ($x=2002;$x<=2012;$x++)
				{
					if ($x==date('Y',$row[date]))
					{
						echo"<option value=".$x." selected='selected'>".$x."</option>";					
					} else {
						echo"<option value=".$x.">".$x."</option>";
					}
				}
				?>
			</select>
			</td>
		</tr>
		<tr>
			<td width=150 class=text valign=top>Time:</td>
			<td>
			<select name='hour'>
				<?		
				for ($x=1;$x<=12;$x++)
				{
					if ($x==date('g',$row[date]))
					{
						echo"<option value=".$x." selected='selected'>".$x."</option>";						
					} else {
						echo"<option value=".$x.">".$x."</option>";
					}
				}
				?>
			</select>
			:
			<select name='minute'>
				<?		
				for ($x=0;$x<=45;$x=$x+15)
				{
					if ($x==date('i',$row[date]))
					{
						echo"<option value=".$x." selected='selected'>".date('i',mktime(1,$x,0,1,1,2000))."</option>";						
					} else {
						echo"<option value=".$x.">".date('i',mktime(1,$x,0,1,1,2000))."</option>";
					}
				};
				?>
			</select>

			 <?if (date('A',$row[date])=='AM')
					{;?>
					<select name='ampm'>
						<option value='AM' selected='selected'>AM</option>
						<option value='PM'>PM</option>
					</select>
					<? } else { ;?>
					<select name='ampm'>
						<option value='PM' selected='selected'>PM</option>
						<option value='AM'>AM</option>
					</select>
				<?};?>
 </td>
</tr>
<tr> 
  <td valign='top' width='136' class='text' align='right'>Title: </td>
  <td width='973'> 
    <input type='text' name='title' size='100' value='<? echo"$row[title]";?>'>
  </td>
</tr>
<tr> 
  <td valign='top' width='136' class='text' align='right' height='2'>Teaser: 
  </td>
  <td width='973' height='2'> 
    <textarea name='teaser' cols='100' rows='5'><? echo "$row[teaser]";?></textarea>
  </td>
</tr>
<tr> 
  <td width='136' class='text' align='right' valign='top'>News</td>
  <td rowspan='2' width='973'><font size='2' face='Verdana'> 
    <textarea name='text' cols='100' rows='12'><? echo"$row[text]";?></textarea>
    </font></td>
</tr>
<tr> 
  <td width='136' align='right' valign='top'>&nbsp;</td>
</tr>
<tr> 
  <td width='136'  class='text'> 
    <input type='checkbox' name='archive1' value='archive1'>
    Archive Article </td>
  <?$deleteform;?>
</tr>
<tr> 
  <td width='136'> 
    <input type='submit' name='Submit' value='Update News' class='text'>
  </td>
  <td width='973'>&nbsp; </td>
</tr>
<tr bgcolor='#0000FF'> 
  <td height='5' width='136'><font color='#CCCCCC'></font> </td>
  <td height='5' width='973'><font color='#CCCCCC'></font> </td>
</tr>

</table>
</form>
<?};?>

<? include("footer.php");?>

[rbenfield]

I dont have time to verify this but try this...

<?

include ("header.php");
require ('config.php');
$date = date('Y-m-d H:i:0',mktime($hour,$minute,0,$month,$day,$year));
$connection = @mysql_connect($server, $user, $password) or die("Couldn't Connect.");
$db = @mysql_select_db($dbname, $connection) or die("Couldnt select database.");
$result = @("SELECT title, teaser, id, text, UNIX_TIMESTAMP(date) as date FROM news WHERE archive !='yes'") or die("Couldn't ececute query.");
if (mysql_num_rows($result) < 2) {
$deleteform='';
$adnews="You now have 1 article";
}else{
$adnews='';
$deleteform="<td width='973' class='text'>
<input type='checkbox' name='delete' value='delete'>
Delete Article </td>";
}
while ($row = mysql_fetch_array($result)) {
echo"<form action='review_news_done.php?id=$row[id]' method='post'>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr >
<td class='text'>
<div align='center'></div>

<td class='text'>News Article Number : $adnews 
$row[id] 
<br> 
$row[title]<br> 

<tr> 
<td width=136 class=text valign='top' align='right'>Date:</td> 
<td width='973'> 
<select name='month'>";
for ($x=1;$x<=12;$x++) {
    if ($x==date('n',$row[date])) { 
        echo"<option value=".$x." selected='selected'>".date('M',mktime(0,0,0,$x,1,2000))."</option>"; 
    } else { 
        echo"<option value=".$x.">".date('M',mktime(0,0,0,$x,1,2000))."</option>"; 
    } 
} 
?> 
</select> 
<select name='day'> 
<? 
for ($x=1;$x<=31;$x++) { 
    if ($x==date('j',$row[date])) { 
        echo"<option value=".$x." selected='selected'>".$x."</option>"; 
    } else { 
        echo"<option value=".$x.">".$x."</option>"; 
    } 
} 
?> 
</select> 
<select name='year'> 
<? 
for ($x=2002;$x<=2012;$x++) { 
    if ($x==date('Y',$row[date])) { 
        echo"<option value=".$x." selected='selected'>".$x."</option>"; 
    } else { 
        echo"<option value=".$x.">".$x."</option>"; 
    } 
} 
?> 
</select> 
</td> 
</tr> 
<tr> 
<td width=150 class=text valign=top>Time:</td> 
<td> 
<select name='hour'> 
<? 
for ($x=1;$x<=12;$x++) { 
    if ($x==date('g',$row[date])) { 
        echo"<option value=".$x." selected='selected'>".$x."</option>"; 
    } else { 
        echo"<option value=".$x.">".$x."</option>"; 
    } 
} 
?> 
</select> 
: 
<select name='minute'> 
<? 
for ($x=0;$x<=45;$x=$x+15) { 
    if ($x==date('i',$row[date])) { 
        echo"<option value=".$x." selected='selected'>".date('i',mktime(1,$x,0,1,1,2000))."</option>"; 
    } else { 
        echo"<option value=".$x.">".date('i',mktime(1,$x,0,1,1,2000))."</option>"; 
    } 
}
?> 
</select> 
<?
if (date('A',$row[date])=='AM') {
    ?> 
    <select name='ampm'> 
    <option value='AM' selected='selected'>AM</option> 
    <option value='PM'>PM</option> 
    </select> 
    <? 
} else { 
    ?> 
    <select name='ampm'> 
    <option value='PM' selected='selected'>PM</option> 
    <option value='AM'>AM</option> 
    </select> 
    <?
}
?> 
</td> 
</tr> 
<tr> 
<td valign='top' width='136' class='text' align='right'>Title: </td> 
<td width='973'> 
<input type='text' name='title' size='100' value='<? echo"$row[title]";?>'> 
</td> 
</tr> 
<tr> 
<td valign='top' width='136' class='text' align='right' height='2'>Teaser: 
</td> 
<td width='973' height='2'> 
<textarea name='teaser' cols='100' rows='5'><? echo "$row[teaser]";?></textarea> 
</td> 
</tr> 
<tr> 
<td width='136' class='text' align='right' valign='top'>News</td> 
<td rowspan='2' width='973'> 
<textarea name='text' cols='100' rows='12'><? echo"$row[text]";?></textarea> 
</td> 
</tr> 
<tr> 
<td width='136' align='right' valign='top'> </td> 
</tr> 
<tr> 
<td width='136' class='text'> 
<input type='checkbox' name='archive1' value='archive1'> 
Archive Article </td> 
<?
echo $deleteform;
?> 
</tr> 
<tr> 
<td width='136'> 
<input type='submit' name='Submit' value='Update News' class='text'> 
</td> 
<td width='973'>  </td> 
</tr> 
<tr bgcolor='#0000FF'> 
<td height='5' width='136'> </td> 
<td height='5' width='973'> </td> 
</tr> 
</table> 
</form> 
<?

}
include("footer.php");
?>

[Anon]

Thanks man
That worked