Increment and limit the size of cards in wml

Anon

Hi to all,

I am stuck with a conversion from binary towards whatever might help : I need to increment $j get its value and return a string that can be used in an id such as:
echo \"<card id=\\"$j\\" title=\\"Hotels\\">\";

A figure like $j = 5 won\'t be accepted as an id in wml. Yes, this is for a wap site!

The reason why is that I am getting a list of hotels from a mySQL query and my cards are too long.

My idea is to use $i first increment from 1 to 5 in a while loop, then end the card and continue with a new one if the visitor presses OK. For this to work, I must get an id for the new card!

Must be pretty easy as this is similar to any query that returns a limited number of results and wait for the user to ask for the following page.

I have no idea how Alta Vista has implemented this...

Thanks for your help!

Anon

Hi John,

Not sure quite sure how you're trying to use the card id - but having written a few WAP sites (http://m-minimail.com) I know exactly what the problem is (wap phones need to be improved)!
The way I got round this problem was as follows:

##################################
if(!isset($i))
$i=0;
$No_Of_Hotels=$i+$max_hotels
if ($No_Of_Hotels>$total_hotels)
$No_Of_Hotels = $total_hotels
while($i<$No_Of_Hotels)
{
//display hotel here
$i++;
}
##############################

$i keeps track of how many hotels have been displayed in total
$max_hotels should be set to the maximum number of hotels you want on each page.
$total_hotels is the total number of hotels do be displayed over all the pages

After the while loop put in a link as follows:

#####################################
if($No_Of_Hotels<$total_hotels)
{
echo "<anchor>Next";
echo "<go href='$PHP_SELF?i=$i/>";
echo "</anchor>";
}
#######################################

i.e. test that you still have hotels to display. If so, make the current file call itself, passing it the new $i value - this will make the next card displayed start at the correct hotel.

Let me know if any of the above is incomprehensible!

Clarissa

Anon

Hi Clarissa,

Thanks for your help.

At this stage, I have a query string in a while loop like this:
while($row = mysql_fetch_array($ResultSelect)) {

The only way to get out of this while loop is a break. But this is not a good thing:

echo "<a href=\"hotels.php3?cat=$cat&loc=$loc&continue=OK&i=$i\">";
will get the whole thing start again from the beginning!

I am trying to figure out as I have a bit of code done already. Where is your query string ?

Anyway, I understand that you don't care about the ids of your cards. Don't you name them at all ?

Anon

I had assumed that you were going to put the results of your query into an array and use $i as the index for the array (thus looping through the array) - this means that everytime the page is loaded, ALL the hotels are taken from the DB. I know this is inefficient, but it's the only way I could think of doing it.

You can name the cards if you want, but in this case it won't help you with your problem.

Anon

Yes, I am getting the results in an array, but I am getting them all each time, even if $i changes.

Based on your model, I have added:

$NOH = $i+5;
if ($NOH > $occ) {
$NOH = $occ;
}
while(($row = mysql_fetch_array($ResultSelect)) && ($i < $NOH)) {
etc
}

It stops the loop after 5 occurences. Then I call the same page with $i = 5...

I must be incredibly stupid, as I can't get $row #5 from the table (a LIMIT in the query would do, but this is again too complicated, I think).

As always, the solution must be easy...

Anon

A mysql_data_seek()did it...
Want to see the result?
http://wap.provenceplus.com/wap/wml/fr/hotels.php3?loc=Nice&cat=4

Thanks a lot Clarissa, as you've been very helpful!

Anon

Hi -
Actually meant to put the values into an array like so:

while(($row = mysql_fetch_array($ResultSelect))
{
$store_array[]=$row;
}

And then use $i to as an index of $store_array -
But if you've managed to get it to work with mysql_data_seek then great (probably a better solution anyway)!

Anon

I use mysql_data_seek before the while loop in order to point to the 6th values of $row after the first loops of 5 and so on.