PHP - Extract Information From A Site

I've been trying to get this to work for a few days now and can't seem to get anywhere with it! Any help is very much appreciated.

I am creating a number generator where the user is required to insert the maximum number and generate rate. Maximum number is the highest number that the script will go to, and generate rate is how many numbers should be created.

When the script runs, the numbers are stored into a MySQL database. The MySQL database creates a unique ID number so it can be recalled at a later date.

The user then needs to go to Sorting.php and selects the record they wish to use. The numbers from this record are then counted and then stored into an array.

If the numbers 2,5,5,0,2,2,1,3,5,1 where generated, the output of this new array will be: [5] => 3 [3] => 1 [2] => 3 [1] => 2 => 1  (These arrays can be of any length)

I now need to extract this data and show it on screen. I don't know how to approach it.

Format example:

Number 5 appears 3 times
Number 3 appears 1 times
Number 2 appears 3 times
Number 0 appears 1 times

Sorting.php
<?php
        $db1 = new Number_Information();
        $db1->openDB();

        $sql = "select * from GeneratedNumber";
        $result = $db1->getResult($sql);

        if (!$_POST) { //page loads for the first time
            ?>

            <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">

                Select the ID (If you have just generated a number, it will be the last one):

                <!--This is the drop down menu-->
                <select name="ID"> 
                    <?php
                    while ($row = mysql_fetch_assoc($result)) {
                        echo "<option value='{$row['ID']}'> {$row['ID']} </option>";
                    }
                    ?>
                </select> <br />

                <input type="submit" value="Continue" />
            </form>

            <?php
        } else {
            $ID = $_POST['ID']; //This will contain the value that was selected in the drop down menu above.

            $result = mysql_query("SELECT NUMBERS2 FROM GeneratedNumber WHERE ID='{$ID}'"); //This tells the script to select NUMBERS2 contents which is assosiated with the ID.

            while ($row = mysql_fetch_array($result))
                $NUMBERS2 = $row['NUMBERS2'];

            echo "$NUMBERS2"; //Testing reasons - remove it later.
            echo "<br />"; //same as above
            echo "$ID"; // as above.
            echo "<br />"; //as above
            //Convert NUMBERS2 back into an array when inserted into table from Generator.php
            $NUMBERS = explode(",", $NUMBERS2);


            // Counts how many times a number appears
            //*******************************************************************************************************************
            //IF ALL ELSE FAILS, REVERT BACK TO THIS.
            //print_r(array_count_values($NUMBERS));
            //It will only print the statement, but gives you a good building block when things WILL go wrong.
            //*******************************************************************************************************************

            rsort($NUMBERS);
            print_r(array_count_values($NUMBERS));
            

(The questions when editing posts are hard. I've needed to Google both of them:()

Hello,

Anyone know a way I could extract information from YouTube. If I have the URL for the video, how could I get the title, runtime, tags and so on into different strings?

    url = "http://www.youtube.com/watch?v=kMAI26FPeyM";


Thanks

Problem:
"Warning: extract() expects parameter 1 to be array, null given in C:\x\xampp\htdocs\pages\user_personal.php on line 32" - error also found on lines 33 and 38.
and none of the information is displayed.

Goal: I'm trying to retrieve profile information and multiple user inserted pictures and display the pictures through a while loop from one query.



<?php
$query = 'SELECT
        u.name_id, i.bio, i.exhib, p.product_code
        FROM
        user u LEFT JOIN profile i ON u.name_id = i.name_id
LEFT JOIN ecomm_products p ON u.name_id = p.product_code
        WHERE
        u.name = "' . mysql_real_escape_string($_SESSION['name'], $db) . '" and p.name = "' . mysql_real_escape_string($_SESSION['name'], $db) . '"';
    $result = mysql_query($query, $db) or die(mysql_error());
extract($bio);  //line 32
extract($exhib); //line 33
$odd = true;
while ($row = mysql_fetch_array($result)) {
    echo ($odd == true) ? '<tr class="odd_row">' : '<tr class="even_row">';
    $odd = !$odd; 
    extract($rows); line 38
    echo '<td><a href="' . $dir . '/' . $row['product_code'] . '.jpg">';
    echo '<img src="' . $thumbdir . '/' . $row['product_code'] . '.jpg">';
    echo '</a></td>';
    echo '</tr>';
}
echo "</table>";
echo "<p>";
?>

  <ul>
   <li>Biography: <?php echo $bio; ?></li>
   <li>Exhibitions: <?php echo $exhib; ?></li>
  </ul>

I'm trying to build a calculator for a game...but I'm stuck on the extracting part. I don't really know what it's called (so if you know of a tutorial/handbook please link), but how I would I extract this data:

//data to extract
$name = "Robin hood hat"
$currentprice = "3.3m"
$change = "+11.5k"
//display
echo $name
echo $currentprice
echo $change

from: http://itemdb-rs.runescape.com/results.ws?query=robin hood hat

And a small question: how would I convert "+11.5k" into "11500" (1k = 1,000)? The * multiplies it but how do I check for and remove the "+" and "k"?

Hi, I am very new to PHP and apologies if this question has already been answered in another thread.   I am trying to extract the information from one array into another when some search criteria is matched.   Here is an example array ($original): Array ( [ 1234567 ] => Array ( [name] => john ) [ 3456 ] => Array ( [name] => johnny ) [ 45673 ] => Array ( [name] => james ) [ 987 ] => Array ( [name] => jamie ) [ 5628721 ] => Array ( [name] => Simon ))   So if I searched for the string john, jo, joh then the new array ($filtered) should be as follows: Array ( [ 1234567 ] => Array ( [name] => john ) [ 3456 ] => Array ( [name] => johnny ))   I was trying to do this using array_search & preg_match but have been struggling.   Any help would be much appreciated!