How To Generate Random Tables Fields From MySQL PHP Function Snippet
how to generate random tables fields from mysql php function snippet
how, to, generate, random, tables, fields, from, mysql, php, function, snippet
How To Generate Random Tables Fields From MySQL PHP Function Snippet
Post Description: how to generate random tables fields from mysql php function snippet
POST# 1316
Posted On: Fri Apr 25, 2008 7:15 am
misc
Topic: How To Generate Random Tables Fields From MySQL PHP Function Snippet
if you want to generate random information from your mysql tables, all you have to do is use the RAND() function:

The following example will display one output from your table. You can display multiple fields by doing a loop.

example:

<?
# CONFIGURE
$db_host = 'localhost';
$db_username = 'myusername';
$db_password = 'mypassword';
$db_dbname = 'mydatabase_name';
# END CONFIGURE

$database = mysql_connect($db_host, $db_username, $db_password);
mysql_select_db($db_dbname,$db);

$sql = "SELECT * FROM table_name ORDER BY RAND()";
$result = mysql_query($sql ,$db);
$myrow = mysql_fetch_array($result);

echo $myrow[field_name];

?>


No Repies
(0) Comments for How To Generate Random Tables Fields From MySQL PHP Function Snippet

What do you think?

* name:  

* email:  

* Please enter comments:


Receive Replies on my Comments
(An email will be sent to you when someone replies to your comments)

Add image to comments
yes no             upload
     
  1. How To Generate Random Tables Fields From MySQL PHP Function Snippet