Is this possible?

Elhombrebala

I have a problem formatting results from DB query, maybe what I want is impossible...
http://www.costa4seasons.com/demo/table.html

LordShryku

Yes, it's possible.

Tracer

No problem...providing you setup your database correctly....

Post your db fields

Elhombrebala

Here you have some html with a table that contains the php I would like to show, in fact there are some images when some records of database are =1

<table width="600" border="1" cellpadding="0" cellspacing="5" bordercolor="#FFCC66" bgcolor="#FFFFCC">
<tr>
<td width="19%" height="113"><img src="images/thumb/<? echo $refnum; ?>thumb_1.jpg" width="150" height="112"></td>
<td width="81%"><table width="0%" height="0%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFCC">
<tr>
<td width="200" rowspan="4" valign="top"><font color="#000000" size="1" face="Arial, Helvetica, sans-serif"><? echo $Descripcion; ?></font></td>
<td width="24">
<? if ($row['accesplaya']==1){echo "<img src='images/iconosact/accesoplaya.gif' width='24' height='24' alt='ligging aan het strand'>";}else{echo "<img src='images/iconosinact/accesoplaya.gif' width='24' height='24' alt='ligging aan het strand'>";}?>
</td>
<td width="24">
<? if ($row['ascensor']==1){echo "<img src='images/iconosact/ascensor.gif' width='24' height='24' alt='Lift
'>";}else{echo "<img src='images/iconosinact/ascensor.gif' width='24' height='24' alt='Lift'>";}?>
</td>
<td width="24">
<? if ($row['cafetera']==1){echo "<img src='images/iconosact/cafetera.gif' width='24' height='24' alt='Koffiezetapparaat
'>";}else{echo "<img src='images/iconosinact/cafetera.gif' width='24' height='24' alt='Koffiezetapparaat'>";}?>
</td>
<td width="24">
<? if ($row['Calefaccion']==1){echo "<img src='images/iconosact/calefaccion.gif' width='24' height='24' alt='Verwarming
'>";}else{echo "<img src='images/iconosinact/calefaccion.gif' width='24' height='24' alt='Verwarming'>";}?>
</td>
<td width="24">
<? if ($row['zonajuegos']==1){echo "<img src='images/iconosact/zonajuego.gif' width='24' height='24' alt='Speelplaats
'>";}else{echo "<img src='images/iconosinact/zonajuego.gif' width='24' height='24' alt='Speelplaats'>";}?>
</td>
<td width="24">
<? if ($row['equipomus']==1){echo "<img src='images/iconosact/hifi.gif' width='24' height='24' alt='Radio
'>";}else{echo "<img src='images/iconosinact/hifi.gif' width='24' height='24' alt='Radio'>";}?>
</td>
<td width="24">
<? if ($row['lavadora']==1){echo "<img src='images/iconosact/lavadora.gif' width='24' height='24' alt='Wasmachine
'>";}else{echo "<img src='images/iconosinact/lavadora.gif' width='24' height='24' alt='Wasmachine'>";}?>
</td>
<td width="24">
<? if ($row['microhondas']==1){echo "<img src='images/iconosact/microhondas.gif' width='24' height='24' alt='Magnetron
'>";}else{echo "<img src='images/iconosinact/microhondas.gif' width='24' height='24' alt='Magnetron'>";}?>
</td>
<td width="24">
<? if ($row['tele']==1){echo "<img src='images/iconosact/tv.gif' width='24' height='24' alt='TV
'>";}else{echo "<img src='images/iconosinact/tv.gif' width='24' height='24' alt='TV'>";}?>
</td>
</tr>
<tr>
<td height="28">
<? if ($row['Aire_Acond']==1){echo "<img src='images/iconosact/airco.gif' width='24' height='24' alt='Airconditioning
'>";}else{echo "<img src='images/iconosinact/airco.gif' width='24' height='24' alt='Airconditioning'>";}?>
</td>
<td>
<? if ($row['basket']==1){echo "<img src='images/iconosact/basket.gif' width='24' height='24' alt='Basketbalveld
'>";}else{echo "<img src='images/iconosinact/basket.gif' width='24' height='24' alt='Basketbalveld'>";}?>
</td>
<td>
<? if ($row['cajafuerte']==1){echo "<img src='images/iconosact/cajafuerte.gif' width='24' height='24' alt='Kluisje
'>";}else{echo "<img src='images/iconosinact/cajafuerte.gif' width='24' height='24' alt='Kluisje'>";}?>
</td>
<td>
<? if ($row['entornoint']==1){echo "<img src='images/iconosact/entornointeres.gif' width='24' height='24' alt='Mooie omgeving
'>";}else{echo "<img src='images/iconosinact/entornointeres.gif' width='24' height='24' alt='Mooie omgeving'>";}?>
</td>
<td>
<? if ($row['futbol']==1){echo "<img src='images/iconosact/futbol.gif' width='24' height='24' alt='Voetbalveld
'>";}else{echo "<img src='images/iconosinact/futbol.gif' width='24' height='24' alt='Voetbalveld'>";}?>
</td>
<td>
<? if ($row['horno']==1){echo "<img src='images/iconosact/horno.gif' width='24' height='24' alt='Oven
'>";}else{echo "<img src='images/iconosinact/horno.gif' width='24' height='24' alt='Oven'>";}?>
</td>
<td>
<? if ($row['lavavajillas']==1){echo "<img src='images/iconosact/lavavajillas.gif' width='24' height='24' alt='Vaatwasser
'>";}else{echo "<img src='images/iconosinact/lavavajillas.gif' width='24' height='24' alt='Vaatwasser'>";}?>
</td>
<td>
<? if ($row['minusvalidos']==1){echo "<img src='images/iconosact/lavavajillas.gif' width='24' height='24' alt='Toegankelijk voor gehandicapten
'>";}else{echo "<img src='images/iconosinact/lavavajillas.gif' width='24' height='24' alt='Toegankelijk voor gehandicapten'>";}?>
</td>
<td>
<? if ($row['zonacomer']==1){echo "<img src='images/iconosact/zonacomercial.gif' width='24' height='24' alt='Winkel centrum
'>";}else{echo "<img src='images/iconosinact/zonacomercial.gif' width='24' height='24' alt='Winkel centrum'>";}?>
</td>
</tr>
<tr>
<td height="28">
<? if ($row['parabolica']==1){echo "<img src='images/iconosact/parabolica.gif' width='24' height='24' alt='Satelliet tv
'>";}else{echo "<img src='images/iconosinact/parabolica.gif' width='24' height='24' alt='Satelliet tv'>";}?>
</td>
<td>
<? if ($row['Mascota']==1){echo "<img src='images/iconosact/perro.gif' width='24' height='24' alt='Huisdieren toegestaan
'>";}else{echo "<img src='images/iconosinact/perro.gif' width='24' height='24' alt='Huisdieren toegestaan'>";}?>
</td>
<td>
<? if ($row['tranquilo']==1){echo "<img src='images/iconosact/tranquilo.gif' width='24' height='24' alt='Rustige omgeving
'>";}else{echo "<img src='images/iconosinact/tranquilo.gif' width='24' height='24' alt='Rustige omgeving'>";}?>
</td>
<td>
<? if ($row['video']==1){echo "<img src='images/iconosact/video.gif' width='24' height='24' alt='Televisie met video
'>";}else{echo "<img src='images/iconosinact/video.gif' width='24' height='24' alt='Televisie met video'>";}?>
</td>
<td>
<? if ($row['Piscina']==1){echo "<img src='images/iconosact/piscina.gif' width='24' height='24' alt='Televisie met video
'>";}else{echo "<img src='images/iconosinact/piscina.gif' width='24' height='24' alt='Televisie met video'>";}?>
</td>
<td>
<? if ($row['zonaocionoc']==1){echo "<img src='images/iconosact/ocionoct.gif' width='24' height='24' alt='Nabij gelegen nachthoreca
'>";}else{echo "<img src='images/iconosinact/ocionoct.gif' width='24' height='24' alt='Nabij gelegen nachthoreca'>";}?>
</td>
<td>
<? if ($row['Garaje']==1){echo "<img src='images/iconosact/parking.gif' width='24' height='24' alt='Parkeer gelegenheid
'>";}else{echo "<img src='images/iconosinact/parking.gif' width='24' height='24' alt='Parkeer gelegenheid'>";}?>
</td>
<td>
<? if ($row['tenis']==1){echo "<img src='images/iconosact/tenis.gif' width='24' height='24' alt='Tennisveld
'>";}else{echo "<img src='images/iconosinact/tenis.gif' width='24' height='24' alt='Tennisveld'>";}?>
</td>
<td> </td>
</tr>
<tr>
<td height="28" colspan="9"> </td>
</tr>
</table></td>
</tr>
</table>

Elhombrebala

How can I make it easy for U?

LordShryku

Probably start by asking the right question....

Tracer

$sql="SELECT ID FROM (YourDbName) WHERE 10=pepe";
$result=mysql_query($sql, $connection);

while($row=mysql_fetch_array($result))
{
	echo "Here is my html with id #'s: $row[1] <br>";
}

Elhombrebala

Dear LordShryku, actually I'm not a computer, maybe this is why my way of thinking is not stuck to 1 or 0.
If I ask if it is possible maybe I can have just a simple "yes" as an answer, but then I can always post the question "how".
I guess you are not a machine neither, so maybe I do not need to improve my code to be understand by you: in humna comunication both parts can make an effort for approaching positions and for common understanding.
Do not worry anyway: Next time I will make a logical question explained under logical code.
Thank you!

Tracer

Elhombrebala,

Im not sure about LordShryku...But I'm not actually sure what that means.....

Your question was sort of vague..at best.... It's customary to post your code and a description of the problem when asking for help.....

Elhombrebala

Is it enough for you like this?
The fields in the table DatosInmueble in my DB are:
Numero Foto1 Tipo Localidad Zona Dirección Habitaciones Banyos Superficie Precio Descripcion Gas Aire_Acond Pta_Blindada Ascensor Garaje Trastero Calefaccion Terraza Armarios Balcon Piscina cocinael cocinagas lavavajillas lavadora cafetera microhondas horno zonajuegos basket futbol tenis accesplaya minusvalidos tele parabolica video equipomus cajafuerte tranquilo entornoint zonacomer zonaocionoc calific tren carretera aeropuerto iglesia todoelagno masde1 masde2 metrosplaya metroscentro alarma toilet Ref Mascota Familias Pensionistas Gentejoven Indiferente Inmo Conjunto Sesion

From those I only want to show:

Foto1 Descripcion Aire_Acond Ascensor Garaje Calefaccion Piscina lavavajillas lavadora cafetera microhondas horno zonajuegos basket futbol tenis accesplaya minusvalidos tele parabolica video equipomus cajafuerte tranquilo entornoint zonacomer zonaocionoc calific

In this way:

<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>Foto1</td>
<td>Descripcion </td>
<td><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>minusvalidos</td>
<td>entornoint</td>
<td>tranquilo </td>
<td>zonacomer</td>
<td>zonaocionoc</td>
<td>Garaje</td>
<td>Piscina</td>
<td>zonajuegos</td>
<td>basket futbol</td>
</tr>
<tr>
<td>Ascensor</td>
<td>accesplaya</td>
<td>tenis</td>
<td>Aire_Acond</td>
<td>Calefaccion</td>
<td>cajafuerte</td>
<td>lavadora</td>
<td>microhondas</td>
<td>lavavajillas</td>
</tr>
<tr>
<td>cafetera</td>
<td>horno </td>
<td>parabolica </td>
<td>equipomus</td>
<td>video</td>
<td>tele</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>calific </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>

Where

Foto1 = Thumbnail
Descripcion = Short description of an apartment

Aire_Acond Ascensor Garaje Calefaccion Piscina lavavajillas lavadora cafetera microhondas horno zonajuegos basket futbol tenis accesplaya minusvalidos tele parabolica video equipomus cajafuerte tranquilo entornoint zonacomer zonaocionoc

Those are checkboxes, several Icons will be activated if they are 1 or 0
calific = This a ranking between 1 and 5, that shows the quality of apartment, in works showing 1 gif with a star depending on ranking
1 = 1 star
2 = 2 stars
and follows