PHP - Displaying .doc/.docx On A Website?

I tried searching on google but couldn't find any relevant information, please redirect me to relevant source or help me with the code.

I want to pass a domain name in text field which will be scanned and then the script will display entire site map.

Not external links or links on a page. Sorry it is not easy for me to explain.

Eg. if i pass abc.com

Script will display

abc.com/12/adn.php
abc.com/asd/asd/
etc

Whatever their url format is.

All the links on that domain.

hello
My database is in a same server with seperate domain name , then I want to insert from website1 mysql data on website2 mysql data.
can anyone help me?

Is it possible to download files from a website to my online websites root directory? reason I'm asking is because I have been downloading large video files to my computer which take about 20 minutes!! Then I use FTP to upload them to my site but it takes about 2-3 hours per video!! I was looking for a faster way! All help would be great!

Quick background... I bought an auction program with plenty of bugs. Todays bug that I can't figure out is that it is displaying a - (dash) when I would prefer it to display 0 (zero) in instances of "total fees due" or in the "fee chart" if it's a flat fee of 0.  0% works fine.

The code related to it is spread out on a handful of files but I think it's mostly related to the following.

   
if (is_array($setup_fee))
    {
    foreach ($setup_fee as $key => $value)
    {
    if ($value['amount'])
    {
    if ($value['calc_type'] == 'flat')
    {
    $output['amount'] += $value['amount'];
    $fee_display = $this->display_amount($value['amount'], $this->setts['currency']);
    }
    else if ($value['calc_type'] == 'percent')
    {
    $output['amount'] += $this->round_number($item_details['start_price'] * $value['amount'] / 100);
    $fee_display = $value['amount'] . '%';
    }

    if ($item_relist)
    {
    $output['amount'] = $this->round_number($output['amount'] - $output['amount'] * $this->fee['relist_fee_reduction'] / 100);
    }

    $output['display'] .= '<tr class="c1"> '.
    ' <td width="150" align="right"><b>' . GMSG_SETUP_FEE . ':</b></td> '.
    ' <td align="left" nowrap colspan="2"><b>' . $fee_display . $value['display'] . '</b></td> '.
    '</tr> ';

    ## now add the row on the invoices table
    if ($user_payment_mode == 2 && $add_invoices)
    {
    $account_balance += $output['amount'];

    $tax_settings = $this->tax_amount($output['amount'], $this->setts['currency'], $user_details['user_id'], $this->setts['enable_tax']);

    $sql_insert_invoice = $this->query("INSERT INTO " . DB_PREFIX . "invoices
(user_id, item_id, name, amount, invoice_date, current_balance, can_rollback, tax_amount, tax_rate, tax_calculated, reverse_id) VALUES
('" . $user_details['user_id'] . "', '" . $item_details['auction_id'] . "', '" . GMSG_SETUP_FEE . "',
'" . $output['amount'] . "', '" . CURRENT_TIME . "', '" . $account_balance . "', " . $can_rollback . ", '" . $tax_settings['amount'] . "', 
'" . $tax_settings['tax_rate'] . "', '1', '" . $item_details['reverse_id'] . "')");

    $sql_update_user_balance = $this->query("UPDATE " . DB_PREFIX . "users SET
balance='" . $account_balance . "' WHERE user_id='" . $user_details['user_id'] . "'");
    }
    }
    }
    }

    foreach ($fees_no_tier as $key => $value)
    {
    if ($value[1])
    {
    $fee_details = $this->display_fee($key, $user_details, $item_details['category_id'], $item_details['list_in'], $voucher_details, $apply_tax);

   if ($item_relist)
   {
   $fee_details['amount'] = $this->round_number($fee_details['amount'] - $fee_details['amount'] * $this->fee['relist_fee_reduction'] / 100);
   }

    $output['amount'] += $fee_details['amount'];

    if ($fee_details['amount']) ## only do this if there is a fee
    {
    $output['display'] .= '<tr class="c1"> '.
    ' <td width="150" align="right"><b>' . $value[0] . ':</b></td> '.
    ' <td nowrap colspan="2"><b>' . $fee_details['display'] . '</b></td> '.
    '</tr> ';


    ## now add the row on the invoices table
    if ($user_payment_mode == 2 && $add_invoices)
    {
    $account_balance += $fee_details['amount'];

    $tax_settings = $this->tax_amount($fee_details['amount'], $this->setts['currency'], $user_details['user_id'], $this->setts['enable_tax']);
   
    $sql_insert_invoice = $this->query("INSERT INTO " . DB_PREFIX . "invoices
(user_id, item_id, name, amount, invoice_date, current_balance, can_rollback, tax_amount, tax_rate, tax_calculated, reverse_id) VALUES
('" . $user_details['user_id'] . "', '" . $item_details['auction_id'] . "', '" . $value[0] . "',
'" . $fee_details['amount'] . "', '" . CURRENT_TIME . "', '" . $account_balance . "', " . $can_rollback . ", '" . $tax_settings['amount'] . "', 
'" . $tax_settings['tax_rate'] . "', '1', '" . $item_details['reverse_id'] . "')");

    $sql_update_user_balance = $this->query("UPDATE " . DB_PREFIX . "users SET
balance='" . $account_balance . "' WHERE user_id='" . $user_details['user_id'] . "'");
    }
    }
     }
    }

$output['display'] .= '<tr class="c5"><td colspan="3"></td></tr><tr class="c2"> '.
   ' <td width="150" align="right"><b>' . GMSG_TOTAL . ':</b></td> '.
   ' <td nowrap colspan="2"><b>' . $this->display_amount($output['amount'], $this->setts['currency']) . '</b></td> '.
'</tr> '.
     '<tr class="c5"> '.
         ' <td><img src="themes/' . $this->setts['default_theme'] . '/img/pixel.gif" width="150" height="1"></td> '.
' <td colspan="2"><img src="themes/' . $this->setts['default_theme'] . '/img/pixel.gif" width="1" height="1"></td> '.
   '</tr> ';

    return $output;
}


I'll really really appreciate the help.

I'm trying to grab something on a different page with the layout:

Code: [Select]
0 day, 10 hours, 35 min, 59 sec
My code to display this information on another page is:

<?php
$page_contents = file_get_contents("http://www.mysite.com");
$matches = array();
preg_match('/([0-9,]+) day, ([0-9,]+) hours, ([0-9,]+) min, ([0-9,]+) sec /', $page_contents, $matches);
echo $matches[0];
?>


Why is it displaying nothing?

Okay, so I am trying to display players usernames and kills and deaths from my highscores page and I have different div classes set for each block This is my code:

<div id="table">
<div class="tr ttl">
<div class="col st1">Rank</div>
<div class="col st2">Username</div>
<div class="col st3">Rating</div>
<div class="col st4">Deaths</div>
<div class="col st5">Kills</div>
</div>
<?php
if($_GET['skill'] == 0) {
$skill = $_GET['skill'];
$page = ($_GET['page']-1);
$limit = RESULTS_PER_PAGE*$page.', '.RESULTS_PER_PAGE;
$limitt = RESULTS_PER_PAGE*$page;
$query = "SELECT * FROM hs ORDER BY `elo` DESC LIMIT ".$limit."";
$result = mysql_query($query);
$counter = 1;
while ($fetch = mysql_fetch_assoc($result)) {
echo '<div class="tr normal ftr rd1">
<div class="col st1">'.($counter+$limitt).'</div>
<div class="col st2"><a href="?user='.$fetch['username'].'">'.$fetch['username'].'</a></div>
<div class="col st3">'.number_format($fetch['kills']).'</div>
<div class="col st4">'.number_format($fetch['deaths']).'</div>
<div class="col st5">'.$fetch['elo'].'</div>
</div>
';
$counter++;
}
}
?>

See where it says echo '<div class="tr normal ftr rd1">    I'd want it to print out like this:  (tr normal ftr rd1) for the first one, (tr normal ftr rd2) for second one and (tr normal ftr rd3) for the 3rd one. Then (tr normal) and (tr odd normal) for the rest Can anyone help me out here?  

So I am trying to display an image from a database (I know it's not the best idea but it's what I was told to do). Anyway I'm having problems displaying it. Here is the code for displaying the image.
$cat = $_GET['cat'];

include 'includes/openDbConn.php';

$sql = 'SELECT * FROM CushionsCategories WHERE CushionCategory = "'.$cat.'"';

echo $sql;

$result = mysql_query($sql); 

echo '<table>';

while($val = mysql_fetch_assoc($result)){

$cush = 'SELECT * FROM Cushion WHERE SKU = "'.$val['CushionSKU'].'"';

echo $cush;

$cushres = mysql_query($cush);

$cushval = mysql_fetch_assoc;

$img = 'SELECT * FROM Images WHERE SKU = "'.$val['CushionSKU'].'"';

echo $img;

$imgres = mysql_query($img);

$imgval = mysql_fetch_assoc($imgres);

if( $i % 3 == 0 ) {

      echo '</tr><tr>';
  

}

echo '<td><img src="image.php?sku='.$val['CushionSKU'].'" name="'.$imgval['FileName'].'" description="'.$imgval['Description'].'" /></td>';

}

echo '</tr></table>';

and the page that gets the image:
$sql = 'SELECT Image FROM Images WHERE SKU = "'.$sku.'"';
//echo $sql;
 $result = mysql_query($sql) or die("Invalid query: " . mysql_error());
 
        // set the header for the image
        header("Content-type: image/jpeg");
        echo mysql_result($result, 0);

Thanks for any help in advance.

I put the javascript code of ad into a file named ad.html, then call it in php by
$ad = file_get_contents("http://mysite.com/ad.html");
echo $ad;
But this does not work for file_get_contents("/ad.html")

Is there a way to avoid writing the domain name, and just getting the ad from the file in the root folder?

Hi all,

I am new to PHP and MySQL and I am expierencing an issue which i need help with. I am creating a pupil record system for an assignment in Uni. we have been given some sample code and we have to build onto this and finish the system.

I have created an add a student page and when the student is added I want to move to the next page and then display the record that has been added (see image below)



Also see code below

Code: [Select]
<?php
print "<H2>Thank you, <i>";
print $_POST['firstname'];
print "&nbsp;";
print $_POST[ 'surname'];
print "</i> has been sucessfully added to the system.</H2>";
print "<a href=\"add_student.php\"><h4>Add Another Student</h4></a>";
 
function doquery($query) {

$db = "prs";
$link = mysql_connect("localhost","..........","........")
     or die("Could not connect to server! Error: ".mysql_error());
  
mysql_select_db($db,$link)
     or die("Could not select $db! Error: ".mysql_error());
   $result = mysql_query($query,$link)
     or $result = "Query Error!<p>Query: $query<p>Error: ".mysql_error();
   mysql_close($link);
  return($result);
}
  
  $firstname="'".$_POST['firstname']."'";
  $surname="'".$_POST['surname']."'";
  $address1="'".$_POST['address1']."'";
  $address2="'".$_POST['address2']."'";
  $town="'".$_POST['town']."'";
  $county="'".$_POST['county']."'";
  $postcode="'".$_POST['postcode']."'";
  $phone="'".$_POST['phone']."'";
  $email="'".$_POST['email']."'";
  $class_set="'".$_POST['class_set']."'";
  $query = "SELECT MAX(upn) + 1 as upn FROM students";
  $result = doquery($query); 
  $row = mysql_fetch_array($result);
  
  $upn = $row['upn'];
      
  $query = "INSERT INTO students (upn, firstname, surname, address1, address2, town, county, postcode, phone, email, class_set) VALUES ($upn, $firstname, $surname, $address1, $address2, $town, $county, $postcode, $phone, $email, $class_set)";
  doquery($query);
  
     echo 
    "<table width=\"350px\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\" bordercolor=\"#de5f57\" align=\"center\">
  <tr>
    <td colspan=\"2\"><h3>Recorded Added</h3></td>
    </tr>
  <tr>
    <td width=\"150px\" class=\"form_labels\">Student Number</td>
    <td width=\"300px\" class=\"table_data\">".$upn."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">First Name</td>
    <td class=\"table_data\">".$firstname."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Surname</td>
    <td class=\"table_data\">".$surname."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Address 1</td>
    <td class=\"table_data\">".$address1."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Address 2</td>
    <td class=\"table_data\">".$address2."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Town</td>
    <td class=\"table_data\">".$town."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">County</td>
    <td class=\"table_data\">".$county."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Postcode</td>
    <td class=\"table_data\">".$postcode."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Phone Number</td>
    <td class=\"table_data\">".$phone."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Email</td>
    <td class=\"table_data\">".$email."</td>
  </tr>
  <tr>
    <td class=\"form_labels\">Class</td>
    <td class=\"table_data\">".$class_set."</td>
  </tr>
</table>";
  
?>

Could someone please tell me why this displays 3 columns correct and then all moves over.  Here is the page you can see what I am talking about http://www.woodrun.org/includes/news.php I have looked the code over and over and can't see it.  Thanks in advance.

Code: [Select]
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_Recordset1 = 1000000;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_woodrun, $woodrun);
$query_Recordset1 = "SELECT * FROM news ORDER BY id DESC" ;
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $woodrun) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_fwragain, $fwragain);
$query_Recordset1 = "SELECT * FROM news ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $woodrun) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5">
  <?php do { ?>
  <tr>
    <td colspan="4" align="left" valign="top"><?php echo "<img src=http://woodrun.org/images/".$row_Recordset1['photo'] ."> "; ?></td>
    <td width="550" align="left" valign="top"><?php echo $row_Recordset1['title']; ?>
      <hr />
      <?php echo $row_Recordset1['article']; ?><br /></td>
  </tr>
  <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>



  <?php
mysql_free_result($Recordset1);
?>

Hi,  I'm very new to php.  just wrote my first insert script which works great.  Now when my script has run it sends you to the thank you page.  It also sends username through a post.  Now I'm trying to display

Dear <? username ?>  But i cant get it working.  can anyone help?  Here is the code for the join page



<?php include('database name');
session_start();  
$validation_id = strval(time());

if(isset($_POST['submit'])) {

 $first_name = mysql_real_escape_string($_POST['first_name']);
  $last_name = mysql_real_escape_string($_POST['last_name']);
   $DOB = mysql_real_escape_string($_POST['DOB']);
    $sex = mysql_real_escape_string($_POST['sex']);
 $email = mysql_real_escape_string($_POST['email']);
  $username = mysql_real_escape_string($_POST['username']);
   $password = mysql_real_escape_string($_POST['password']); 
   $agree = mysql_real_escape_string($_POST['agreed']);
    $creation_date = mysql_real_escape_string($_POST['creation_date']);
$user_type = mysql_real_escape_string($_POST['member_type']);
 $access_level = mysql_real_escape_string($_POST['access_level']);
  $validation = mysql_real_escape_string($_POST['validation_id']);
     $club_user = mysql_real_escape_string($_POST['user_type']);
  
$insert_member= "INSERT INTO Members (`first_name`,`last_name`,`DOB`,`sex`,`email`,`username`,`password`,`agree`,`creation_date`,`usertype`,`access_level`,`validationID`) 
VALUES 
('".$first_name."','".$last_name."','".$DOB."','".$sex."','".$email."','".$username."','".$password."','".$agree."','".$creation_date."','".$user_type."','".$access_level."', '".$validation."')";

$insert_member_now= mysql_query($insert_member) or die(mysql_error());

$url = "thankyou.php?name=".$_POST[$username];
header('Location: '.$url);
}


Also the form looks like this


<form method="POST" name="member_accounts" id="member_accounts">

<input name="username" type="text" class="form_fields" value="<?php echo $_POST['username'];?>" size="20" />
<input name="password" type="password" class="form_fields" value="<?php echo $_POST['password'];?>" size="21" />


now here is the code on the thank you next page.



<? include('database name');
session_start();
$_POST['username']= $username;

 ?>


<body>
<div id="wrapper">

  <h3 class="para_space">Dear <?php echo $_REQUEST[$username]; ?></h3>  

I've got this code that worked on a blank php page but then I copied it to my page and when I preview it nothing is displayed on the page! Can anyone help... Thanks in advance.

Code: [Select]
<div id="main_content_one">
 <?php
include 'config.php';
include 'opendb.php';

$var = 'Text';
$query = "SELECT * FROM table WHERE row LIKE \"%$var%\"";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
    echo "{$row['name']} <br>";
    
?>
    <a href="javascript:;" onclick="document.getElementById('<?php echo $row['id']; ?>').style.display='block'; window.open('http://<?php echo $row['link']; ?>');"><img src="../../graphics/Click here.png" border="0" /></a><br \>
    <div id="<?php echo $row['id']; ?>" style="display:none;">
    <?php echo $row['surname']; ?>
    </div>
    <?php
echo "{$row['date']} <br>";
}
include 'closedb.php';
    ?>   
    </div>

