Big problem for advanced coders

[webmark2004]

i think that is very difficult to do....

a simple example:

i have a db with postcards details inside it.
one of the 8 fields tell me the type : normal, for childen, for adult.

I would like to differentiate the html results depending on the type.

the normal will be a blue table, with 2 description fields, while the children one is green with 2 description fields and with an img and the adult one is red with 6 fields more.

i think that is very difficult to do....
isn't it ??

Thanks

[tekky]

not at all

[webmark2004]

sorry tekky, but i think i don't explain me very well...
the query is only one....
if, for example i search for "sport" postcard, in the page results i have both normal, for children and for adult postcards...
in this html page every single type have different table design....

sorry for my bad english...i hope u understand...

thanks for help.

webmarks

[tekky]

I understood the first time, and answered, it is not hard to do that, however without any code to help you with, I am not going to write it for you

attempt to solve the problem, you will need to use IF statements, and obviously the MYSQL statements... once you have a rought script written I'm sure more people will be willing to chime in and help you out

[webmark2004]

ok tekky....
is really my first time here....

i will post the code i'm trying to write...

thanks
webmarks

[webmark2004]

####index.php

elseif($GET[show] == all){
allpics();
}
elseif($GET[zona] && $GET[category]){
$query = mysql_query("select * from $tablenamep WHERE zona LIKE '%$GET[zona]%' && category LIKE '%$_GET[category]%'ORDER BY ".get_setting(orderpic));
$num = mysql_num_rows($query);

if($num == 0){
echo('nessuna palestra corrisponde ai requisiti');

}else{
$i = 0;
$category = get_picture(category);
while($picture = mysql_fetch_array($query))
{
if($i > $num){} else {
$category = get_picture(category);
$id = $picture[id];

include(get_setting(absolutepath).'/templates/view.php');
$i++;
}
}include(get_setting(absolutepath).'/templates/view.php

view.php

<tr>
<td width="241" rowspan="7" valign="top" bgcolor="#CCCCCC"></td>
<td width="191" valign="top"> <p><strong>nome :</strong> </p></td>
<td width="21" valign="top">
<?=get_picture(title)?>
</td>
<td width="72" valign="top"><strong>categoria:</strong></td>
<td width="175" valign="top"><?echo the_category($GET[cat]); ?></td>
<td width="175" valign="top">&nbsp;</td>
</tr>
<tr>
<td valign="top"><strong>zona :</strong> </td>
<td colspan="4"><?echo the_zone($GET[zone]);?></td>
</tr>

####

here what the function "the_category" do:
function the_category($cat){
global $tablenames, $id;
if($GET[cat]){ $cat = $GET[cat]; }
else{ $cat = get_picture(category); }
$query = mysql_query("SELECT name from $tablenames WHERE id='".$cat."'") or die(mysql_error());
$get = mysql_fetch_array($query);
echo $get[name];
}

can i have "flexible objects" in my template file ?

webmark