[PHP] how can i make this pick a random line in the DB?

[Brad]

Ok so I've created a automatic feature like lottery were it should pick a random ticket number or username but seems not to show anything

<?php
$n1 = dbquery("SELECT * FROM lottery_tickets WHERE username = '" . TICKET . "'"); ?>
<?php
if(isset($_POST['pick']))
{
    $N1 = rand('" . TICKET . "');
  
  
    $WINNER = mysql_fetch_assoc(dbquery("SELECT username FROM lottery_tickets WHERE username = '". $N1 ."'"));
    if($WINNER['username'] == ""){ $WINNER['username'] = "NONE"; }
  
    fMessage('ok', 'Winner: <b>'. $WINNER['username'] .'</b> ('. $N1 .')');
}  ?>

thanks in advance.

 

[Adil]

what does var_dump($WINNER) give you?

 

[IntactDev]

<?php
$n1 = dbquery("SELECT * FROM lottery_tickets WHERE username = '" . TICKET . "' ORDER BY RAND();"); ?>
<?php
if(isset($_POST['pick']))
{
    $WINNER = mysql_fetch_assoc(dbquery("SELECT username FROM lottery_tickets WHERE username = '". $n1 ."' ORDER BY RAND();"));
    if($WINNER['username'] == ""){ $WINNER['username'] = "NONE"; }
 
    fMessage('ok', 'Winner: <b>'. $WINNER['username'] .'</b> ('. $N1 .')');
}  ?>

The code makes no sense to me, but I basically added "ORDER BY RAND();" within the query. Also, take a look at MySQLi or PDO:

You must be registered for see links

 

[Brad]

<?php
$n1 = dbquery("SELECT * FROM lottery_tickets WHERE username = '" . TICKET . "' ORDER BY RAND();"); ?>
<?php
if(isset($_POST['pick']))
{
    $WINNER = mysql_fetch_assoc(dbquery("SELECT username FROM lottery_tickets WHERE username = '". $n1 ."' ORDER BY RAND();"));
    if($WINNER['username'] == ""){ $WINNER['username'] = "NONE"; }

    fMessage('ok', 'Winner: <b>'. $WINNER['username'] .'</b> ('. $N1 .')');
}  ?>

The code makes no sense to me, but I basically added "ORDER BY RAND();" within the query. Also, take a look at MySQLi or PDO:

You must be registered for see links

I'll explain a user buys a lottery ticket, then it stores their usersname and ticket number in the database, I want that to pick a random winner thanks ill take a look

 

[Brad]

Heres a preview

You must be registered for see links

And here is the full code

<?php
$n1 = dbquery("SELECT * FROM lottery_tickets WHERE username = '" . TICKET . "'"); ?>
<?php


$getSettings = dbquery("SELECT * FROM users WHERE username = '" . USER_NAME . "'");
$userAccount = mysql_fetch_assoc($getSettings);
?>
<?php

if (!defined('IN_HK') || !IN_HK)
{
    exit;
}

if (!HK_LOGGED_IN || !$users->hasFuse(USER_ID, 'fuse_housekeeping_moderation'))
{
    exit;
}

if(isset($_POST['pick']))
{
    $N1 = rand('" . TICKET . "');
   
   
    $WINNER = mysql_fetch_assoc(dbquery("SELECT username FROM lottery_tickets WHERE username = '". $N1 ."'"));
    if($WINNER['username'] == ""){ $WINNER['username'] = "NONE"; }
   
    fMessage('ok', 'Winner: <b>'. $WINNER['username'] .'</b> ('. $N1 .')');
}

require_once "top.php";   

$countEnter = mysql_num_rows(dbquery("SELECT null FROM lottery_tickets"));       

echo '<h1>Lotto System Records ('. $countEnter .' Entries) - ('. $countEnter * 1 .' tokens Earned) - ('. $countEnter * 1 * 2 .' Tokens Prize)</h1>';

?>
<p>This tool allows you to view all the user enteries for the lotto system.</p>
<br>
<form method="post">
    <center><input type="submit" name="pick" value="Select Random Winner"></center>
</form>
<br><br>
<table align="center">
<tr><td align="center" width="150"><b>Username</b></td><td align="center"><b>Numbers</b></td><td align="center" width="300"><b>Date Entered</b></td></tr>
<?php

$query = dbquery("SELECT username,ticket_number FROM lottery_tickets");

while($assoc = mysql_fetch_assoc($query))
{
    echo '<tr><td align="center">'. $assoc['username'] .'</td><td align="center"><b>'. $assoc['ticket_number'] .'</b></td><td align="center">'. date('r', $assoc['date']) .'</td></tr>';
}

?>
</table>

 

[Khalil]

All I could think of at the moment is:

$gQuery = mysql_query("SELECT * FROM `lottery_tickets` ORDER BY RAND() LIMIT 1") or die(mysql_error());

while($Info = mysql_fetch_array($gQuery)) { print("The winner is: ".$Info["username"]."."); }

 

[IntactDev]

All I could think of at the moment is:

$gQuery = mysql_query("SELECT * FROM `lottery_tickets` ORDER BY RAND() LIMIT 1") or die(mysql_error());

while($Info = mysql_fetch_array($gQuery)) { print("The winner is: ".$Info["username"]."."); }

That should work just fine. @Br4d take a look.

 

[Brad]

That should work just fine. @Br4d take a look.

Nope, I'll try working around it soon thanks though dude