i been working on my view Members page for a while now i can't seem to get it to work right

this is how i shows up for me


and i want it to show up like this


i think it has something to do with the loop, but have no idea how to fix this :S



<?php
require_once('settings.php');
checkLogin('1 2');


$Members = mysql_query("SELECT * FROM users") or die(mysql_error());

$numRowsMembers = mysql_num_rows($Members);
?>

<?php
for($count = 1; $count <= $numRowsMembers; $count++)
{
    $name = mysql_fetch_array($Members);


?>
<table border=2>
<tr><td><img src="<? echo $name['main_P']?>" width="50" height="50"/>
<a href="view_profile.php?username=<? echo $name['Username']?>"><? echo $name['Username']?></a>

<?

$onlinestatus = $name['ON_OFF'];

if ( $onlinestatus == OFFLINE ) {
echo "";
} else {
echo "<font color=green>Online Now!</font>";
}
?>

</td></tr></table>

<?
}
?>

Hello all,    Am trying to display records from mysql using HIghchart but for some reasons, it is not bringing out any output, please help me look into my codes.   :::::::::::::::::::::::::::::::::::::data1.php ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

<?php
include('mysql_connect.php');
$dept = $_POST['department'];
//include('mysql_connect.php');
$stat = 'paid';


$result =  mysql_query ("select category, amount, actual from budget where department = '$dept' GROUP BY category  ") or die(mysql_error());

