|
|
Posted by Joseph Melnick on 06/17/05 15:45
Hello The Legend,
How is $query set? If it is posted from a form or in the query string of a
url or is it a cookie it is not evident here?
Turn on errors and warnings
Remove the @ in front of your function calls and you may notice that
something is not being set.
Joseph Melnick
JM Web Conultants.
http://www.jphp.com/
"The Legend" <inavlid@invalid.com> wrote in message
news:42b26e66$0$10548$e4fe514c@news.xs4all.nl...
>
> "J.O. Aho" <user@example.net> schreef in bericht
> news:3hetlkFgs1v8U1@individual.net...
>> The Legend wrote:
>>
>>> $sql = "SELECT m.naam,m.bedrijfsnaam,m.plaats,m.soort,m.titel,
>>> FROM mb_advertentie m,mb_categorie c
>>> where m.id=$query
>>> and m.cid=c.id";
>>> $result = mysql_query($sql);
>>>
>>> while ($resultat = @mysql_fetch_array($result))
>>>
>>> include "templates/b_advertentie.htm";
>>> ?>
>>> -----------------
>>
>> As we can't see how your templates/b_advertentie.htm we can't say what
>> goes wrong (that file is included for each time there is a row in the
>> mysql database).
>>
>> //Aho
>
>
> hmm strange i did put that in my first post but here it is again:
> -----
> <tr>
> <tr bgcolor="<?php echo"$tabletop"; ?>">
> <td><?php echo"<font face=$b_fontface size=$b_fontsize color=$Tlink>";
> ?><?php echo"<b>$resultat[m.soort]</b>"; ?></td>
> <td><?php echo"<font face=$b_fontface size=$b_fontsize color=$Tlink>";
> ?><?php echo"<b>$resultat[m.titel]</b>"; ?></td>
> <td><?php echo"<font face=$b_fontface size=$b_fontsize color=$Tlink>";
> ?><?php echo"<b>$resultat[m.naam]</b>"; ?></td>
> <td><?php echo"<font face=$b_fontface size=$b_fontsize color=$Tlink>";
> ?><?php echo"<b>$resultat[m.bedrijfsnaam]</b>"; ?>
> <td><?php echo"<font face=$b_fontface size=$b_fontsize color=$Tlink>";
> ?><?php echo"<b>$resultat[m.plaats]</b>"; ?>
> </td>
>
> </tr>
> ----
>
>
> seems ok to me but no result is parsed into the html but when i do a
> select
> * from (1 table) parsing is there.
>
>
> would be thankfull with any help on this
>
> gr,
>
> Ed
>
>
Navigation:
[Reply to this message]
|