Webwereld

PHP forum - stick

Gestart doorWiitse13 reacties38 weergaven
Log in om mee te praten

14 berichten · pagina 1 van 1

Wiitse

Lid · Topicstarter

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik gebruik FELS en ik wil in het forum net zoals op one2xs een stick op forums te kunnen zetten. (Zoals de regels en het offtopic topic). Ik heb al een tabel met de naam stick. Dit is de code waarin de volgorde word bepaald:

$tQuery = mysql_query("SELECT * FROM forum_topics WHERE forum = ".$fFetch[id]." ORDER BY ldatum DESC");


Als ik wil dat hij word gesorteerd op of ie een stick heeft of niet doe ik dit:

$tQuery = mysql_query("SELECT * FROM forum_topics WHERE forum = ".$fFetch[id]." ORDER BY stick DESC");


Maar nu wil ik dat het beide tegelijk gebeurd! Ik wil dat de topics met in het tabel "stick" een 1 bovenaan staan. En net zoals in het offtopic forum wel eens gebeurd wil ik dan ook dat als er 2 topics in hetzelfde forum een stick hebben die wel worden gesorteerd op datum.
Dit is vast niet moeilijk voor iemand die php kan maar ik ben redelijk noob. yummie
0
Andydewit

Lid

Berichten
1.168
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Je kan 2 whiles doen, zoiets als dit:

[COLOR= #0000BB]<?php
$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick=1"[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #FF8000]// Hier dan de topics[/COLOR]
[COLOR= #007700]}[/COLOR]

[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick=0"[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #FF8000]// Hier dan de topics[/COLOR]
[COLOR= #007700]}[/COLOR]
?>


Dan zet hij de topics mét stick bovenaan, want die selecteert hij eerst, en daarna komen de topics zonder stick.
0
Wiitse

Lid · Topicstarter

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Bedankt voor je reactie, maar ik ben een echte php noob dus ik snap niet hoe ik dit er dan in zet. bloos Dit is het stukje dat in FELS staat en wat ik dan denk ik moet veranderen:

$tQuery = mysql_query("SELECT * FROM forum_topics WHERE forum = ".$fFetch[id]." ORDER BY ldatum DESC");


            if(mysql_num_rows($tQuery) == 0){

                echo "Er zijn nog geen topics in dit fora";

            }

            else{

                echo "<br /><table>";

                    echo "<tr>";

                    echo "<td width=16px></td>";

                    echo "<td width=300px><b>Onderwerp</b></td>";

                    echo "<td><b>Reacties</b></td>";

                    echo "</tr>";

                while($tFetch = mysql_fetch_assoc($tQuery)){

                    echo "<tr>";

                    echo "<td width=16px>".topic_gelezen($tFetch[id], $_SESSION[uId])."</td>";

                    echo "<td width=300px><a href="._ROOT_."topic/".$tFetch[id].">".htmlentities($tFetch[onderwerp])."</a></td>";

                    echo "<td>".number_format($tFetch[reacties], 0, ,, .)."</td>";

                    echo "</tr>";

                }

                echo "</table>";


Aangezien jij veel beter in php bent, wil je dit bewerken?smile
0
Andydewit

Lid

Berichten
1.168
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php
$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 1 ORDER BY ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$tQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 1 ORDER BY ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]


            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tQuery[/COLOR][COLOR= #007700]) && ![/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700])){[/COLOR]

                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Er zijn nog geen topics in dit fora"[/COLOR][COLOR= #007700];

            }[/COLOR]

            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]

                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<br /><table>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px></td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=300px><b>Onderwerp</b></td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td><b>Reacties</b></td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];[/COLOR]

                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tQuery[/COLOR][COLOR= #007700])){[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px>"[/COLOR][COLOR= #007700].[/COLOR]topic_gelezen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=300px><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"topic/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reacties[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000],[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000].[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];

                }[/COLOR]

                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tQuery[/COLOR][COLOR= #007700])){[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px>"[/COLOR][COLOR= #007700].[/COLOR]topic_gelezen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=300px><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"topic/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reacties[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000],[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000].[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];

                }[/COLOR]

                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table>"[/COLOR][COLOR= #007700];[/COLOR]
?>


Zoiets ongeveer (even snel gedaan)
0
Mauriceb

Lid

Berichten
545
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
EDIT: Andy was me voor.
0
Wiitse

Lid · Topicstarter

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Bedankt! Ik ga het nu uittesten. smile
EDIT:// Werkt niet? confused Er zit denk ik een klein foutje in. Er komt geen foutmelding maar de topics worden gewoon niet getoond, maar de melding dat er geen topics zijn komt ook niet.

EDIT 2:// Die foutmelding komt in de ene categorie wel en de andere niet. confused
0
Andydewit

Lid

Berichten
1.168
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Kan je de foutmelding misschien geven, of de url?
0
Wiitse

Lid · Topicstarter

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Url is nog geheim. Als je zweert het niet door te vertellen stuur ik het in pb. wink yummie
EDIT:// Andydewit is bezig het de fixen! biggrin
0
Andydewit

Lid

Berichten
1.168
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Probleem opgelost:

[COLOR= #0000BB]<?php
$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 1 ORDER BY ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$tQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 0 ORDER BY ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]


            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tQuery[/COLOR][COLOR= #007700]) && ![/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700])){[/COLOR]

                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Er zijn nog geen topics in dit fora"[/COLOR][COLOR= #007700];

            }[/COLOR]

            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]

                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<br /><table>"[/COLOR][COLOR= #007700];[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=300px><b>Onderwerp</b></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td><b>Reacties</b></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];[/COLOR]

                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700])){[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px>"[/COLOR][COLOR= #007700].[/COLOR]topic_gelezen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=300px><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"topic/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reacties[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000],[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000].[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];

                }[/COLOR]

                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tQuery[/COLOR][COLOR= #007700])){[/COLOR]

                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px>"[/COLOR][COLOR= #007700].[/COLOR]topic_gelezen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=300px><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"topic/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reacties[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000],[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000].[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];

                }[/COLOR]

                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table>"[/COLOR][COLOR= #007700];
            }[/COLOR]
?>
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Waarom 2 queries en niet gewoon 1 query?

[COLOR= #0000BB]<?php
$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 1 ORDER BY stick DESC, ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]
0
Andydewit

Lid

Berichten
1.168
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Kan ook, is nog beterwink
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
En vervang dan ook meteen die SELECT * smile
[COLOR= #0000BB]<?php
$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT stick, id, onderwerp, reacties FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 1 ORDER BY stick DESC, ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]


met if($tFetch[stick] == 1) kun je checken of iets een sticky is, maar dat weet je denk wel.
0
Wiitse

Lid · Topicstarter

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hier kan iig wel een slotje op want het werkt. smileHeel erg bedankt!
0
Simon

Lid

Berichten
262
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Lennard schreef:
En vervang dan ook meteen die SELECT * smile
[COLOR= #0000BB]<?php
$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT stick, id, onderwerp, reacties FROM forum_topics WHERE forum = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$fFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND stick = 1 ORDER BY stick DESC, ldatum DESC"[/COLOR][COLOR= #007700]);[/COLOR]
aanvulling op lennard
dit is puur om je query sneller op te halen.
erg belangrijk als je een paar duizent rijen in je database.
zie deze slordigheids foutjes wel vaak hier in scripts staan.
nou ja is niet een echt foutje. maar vertraagt je query!
is maaar een tippompom
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren