PHP - Php Or Mysql Solution For Ordering Results At Random But Retaining Sequence

Hello
I have multiple stristr condition (300+) involved in my php script (in 1 script only). I would like to know if that is okay or should i move to other solution like Mysql table search data and than direct it to accordingly.
Kindly suggest some thing... the 300 condition are stored in include files (every file there is condition i.e there are 300 files in a directory which is included.)
Kindly suggest some thing efficient and fast.

okay I am using a jquery plugin to re-arrange images which are in mysql and they have their own "order_number" ... when i re-arrange stuff the new order is put into a hidden field in a form and i have it along with another hidden field with their current order... when submitted I combine these two fields in an array so the key is the original order and the value is the new order ....i have 12 images...
Array ( [1] => 1 [2] => 2 [3] => 3 [4] => 4 [5] => 5 [6] => 6 [7] => 7 [8] => 8 [9] => 9 [10] => 10 [11] => 11 [12] => 12 ) 

this is what is what the array looks like... i have a foreach loop with a mysql query but things get kind of weird when you try to do it this way

$num = $_POST['old_num'];
$num = unserialize($num);
$sort = $_POST['sortOrder'];
$sort = explode(',', $sort);

if ($_POST){


$combine = array_combine($num, $sort);

foreach($combine as $key => $value){


mysql_query("UPDATE shirts SET order_number='$value' WHERE order_number='$key' ")
or die(mysql_error());


}


when you do this lets say for example we have the image with order number "1" get switched with the image order number "2"..... the database first updates with number 1 which becomes 2... then when it goes to number "2"... at this point... the first image gets switched back to number 1.... so  1 becomes 2 then the new 2 becomes 1 again and the other 2 becomes 1 also.

I can not think of another way I could update mysql with the correct order numbers... If anyone has any ideas or other solutions I am open to all suggestions... thank you!

Hi I am trying to select and order data/numbers from a colum in a mysql data base however i run the code and it returns no value just a blank page no errors or any thing so i think the code is working right but then it returns no result? Please help thanks

Here is the code:

<?php
$host= "XXXXXX";
$mysql_user = "XXXXXX";
$mysql_password = "XXXXXX";
$mysql_database = "XXXXXXX";

$connection = mysql_connect("$host","$mysql_user","$mysql_password") or die ("Unable to connect to MySQL server.");
mysql_select_db($mysql_database) or die ("Unable to select requested database.");

$row = mysql_fetch_assoc( mysql_query( "SELECT XP FROM Game ORDER BY number DESC LIMIT 1" ) );
$number = mysql_result(mysql_query("SELECT XP FROM Game ORDER BY number DESC LIMIT 1"), 0);

echo "The the highest XP is $number";

?>

How would I make it so that
for every set of data where a fieldname is 1+ it picks a random one out.
For example
User             Hit
Luke             0
Peter            1
Alex              3
Peter            1

For every value where Hit is 1 or over it selects out of the query results a random username.

Is there anyway in MySQL you can select a random record in a table?  I normally do this by generating a random number first and then using that number to find a record but was wondering if there is an easier way.  Thanks for any help. 

Hi,

First off:
I got a table with two columns and 100.000 rows.
Some of the rows are duplicates (allowing me to "weight" the chance of some rows being hit the first time the script runs)
Allright. This i what I want to do:



When the user clicks a button:
1. Generate a random selected row from the table (this I allready accomplished using this code:

Code: [Select]
<?php

  //CODE FROM WWW.GREGGDEV.COM

  function random_row($table, $column) {

      $max_sql = "SELECT max(" . $column . ") 

                  AS max_id

                  FROM " . $table;

      $max_row = mysql_fetch_array(mysql_query($max_sql));

      $random_number = mt_rand(1, $max_row['max_id']);

      $random_sql = "SELECT * FROM " . $table . "

                     WHERE " . $column . " >= " . $random_number . " 

                     ORDER BY " . $column . " ASC

                     LIMIT 1";

      $random_row = mysql_fetch_row(mysql_query($random_sql));

      if (!is_array($random_row)) {

          $random_sql = "SELECT * FROM " . $table . "

                         WHERE " . $column . " < " . $random_number . " 

                         ORDER BY " . $column . " DESC

                         LIMIT 1";

          $random_row = mysql_fetch_row(mysql_query($random_sql));

      }

      return $random_row;

  }

  

  //USAGE

$randomdata = random_row('MYTABLE', 'MYCOLUMN');

echo $randomdata[2]; // Where [2] is the data I want to extract.


?>

This script works fine. The problem is that I want to exclude the results that have allready been shown. With me?
Therefore, since I have duplicate rows of certain data, I need to exclude all the rows that are the same.

I have a couple of solutions, but I can't seem to fit it into this script. (I will not use the ORDER_BY_RAND() query; it'll be too slow for a table with 100.000 rows)


SO:
Here's ideas I've come up with that might work, but because of my limited experience with PHP and MySQL, haven't been able to accomplish.

1) Insert a "temporary" column in the table which is filled with 1 and 0's where 1 indicates that the row has allready been taken? (If possible)
2) Use PHP sessions to store the previously generated rows?
3) Create a temporary table, which fills up with the allready generated rows by the random script?
4) Create a unique txt-file (e.g: _USERSIPADRESS__.txt) which can be used to save and extract data from the random script? (fopen, fwrite and so fourth)



I hope you understand what I'm trying to do
Any suggestions would be highly appreciated.

Thank you.

Hi

I am using php5 and Mysql

I want to generate user id like phone format (Ex: xxx-xxx-xxxx). and check that user id exists in database or not. if yes, i have to generate new user id etc. If that user id not in database, i have to insert user id for new user. Means i have generate unique user id for login purpose.

Generating user id is working fine. availability of user id also ok for me by using mysql_num_rows() function. But if user id i exists in database, how can i generate new user id. All this will be done in single instance (When user click on submit button from registration form).

Here is my script.

Code: [Select]
<?php
function UserID()
{
$starting_digit=5;
$first_part1=rand(0,99);
if(strlen($first_part1)==1) { $first_part="0".$first_part1; } else { $first_part=$first_part1; }
$second_part1=rand(1,999);
if(strlen($second_part1)==1) { $second_part="00".$second_part1; } elseif(strlen($second_part1)==2) { $second_part="0".$second_part1; } else { $second_part=$second_part1; }
$third_part1=rand(1,9999);
if(strlen($third_part1)==1) { $third_part="000".$third_part1; } elseif(strlen($third_part1)==2) { $third_part="00".$third_part1; } elseif(strlen($third_part1)==3) { $third_part="0".$third_part1; } else { $third_part=$third_part1; }
$userid=$starting_digit.$first_part."-".$second_part."-".$third_part;
return $userid;
}

$random_userid=UserID();

$sql=mysql_query("select * from users where user_id='".$random_userid."'");
if(mysql_num_rows($sql)==0)
{
$insert=mysql_query("insert into users (user_id) values ('".$random_userid."')");
}
?>

If user id not exists in database, that user id inserting in database successfully. If not, empty value is inserting, not generating new user id.

Can any one help me out please.

Hello coders,

I'm using this code to grab random results from a table and it works well but I need it to be a non-repeating event.

Code: [Select]
$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `jobs_board` ");
$offset_row = mysql_fetch_object( $offset_result );
$offset = $offset_row->offset;
I'm using this query followed by the html which is a set of divs with inline echo statements for the various variables I've localised from the table. Then I'm repeating that process a number of times to create a small list (I wanted to use a single while loop but cant figure it out at the moment).  Anways, how can I make it so each query is random but also not repeated? At the moment they are indeed random but sometimes one same entry will appear a number of times consecutively...

Nice one guys, L-plate

Hi,
I'm a researcher (and complete coding noob), and am planning a longitudinal study that requires e-mail follow-up with subjects taking an initial survey. For purposes of ethics/anonymity due to sensitive survey data, I'd like the acquired e-mails to be saved uncoupled from the survey responses; this is simple to deal with, and I use a basic PHP e-mail form, which injects the email address in a table in MySQL in a different server than the one used for the survey.

