Select Random

TwiztedFake · 10-19-2006, 11:19 AM

I'm trying to pull a random quote from my database but keep getting the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/t/w/i/twiztedfake/html/index.php on line 27

Line 27 is:
$row = mysql_fetch_array($result);

PHP Code:

  <?php

$sql = "SELECT * FROM ct_quotes WHERE ID > '0' ORDER by ID RAND LIMIT 1";

$result = mysql_query($sql);

$row = mysql_fetch_array($result);

echo stripslashes($row['quote']);

?>

Whats wrong?

**Update

While looking around some resource sites I found a code snipplet that seems to work for it. Here it is:

PHP Code:

  <?php

    $sql = "SELECT * FROM ct_quotes ORDER BY ID";

    $result = mysql_query($sql);

        while ($row = mysql_fetch_array($result))

            { 

                $row_array[] = $row['quote']; 

            }

        $random_row = $row_array[rand(0, count($row_array) - 1)];

        echo stripslashes($random_row);

?>

If you think there is a better way to do this please let me know.

Barrucadu · 10-19-2006, 12:31 PM

First of all find out what the error is:

PHP Code:

  <?php 

$sql = "SELECT * FROM ct_quotes WHERE ID > '0' ORDER by ID RAND LIMIT 1"; 

$result = mysql_query($sql)or die($sql.'<br/>'.mysql_error()); 

$row = mysql_fetch_array($result); 

echo stripslashes($row['quote']); 

?>

TwiztedFake · 10-19-2006, 01:04 PM

Here is the error after doing that. Even though I got the other way working I still want to figure this out.

SELECT * FROM ct_quotes WHERE ID > '0' ORDER by ID RAND LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'RAND LIMIT 1' at line 1

Barrucadu · 10-19-2006, 01:06 PM

Try this sql:

Code:

SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND LIMIT 1

TwiztedFake · 10-19-2006, 01:09 PM

SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND LIMIT 1
Unknown column 'RAND' in 'order clause'

Thats the result.

Barrucadu · 10-19-2006, 01:11 PM

How about

Code:

SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND() LIMIT 1

TwiztedFake · 10-19-2006, 01:17 PM

That fixed it! I knew where the error was happening I just couldn't seem to get the correct syntax to make it work.

Thanks

10-19-2006, 11:19 AM	#1 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 339 50.00 NP$ (Donate)	Select Random I'm trying to pull a random quote from my database but keep getting the following error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/t/w/i/twiztedfake/html/index.php on line 27 Line 27 is: $row = mysql_fetch_array($result); PHP Code: `<?php $sql = "SELECT * FROM ct_quotes WHERE ID > '0' ORDER by ID RAND LIMIT 1"; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo stripslashes($row['quote']); ?>` Whats wrong? *Update While looking around some resource sites I found a code snipplet that seems to work for it. Here it is: PHP Code: `<?php $sql = "SELECT FROM ct_quotes ORDER BY ID"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $row_array[] = $row['quote']; } $random_row = $row_array[rand(0, count($row_array) - 1)]; echo stripslashes($random_row); ?>` If you think there is a better way to do this please let me know. __________________ Four Seasons Outfitters [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month] [ 25 $NP/Month] Last edited by TwiztedFake; 10-19-2006 at 12:22 PM.

10-19-2006, 12:31 PM	#2 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	First of all find out what the error is: PHP Code: `<?php $sql = "SELECT * FROM ct_quotes WHERE ID > '0' ORDER by ID RAND LIMIT 1"; $result = mysql_query($sql)or die($sql.'<br/>'.mysql_error()); $row = mysql_fetch_array($result); echo stripslashes($row['quote']); ?>` __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

10-19-2006, 01:04 PM	#3 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 339 50.00 NP$ (Donate)	Here is the error after doing that. Even though I got the other way working I still want to figure this out. SELECT * FROM ct_quotes WHERE ID > '0' ORDER by ID RAND LIMIT 1 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'RAND LIMIT 1' at line 1 __________________ Four Seasons Outfitters [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month] [ 25 $NP/Month]

10-19-2006, 01:06 PM	#4 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	Try this sql: Code: SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND LIMIT 1 __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

10-19-2006, 01:09 PM	#5 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 339 50.00 NP$ (Donate)	SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND LIMIT 1 Unknown column 'RAND' in 'order clause' Thats the result. __________________ Four Seasons Outfitters [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month] [ 25 $NP/Month]

10-19-2006, 01:11 PM	#6 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	How about Code: SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND() LIMIT 1 __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

10-19-2006, 01:17 PM	#7 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 339 50.00 NP$ (Donate)	That fixed it! I knew where the error was happening I just couldn't seem to get the correct syntax to make it work. Thanks __________________ Four Seasons Outfitters [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month] [ 25 $NP/Month]

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)