Showing entries 11 to 12
« 10 Newer Entries
Displaying posts with tag: select (reset)
Jun
05
2006
PHP - Populate HTML Select Element
Posted by Adam Douglas on Mon 05 Jun 2006 22:00 UTC
Tags:

There is many ways to populate vales into a HTML select element. Here is one example I’ve come up with.

PHP Code Example 

1
2
3
4
5
6
7
8
9
10
11
12
13
14

      <select size="1" name="szFooBar[]" multiple="multiple">
< ?php
$i=0;
while($obResults = mysql_fetch_row($saResults))
{
    if ($_POST['szFooBar'] == $obResults[0])
    { $szSelectedValue[$i] = " selected=\"selected\""; }
    else { $szSelectedValue[$i] = ""; }
 
    printf("<option value=\"%s\"%s>%s\n",$obResults[0], $szSelectedValue[$i], $obResults[1]);
    $i++;
}
?>                                                   
</select>

…

[Read more]
Sep
14
2005
SQL to Select a random row from a database table
Posted by Pete Freitag on Wed 14 Sep 2005 18:10 UTC
Tags:

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.

Select a random row with MySQL: 

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL: 

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server: 

SELECT TOP 1 column FROM table
ORDER BY NEWID()

Select a random row with IBM DB2 

SELECT column FROM table
ORDER BY RAND() 
FETCH FIRST 1 ROWS ONLY

Thanks Tim

Select a random record with Oracle: 

SELECT column FROM 
( SELECT column FROM table
  ORDER BY …
[Read more]
Showing entries 11 to 12
« 10 Newer Entries