Search found 5 matches
- Thu Jun 21, 2012 11:54 pm
- Forum: SQL
- Topic: Using the Rand() function
- Replies: 8
- Views: 3772
Re: Using the Rand() function
Thanks, I manage to work it out by adding another query and merging them together.
- Mon Jun 18, 2012 11:18 pm
- Forum: SQL
- Topic: Using the Rand() function
- Replies: 8
- Views: 3772
Re: Using the Rand() function
These are the extra error thrown.
Fatal error: Call to a member function getrows() on a non-object in /home/public_html/index.php on line 161
- Mon Jun 18, 2012 10:41 pm
- Forum: SQL
- Topic: Using the Rand() function
- Replies: 8
- Views: 3772
Re: Using the Rand() function
$conn is defined in the config file.
$conn = &ADONewConnection($DBTYPE);
function cleanit($text) { return htmlentities(strip_tags(stripslashes($text)), ENT_COMPAT, "UTF-8"); }
- Mon Jun 18, 2012 9:58 pm
- Forum: SQL
- Topic: Using the Rand() function
- Replies: 8
- Views: 3772
Re: Using the Rand() function
Hi, I have added the whole index page. If I add the code you gave, I still see no errors. Just a blank page. include("include/config.php"); include("include/functions/import.php"); $thebaseurl = $config['baseurl']; $s = cleanit($_REQUEST['s']); STemplate::assign('s',$s); $page = ...
- Sun Jun 17, 2012 10:59 pm
- Forum: SQL
- Topic: Using the Rand() function
- Replies: 8
- Views: 3772
Using the Rand() function
Hi, I am slowly learning a lot from the tutorials here about php/sql. I am listing certain columns from my database in order, one of which I require to be limited and taking random rows. I have tried for the last couple of days and so far, I seem to only be able to get them all random or just a blan...