PHP - Regarding Php Updation Problem

Hi, surely all of us have seen the auto-instant notifications in Facebook, or that comments appear automatically in a page while we are still on that page without page refresh. Can anybody give me an outline of how is it accomplished? If it were the other way around, like the user inputs something in the page, that data could be sent to the server through Ajax and a server side PHP script could update the database accordingly. But how can it be accomplished in the reverse manner also, that when some user does something in one page of a website, its notification is propagated to another page of the site open on some other computer instantly?

Guys thanks for helping me solve the problem i had but now i have another problem and i am lost. i have included the code below for you to have overview.

On the home page the url shows how it should be: http://localhost/board/italian.php?country=Italian
BUT 
When you mouse over the NEXT link to go to next page you get this : http://localhost/board/?page=1&country=Italian  and then an error 404 when you click on the link
page = 1  no matter if you are mousing over link for page 5 or 2

This is the code:

<table style="width:100%; margin-left:auto; margin-right:auto">
        <?php    
            
            $items_per_page = 5;//how many records/rows to display per page
                        
            $page_url      = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
                                    
            $cleaned_current_page_country = htmlspecialchars($_GET["country"]);
                        
            $page_number = (isset($_GET['page']))? filter_var($_GET['page']) : 1;
            //$page_number = filter_var($_GET['page']);
            //$page_number = $_GET['page'];
                
            $selected_restaurant_type = $_GET['country'];
                                                            
            // find number of rows in the db
                $query = "SELECT * FROM menu_update WHERE special_of_theday = 1 AND restaurant_type = '".$selected_restaurant_type."' ";
                $query_result = mysqli_query($connection, $query); 
                $row_count = mysqli_fetch_array($query_result);
                $total_rows = mysqli_num_rows($query_result);
                                                
            $expected_number_of_pages = ceil($total_rows/$items_per_page); //expected number of pages 
                                                
            $page_position = (($page_number - 1) * $items_per_page); //get starting position to fetch record
                        
            //fetch a group of records using sql LIMIT clause
                $query = "SELECT * FROM menu_update WHERE special_of_theDay = 1 AND restaurant_type = '".$selected_restaurant_type."' LIMIT " .$page_position. ',' .$items_per_page;
                $query_result = mysqli_query($connection, $query);
        ?>
                        
            <table width="100%" border=0>
                <tr bgcolor = "#cccccc">
                    <td>Meal</td>
                    <td>Meal name</td>
                    <td>Meal Price</td>
                    <td>Order Now</td>
                    <td>Full Menu</td>
                    <td>Our Gallery</td>
                    <td>Find Us</td>
                    <td>Our Chef</td>
                    <td>Our Manager</td>
                </tr>
        <?php
                while($row_count = mysqli_fetch_array($query_result)){
                    echo "<tr>";
                        echo"
                            <td style ='width:200px; text-align:center; height:120px; background:#eaedf2'><a href='meal_fullPic.php'><img src= ".$row_count['img']." /></a></td>
                            <td style ='width:119px; text-align:center; height:120px; background:#eaedf2'> ".$row_count['meal_name']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'>".$row_count['price']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='order_processor.php'><img src= ".$row_count['order_now']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='full_menu.php'><img src= ".$row_count['full_menu_img']." /></a></td>
                                    
                            <td style ='width:170px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_gallery.php'><img src= ".$row_count['restaurant_pic']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_location.php'><img src= ".$row_count['location_pic']." /></a></td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['chef_name']."</td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['admin']."</td>
                        "; 
                    echo "</tr>";
                }
                mysqli_close($connection);
        ?>    
            </table>
        <div class="board_pagination">
        <?php
            //display the links to the pages
            for($current_page = 1; $current_page <= $expected_number_of_pages; $current_page++){
                 if ($page_number != $expected_number_of_pages){
                    $data = array(
                        'page' => $page_number,
                        'country' => $cleaned_current_page_country,
                    );
                    $the_query = http_build_query($data);
                    $page_url .= '?' . $the_query;
                    echo '<li><a href=" '.$the_query.' ">'.$current_page.'</a></li> ';
                }
            }
        ?>
        </div>
    </table>
 

Code: [Select]
$sql = "SELECT softwareID,softwareName,softwareType,softwareDesc,softwarePath,ITOnly FROM software WHERE softwareName LIKE '%($searchSoftware)%' ORBER BY softwareName";
$result = mysqli_query($cxn,$sql) or die(mysqli_error());

There is something wrong with my LIKE statement because it's not pulling it since I'm either formatting it wrong or something.
Can anyone catch it?

