Display Random Row From Table On Database

[CloudSex13]

Dude!

 

That totally works.

 

Is it meant to display the first

No rows in table with Location id 1

error sometimes as well, too?

[Ken2k7]

What do you mean?

[CloudSex13]

Well, the code will correctly display an outcome based on the OutcomeChance, but it will also display the text "No rows in table with Location id 1" sometimes too, as if it was an outcome in the database.

[Ken2k7]

It shouldn't do that unless you're running it through a loop and there is a bad LocationID.

[CloudSex13]

I haven't adjusted the code you made, but I do have outcomes in the database where the LocationID is different numbers (for different locations) from the CurrentLocation field. Is their a way for these to not show? I would have guessed the WHERE LocationID='$currentLocation' in the SQL queries would have worked for this, no?

[Ken2k7]

Is LocationID a PK?

[CloudSex13]

Nope.

 

OutcomeID is the Primary Key. Should LocationID be?

[Ken2k7]

No, if LocationID is a PK, then it would be stupid.

 

Let's see which one is throwing the error message -

$currentLocation = intval($currentLocation);
$query = mysql_query('SELECT SUM(OutcomeChance) FROM Outcomes WHERE LocationID = ' . $currentLocation) or trigger_error(mysql_error());
if ($sum = mysql_fetch_row($query)) {
     $rand = rand(1, intval($sum[0]));
     $query2 = mysql_query('SELECT * FROM Outcomes WHERE OutcomeChance >= ' . $rand . ' AND LocationID = ' . $currentLocation . ' ORDER BY RAND() LIMIT 1;') or trigger_error(mysql_error());
     if ($row = mysql_fetch_assoc($query2)) echo $row['OutcomeTitle'] . ' | ' . $row['OutcomeImage'] . ' | ' . $row['Outcome'];
     else echo '1. No rows in table with Location id ' . $currentLocation;
} else echo '2. No rows in table with Location id ' . $currentLocation;

[CloudSex13]

lol.

 

The first one is throwing the error - 1.

[Ken2k7]

Do you also get the results from -- echo $row['OutcomeTitle'] . ' | ' . $row['OutcomeImage'] . ' | ' . $row['Outcome']; -- line?

[CloudSex13]

Yes.

[Ken2k7]

Weird. IDK. Take out the else statements if you want.

[CloudSex13]

Yeah, I hear you.

 

If I take them out, nothing echos. *sadness*

 

lol.

 

I'll mess around with it or something.

 

Thanks Ken2k7

[Ken2k7]

Post more of the code.

[CloudSex13]

outcome.php:

 

<?php

include('config.php');
include('global.php'); // Contains $currentLocation
include('checklogin.php');

if ($currentLocation == "1") {
$query = mysql_query('SELECT SUM(OutcomeChance) FROM Outcomes WHERE LocationID = ' . $currentLocation) or trigger_error(mysql_error());
if ($sum = mysql_fetch_row($query)) {
     $rand = rand(1, intval($sum[0]));
     $query2 = mysql_query('SELECT * FROM Outcomes WHERE OutcomeChance >= ' . $rand . ' AND LocationID = ' . $currentLocation . ' ORDER BY RAND() LIMIT 1;') or trigger_error(mysql_error());
     if ($row = mysql_fetch_assoc($query2)) { 
$outcomeTitle = $row['OutcomeTitle']; 
$outcome = $row['Outcome'];
     }
} else echo 'No rows in table with Location id ' . $currentLocation;

$results = "
<p><strong>".$outcomeTitle."</strong></p>
".$outcome."
<p><a href=\"outcome.php\">Get A Outcome...</a></p>";

} else {

header("Location: home.php");
die();

}

echo $results;

?>

[CloudSex13]

I'd say the error outcome (now blank according to my code above) is the most common outcome generated.