$category = array();
$category['name'] = 'category';

$series1 = array();
$series1['name'] = 'actual';

$series2 = array();
$series2['name'] = 'amount';

//$series3 = array();
//$series3['name'] = 'Highcharts';


while($r = mysql_fetch_array($query)) {
    $category['data1'][] = $r['category'];
    $series1['data1'][] = $r['actual'];
    $series2['data1'][] = $r['amount'];
  //  $series3['data'][] = $r['highcharts'];   
}

$result = array();
array_push($result,$category);
array_push($result,$series1);
array_push($result,$series2);
//array_push($result,$series3);


print json_encode($result, JSON_NUMERIC_CHECK);
header("Location: view_dept.php");
mysql_close($con);

?>

:::::::::::::::::::::::::::::::::::::::: view_dept.php :::::::::::::::::::::::::::::::::

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
        <script type="text/javascript">
        $(document).ready(function() {
            var options = {
                chart: {
                    renderTo: 'container',
                    type: 'column',
                    marginRight: 130,
                    marginBottom: 25
                },
                title: {
                    text: 'Chart for Department',
                    x: -20 //center
                },
                subtitle: {
                    text: '',
                    x: -20
                },
                xAxis: {
                    categories: []
                },
                yAxis: {
                    title: {
                        text: 'Amount'
                    },
                    plotLines: [{
                        value: 0,
                        width: 1,
                        color: '#808080'
                    }]
                },
                tooltip: {
                    formatter: function() {
                            return '<b>'+ this.series.name +'</b><br/>'+
                            this.x +': '+ this.y;
                    }
                },
                legend: {
                    layout: 'vertical',
                    align: 'right',
                    verticalAlign: 'top',
                    x: -10,
                    y: 100,
                    borderWidth: 0
                },
                series: []
            }
            
            $.getJSON("data1.php", function(json) {
                options.xAxis.categories = json[0]['data1'];
                options.series[0] = json[1];
                options.series[1] = json[2];
                //options.series[2] = json[3];
                chart = new Highcharts.Chart(options);
            });
        });
        </script>
        <script src="http://code.highcharts.com/highcharts.js"></script>
        <script src="http://code.highcharts.com/modules/exporting.js"></script>
</head>
<body>
 <div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>
</body>

thanks in advance
Edited by Maq, 06 June 2014 - 12:36 PM.

        <?php
include'db.php';
$session= $_SESSION['username'];
$query="SELECT * FROM login_ip WHERE login='$session'";
$result= mysql_query($query);
$count= mysql_num_rows($result);
//$close = die($query);
$min= $count - 1;
$find= mysql_query("SELECT * FROM login_ip WHERE login= '$session' & times='$min'")or die(mysql_error());
while($row = mysql_fetch_assoc($find))
   {
$lip=$row['ipaddress'];
echo" <br>$min<br>$count";
  }        
?>


i worte the code above to pull the last ip address that a user has login form it is finding the ip adress but it is displaying like this
Code: [Select]
72.145.25.457
72.145.25.457
72.145.25.457
72.145.25.457
72.145.25.457
so i remove the $lip form the echo and place $min and $count in there and i am getting
Code: [Select]
1
2
1
2
1
2
1
2
Can some one please enplane why i am getting this problem thank you