Overwriting Arrays

[furious5]

I'm currently trying to match an array value by ID and overwrite it if it already exists.

I'm struggling with this small snippet of code though:

$all_rsVillas = mysql_query($sql);
$totalRows_rsVillas = mysql_num_rows($all_rsVillas);
while($totalRows_rsVillas = mysql_fetch_assoc($all_rsVillas)){ 


  $totalRows_rsVillas[$totalRows_rsVillas[ID]] = $totalRow_rsVillas;

}

Any ideas??

[Shrike]

Originally posted by furious5
I'm currently trying to match an array value by ID and overwrite it if it already exists.

I'm struggling with this small snippet of code though:

$all_rsVillas = mysql_query($sql);
$totalRows_rsVillas = mysql_num_rows($all_rsVillas);
while($totalRows_rsVillas = mysql_fetch_assoc($all_rsVillas)){ 


  $totalRows_rsVillas[$totalRows_rsVillas[ID]] = $totalRow_rsVillas;

}

Any ideas?? [/B]

A few things:
- $totalRows_rsVillas is the mysql_num_rows() result but you then assign it in the while() loop.
- You then assign $totalRows_rsVillas[ID] again, to the result of mysql_fetch_assoc();
- Need to quote $totalRows_rsVillas[ID] ... ['ID']

$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
$rows = array();
while($row = mysql_fetch_assoc($result)){ 
  $rows[$row['ID']] = $row
}

Sorry, I changed your variable names, long names just cause more confusion 😉

[furious5]

Spot on Shrike

I've noticed my last problem with my code.

Now I've created a final array with unique entries, I am currently using a foreach loop to iterate through the array.

My problem is that I am struggling to apply my page limits to the code.

[Shrike]

You need a pagination script then 🙂

Theres lots on this board, heres one I wrote http://shrike.webchimps.com/example-page-numbers.php 😉

[furious5]

I've already got a paged recordset script, my problem at the moment is with having an array but not being able to access it where I want.

I'm guessing I could do something like a for loop and break it at a value of 5 for the number of records to display per page, my only problem is that by incrementing the array value by one I will have empty values for the first 17 loops.

The first ID in the array is 17, does anyone know if there is a function to iterate through the array based on the next available value??

for($rows[$i]; $i <= 5; $i++){

echo "<p>";
echo "ID:" .$row[ID]. "<br>";
echo "Name:" .$row[Name]. "<br>";
echo "Short Description:" .$row[Short_Description]. "<br>";

}

[Shrike]

foreach() ?

[furious5]

Yes, but my question is how do I then break the loop to display say 5 records and then re-enter the loop at the next value??

At the moment I can return all the records using a foreach() but I can't break the flow as I wish.

Just looking for a bit of advice.

[Shrike]

Bit confused now. It sounds like you need to paginate the record set, e.g. have an HTML page with a table displaying the records, and some links e.g.

<< Last 5 || Next 5 >>

When you do the SQL query, use a LIMIT clause, e.g.

$sql = "SELECT foo FROM bar LIMIT $limit, 5";

Then pass variable $limit to you script, which will tell SQL which row to start selecting from, with a 5 offset.

[furious5]

I've already got a LIMIT within the script..

Here's my code to date

mysql_select_db($database_conVillas, $conVillas);
$sql = "SELECT DISTINCT * FROM villas, pricing1 WHERE villas.resort = 'pollenca' AND villas.beds LIKE '%%' AND pricing1.price != '0' AND pricing1.availability = '1' AND pricing1.week >= 1073088000 AND pricing1.week <= 1074297600 AND villas.id = pricing1.id ";


$maxRows = 5;
$pageNum = 0;


$result = mysql_query($sql);
$result_limit = sprintf("%s LIMIT %d, %d", $result, $startRow, $maxRows);
$totalRows = mysql_num_rows($result);
while($row = mysql_fetch_assoc($result)){

   $rows[$row[ID]] = $row; // Any duplication _should_ overwrite the previous instance 
	echo "<p>";
}

$totalRows = count($rows);
$totalPages = ceil($totalRows/$maxRows)-1;

?>

Showing 
record <?php echo ($startRow + 1) ?> to <?php echo min($startRow + $maxRows, $totalRows) ?> 
of <?php echo $totalRows ?> 


<?php

if ($totalRows == 0){
echo 'Sorry your search did not return any results. Please return to the search page <a href=search.php>here</a>';
} else {


while($row = mysql_fetch_assoc($result)){ 
   $rows[$row[ID]] = $row; // Any duplication _should_ overwrite the previous instance 
}

$i = 0;

foreach($rows as $row){ 

for($row[$i]; $i <= 5; $i++){

 $totalRows = count($rows);

	  echo "<p>";
	  echo "ID:" .$row[ID]. "<br>";
	  echo "Name:" .$row[Name]. "<br>";
	  echo "Short Description:" .$row[Short_Description]. "<br>";

}
  }
}

?>

<div align="right">
	<a href="<?php printf("%s?pageNum=%d%s&resort=%s&date=%s&beds=%s", $currentPage, max(0, $pageNum - 1), $queryString, $resort, $date, $sleeps); ?>"> 
		<?php if ($pageNum > 0) { // Show if not first page ?>
		PREVIOUS 
		<?php } // Show if not first page ?>
	</a>
</div>

<div align="left">
	<a href="<?php printf("%s?pageNum=%d%s&resort=%s&date=%s&beds=%s", $currentPage, min($totalPages, $pageNum + 1), $queryString, $resort, $date, $sleeps); ?>"> 
		<?php if ($pageNum < $totalPages) { // Show if not last page ?>
		NEXT
		<?php } // Show if not last page ?>
	</a>
</div>