The issue is that the e-mails are saved in the MySQL database in order of injection, thus it is still theoretically possible for me to link the e-mails back to the survey responses (which have a time stamp that I cannot remove).  Ideally I would like not to be able (at all) to link the e-mails to the survey responses, and one way to do that (since I don't save the e-mail injection timestamps in MySQL) might be to have the e-mails saved in MySQL in a random order. Not sure if this is possible, and not even sure if this would be via PHP or MySQL side of things. The server is on godaddy and uses Starfield interface for MySQL but I cannot find an option for random insert/saving of table items (emails). They are saved in order of injection.
Any solution for this?
Thanks,

I have a user table that holds email addresses and for testing purposes I am trying to replace every email address with an email address defined in an array.  I would like to randomly choose an email address from the array and update the table with this address.  When I run the following code it randomly chooses a email address from the array but then updates every row with this one email address.  Can you someone please let me know what I am doing wrong.  Thanks in advance.

Code: [Select]
$query = "SELECT * FROM user '";
$result = mysql_query($query);

$input = array('email1', 'email2', 'email3', 'email4', 'email5', 'email6', 'email7');
$rand_keys = array_rand($input, 2);
$replaceStr = $input[$rand_keys[0]];

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
 $rand_keys = "";
 $rand_keys = array_rand($input, 2);
 $replaceStr = $input[$rand_keys[0]];

 mysql_query("UPDATE user SET email = '$replaceStr'");

}

How can I limit the amount of time my while loop to only show the first 4 rows of my SQL table?   I am using this code to loop my whole table:  

while($row = $results->fetch(PDO::FETCH_ASSOC))
                        {
                        echo '
                        <li>Mileage: '.number_format($row["Mileage"]).'</li>
                        <li>Engine size: '.$row["EngineSize"].'cc</li>
                        ';} ?>

I only want to loop through the first 4 rows of my SQL table, I then want to duplicate the same code but start at the 5th row until the 8th row of the table, how can I do this?   Thanks, Nick

this is my code but i want to have a pice so if their is no results the it will put in a message like "No Results"
but i cant figger it out


<?php
$host="localhost";
$username="xxxxx";
$password="xxxxxx";
$db_name="xxxxxxx";
$tbl_name="Shows";

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE Month='April'and Year='2011' order by Day asc ";
$result=mysql_query($sql);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">

<?php
while($rows=mysql_fetch_array($result)){
?>

<span class="elevenbold"><? echo $rows['Day']; ?> <? echo $rows['Month']; ?> <br><strong class="elevenboldblue"><? echo $rows['Song']; ?></strong><br><? echo $rows['Data']; ?></span><br><br>


<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>

Hey everyone.

So I am coding a badge system for my website usersystem. I am trying to think how I'll handle issues before actually starting to code it and one issue I just can't seem to figure out how to handle..

How would I limit the amount of MySQL results to show per line.
Eg. A user has 6 badges but I'd only like to show 2 per line. So in total it'd show 3 lines with 2 badges per line. If that makes any sense?

Is there any way possible to actually do this?

Hello,

This is query in MySQL

Quote

mysql> LOAD DATA LOCAL INFILE '/var/www/html/numbers.csv' INTO TABLE details FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (number);
Query OK, 0 rows affected (0.00 sec)
Records: 2200 Deleted: 0 Skipped: 1200 Warnings: 0

Now, I am trying to run the same query in PHP and display the same results.... (i.e. Records, Deleted, Skipped)
Quote

<?php
$db=mysql_connect("localhost", "user", "1234") or die(mysql_error());
$dname="database";
mysql_select_db($dname)or die(mysql_error());
$sqlstatement="LOAD DATA LOCAL INFILE '/var/www/html/numbers.csv' INTO TABLE details FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (number)" ;
mysql_query($sqlstatement) or die(mysql_error());;
echo "it is done!";
?>


Tried mysql_fetch_array, row but could not get it to work... please help guys