Hi. I am from poland. I am 17 old age and like webmastering. I write my social network. I have new server 10 GB VPS and my script no runing  In my server. in my server do can not login. No runing function
Code: [Select]
mb_strtolower();as delete function mb_strtolower() ; this login runing.
In my server haven`t installing liberary GD and no runing upload avatars.

my code upload is:
elseif ($_GET['act'] == "upload") {
echo <<< KONIEC
<hr>
<center>
        <p>
                <h2>Dodaj zdj&#281;cie</h2> 
                <ul class="gallery clearfix">
                        <li class="extra">
KONIEC;

error_reporting(E_ALL);

// we first include the upload class, as we will need it here to deal with the uploaded file
include('include/class.upload.php');


// retrieve eventual CLI parameters
$cli = (isset($argc) && $argc > 1);
if ($cli) {
    if (isset($argv[1])) $_GET['file'] = $argv[1];
    if (isset($argv[2])) $_GET['dir'] = $argv[2];
    if (isset($argv[3])) $_GET['pics'] = $argv[3];
}

// set variables
$dir_dest = (isset($_GET['dir']) ? $_GET['dir'] : 'test');
$dir_pics = (isset($_GET['pics']) ? $_GET['pics'] : $dir_dest);

if (!$cli) {

}


// we have three forms on the test page, so we redirect accordingly
if ((isset($_POST['action']) ? $_POST['action'] : (isset($_GET['action']) ? $_GET['action'] : '')) == 'simple') {


    // ---------- SIMPLE UPLOAD ----------

    // we create an instance of the class, giving as argument the PHP object
    // corresponding to the file field from the form
    // All the uploads are accessible from the PHP object $_FILES
    $handle = new Upload($_FILES['my_field']);

    // then we check if the file has been uploaded properly
    // in its *temporary* location in the server (often, it is /tmp)
    if ($handle->uploaded) {
        
        // yes, the file is on the server
        // now, we start the upload 'process'. That is, to copy the uploaded file
        // from its temporary location to the wanted location
        // It could be something like $handle->Process('/home/www/my_uploads/');
        $handle->Process($dir_dest);
                
                
         function TestProcess(&$handle, $title = 'test', $details='') {
            global $dir_pics, $dir_dest;
                        $unlink = 'test/'. $handle->file_dst_name;
$myid = $_SESSION['id'];
$opis = htmlspecialchars(stripslashes(strip_tags(trim($_POST["opis"]))), ENT_QUOTES);
            $handle->Process($dir_dest);

            if ($handle->processed) {
                                unlink("$unlink");
                                $link = ''.$dir_pics.'/' . $handle->file_dst_name .'';
                                $addphoto = mysql_query("INSERT INTO photo VALUES('', '$myid', '$link', '$opis')");
                                echo <<< KONIEC
                                <br>
                                <center>
                                <img src="$link" >
                                <br>
                                <br />
                                </center>
KONIEC;
            } else {
                echo '<fieldset class="classuploadphp">';
                echo '  <legend>' . $title . '</legend>';
                echo '  Error: ' . $handle->error . '';
                if ($details) echo '  <pre class="code php">' . htmlentities($details) . '</pre>';
                echo '</fieldset>';
            }
        }
        if (!file_exists($dir_dest)) mkdir($dir_dest);

        

        // -----------
                $handle->image_convert         = 'jpg';
                $handle->image_resize          = true;
        $handle->image_ratio_y         = true;
        $handle->image_x               = 500;
        $handle->image_precrop         = 15;
        $handle->image_watermark       = "watermark_large.png";
        $handle->image_watermark_x     = 20;
        $handle->image_watermark_y     = -20;
        TestProcess($handle, '15px pre-cropping (before resizing 800 wide), large watermark automatically reduced, position 20 -20', "\$foo->image_convert         = 'jpg';\n\$foo->image_resize          = true;\n\$foo->image_ratio_y         = true;\n\$foo->image_x               = 800;\n\$foo->image_precrop         = 15;\n\$foo->image_watermark       = 'watermark_large.png';\n\$foo->image_watermark_x     = 20;\n\$foo->image_watermark_y     = -20;");

        } else {
            // one error occured
            echo '<fieldset>';
            echo '  <legend>file not uploaded to the wanted location</legend>';
            echo '  Error: ' . $handle->error . '';
            echo '</fieldset>';
        }

        // we copy the file a second time
        

        // we delete the temporary files
        $handle-> Clean();





    } else {
        // if we are here, the local file failed for some reasons
        echo '<fieldset>';
        echo '  <legend>local file error</legend>';
        echo '  Error: ' . $handle->error . '';
        echo '</fieldset>';
    }



echo <<< KONIEC
<li>
                </ul>
                
        </p>
</center>
KONIEC;
 

is it the only problem that isn`t installing GD as i have something off in php.ini ? Plise Help me

i'm getting this erro
"Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /***/***/*****.php on line 278
not an active session, starts new"

this is the code:
if ($phase = mysql_result(mysql_query("SELECT `phase` FROM `as_support` WHERE `mission` = '$var2'"),0,0))
 {
   if ($phase=='5') {
//      mysql_query("DELETE FROM `as_support` WHERE `mission` = '$var2'");
//      header("Location: https://www.**********/*******/*******.php");
   }
   else {
      echo date('h:i:s') . ": PHASE is $phase<br />";
      echo "\$var1=$var1,\$var2=$var2<br />";
   }
}
else {
   echo "not an active session, starts new<br />";
   echo "\$var1=$var1,\$var2=$var2<br />";
   mysql_query("INSERT INTO `as_support` (`mission`, `phase`) VALUES ('$var2', '0')") OR DIE(mysql_error());

the first line is line no. 278

can someone please tell me what to do?

tnx

shirley