|
|
Posted by cgkh.webservices on 10/11/73 12:00
Would be grateful for any help.
I have not messed with php/mysql in a while and have come up with a
problem I have run up against before but cannot remember the solution.
See the following page:
http://www.paraisolpraia.com/index_pt.php?content=sel_hotel_pt
I am calling two records from a mysql database with a php script but
as you can see the records are looping and printing repeatedly.
The code I am using is as follows:
"
<?php
require_once('xxxxxx.php');
$prop_sel_1 = "SELECT
CASAS.area_id,CASAS.casa_id,CASAS.casa_nom,CASAS.quartos,CASAS.pessoas,CASAS..preco_natal,CASAS.preco_jan,CASAS.preco_fev,CASAS.preco_mar,CASAS.preco_abr,CASAS.preco_mai,CASAS.
preco_jun,CASAS.preco_jul,CASAS.preco_ago,CASAS.preco_set,CASAS.preco_out,CASAS.preco_nov,CASAS.preco_dez,CASAS.preco_pascoa,CASAS.casa_text_pt,CASAS.form_url_pt,CASAS.cas_img_ref_1,CASAS.active,CASAS.hotel,TOWNS.area_id,TOWNS.name,TOWNS.text_pt,TOWNS.text_2_pt,TOWNS.img_ref_2
FROM CASAS,TOWNS WHERE CASAS.hotel='Yes' LIMIT 0, 8";
$prop_sel_2 = mysql_query($prop_sel_1) or die(mysql_error());
while($prop_sel_3 = mysql_fetch_array($prop_sel_2,MYSQL_ASSOC ))
{
Print "<tr>";
Print "<td colspan=\"8\" align=\"center\"><img alt=\" \" align=\"center
\" src=\"images/prop_baa.jpg\" vspace=\"2\"></td>";
Print "</tr>";
Print "<tr>";
Print "<td></td>";
Print "<td colspan=\"6\">";
Print "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=
\"99%\" align=\"center\">";
Print "<tr>";
Print "<td><div align=\"left\" class=\"title_index\">" .
$prop_sel_3['casa_nom'] . "</div></td>";
$foto=$prop_sel_3['casa_id'];
$fotos="index.php?content=sel_prop_foto&casa_id=$foto";
Print "<td><div align=\"right\" class=\"top_menu\"><a href=\"$fotos\"
target=\"_blank\" class=\"top_menu\">Ver fotografias, clique aqui!</
div></td>";
Print "</tr>";
Print "<tr height=\"20\">";
Print "<td colspan=\"8\" valign=\"middle\"><hr size=\"1\" align=
\"center\" NOSHADE></td>";
Print "</tr>";
Print "<tr>";
Print "<td valign=\"middle\"><div align=\"justify\" class=\"casa_text
\"><a href=" . $prop_sel_3['form_url_pt'] ." class=\"casa_text\">".
$prop_sel_3['casa_text_pt'] . "</a></div></td>";
Print "<td rowspan=\"2\" align=\"right\" valign=\"top\"><img src=
\"images/".$prop_sel_3['cas_img_ref_1']."\" hspace=\"3\" vspace=
\"4\"></td>";
Print "</tr>";
Print "<tr>";
Print "<td>";
Print "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=
\"95%\" align=\"center\">";
Print "<tr>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\">Pessoas " .
$prop_sel_3['pessoas'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\">Quartos " .
$prop_sel_3['quartos'] . "</div></td>";
Print "</tr>";
Print "</table>";
Print "</td>";
Print "</tr>";
Print "<tr>";
Print "<td colspan=\"2\">";
Print "<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" width=
\"95%\" align=\"center\">";
Print "<tr height=\"20\">";
Print "<td colspan=\"7\" valign=\"top\"><div align=\"left\" class=
\"price_head\"><strong>Preços por semana:</strong></div></td>";
Print "</td>";
Print "</tr>";
Print "<tr>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Janeiro
<br> €" . $prop_sel_3['preco_jan'] . "</div></td>";
Print "<td><div class=\"price_yellow\"> Fevreiro <br> €" .
$prop_sel_3['preco_fev'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Março <br>
€" . $prop_sel_3['preco_mar'] . "</div></td>";
Print "<td><div class=\"price_yellow\"> Abril <br> €" .
$prop_sel_3['preco_abr'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Maio <br>
€" . $prop_sel_3['preco_mai'] . "</div></td>";
Print "<td><div class=\"price_yellow\"> Junho <br> €" .
$prop_sel_3['preco_jun'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Pascoa.
<br> €" . $prop_sel_3['preco_pascoa'] . "</div></td>";
Print "</tr>";
Print "<tr>";
Print "<td><div class=\"price_yellow\"> Julho <br> €" .
$prop_sel_3['preco_jul'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Agosto
<br> €" . $prop_sel_3['preco_ago'] . "</div></td>";
Print "<td><div class=\"price_yellow\"> Setembro <br> €" .
$prop_sel_3['preco_set'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Octobro
<br> €" . $prop_sel_3['preco_out'] . "</div></td>";
Print "<td><div class=\"price_yellow\"> Novembro <br> €" .
$prop_sel_3['preco_nov'] . "</div></td>";
Print "<td bgcolor=\"#ffa200\"><div class=\"price_yellow\"> Dezembro
<br> €" . $prop_sel_3['preco_dez'] . "</div></td>";
Print "<td><div class=\"price_yellow\"> Natal <br> €" .
$prop_sel_3['preco_natal'] . "</div></td>";
Print "</tr>";
Print "</table>";
Print "</td>";
Print "</tr>";
Print "</table>";
Print "</td>";
Print "</tr>";
}
mysql_free_result($result);
?>"
Where I am going wrong??????????
Many thanks for any help for this dumbo!
[Back to original message]
|