Select Random

TwiztedFake · 10-19-2006, 12:19 PM

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

????: NamePros.com http://www.namepros.com/programming/248875-select-random.html
????: NamePros.com http://www.namepros.com/showthread.php?t=248875
$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, 01: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()); 

????: NamePros.com http://www.namepros.com/showthread.php?t=248875
$row = mysql_fetch_array($result); 

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

?>

TwiztedFake · 10-19-2006, 02: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, 02:06 PM

Try this sql:

Code:

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

TwiztedFake · 10-19-2006, 02: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, 02:11 PM

How about

Code:

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

TwiztedFake · 10-19-2006, 02: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, 12:19 PM	THREAD STARTER #1 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 348	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 ????: NamePros.com http://www.namepros.com/programming/248875-select-random.html ????: NamePros.com http://www.namepros.com/showthread.php?t=248875 $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. __________________ -TwiztedFake- RTard Tutorials Digital-Dummy to Total-Techie Last edited by TwiztedFake; 10-19-2006 at 01:22 PM.

10-19-2006, 01:31 PM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	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()); ????: NamePros.com http://www.namepros.com/showthread.php?t=248875 $row = mysql_fetch_array($result); echo stripslashes($row['quote']); ?>` __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-19-2006, 02:04 PM	THREAD STARTER #3 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 348	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 __________________ -TwiztedFake- RTard Tutorials Digital-Dummy to Total-Techie

10-19-2006, 02:06 PM	#4 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Try this sql: Code: SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND LIMIT 1 __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-19-2006, 02:09 PM	THREAD STARTER #5 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 348	SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND LIMIT 1 Unknown column 'RAND' in 'order clause' Thats the result. __________________ -TwiztedFake- RTard Tutorials Digital-Dummy to Total-Techie

10-19-2006, 02:11 PM	#6 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	How about Code: SELECT * FROM ct_quotes WHERE ID > '0' ORDER by RAND() LIMIT 1 __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-19-2006, 02:17 PM	THREAD STARTER #7 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 348	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 __________________ -TwiztedFake- RTard Tutorials Digital-Dummy to Total-Techie

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