Menu
Community /Pin to ProfileBookmark
@NogDogMar 03.2005 — #
Help With Design
Hello forum
I need your help I have this:
<?php
mysql_data_seek($title_query, 0);
while ($title_result=mysql_fetch_array($title_query)){
$numJobs = mysql_result(mysql_query(“SELECT COUNT(*) FROM job_post WHERE JobCategory='{$title_result[‘jobcategory’]}'”), 0);
echo “”;
echo “<br><a href=”jobseekers/job-search2.php?JobCategory={$title_result[‘jobcategory’]}”>{$title_result[‘jobcategory’]} ($numJobs)</a>”;
echo ” “;
}
mysql_data_seek($title_query, 0)
?>
and result is this:
For ex.
Automative
Engineering
Hardware
Software
My question is how to make changes/design to have result in 2
Like this:
For ex.
Automative Hardware
Engineering Software
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogMar 03.2005 — #[code=php]
<?php
mysql_data_seek($title_query, 0);
$counter = 0; # track number of links displayed
while ($title_result=mysql_fetch_array($title_query)){
$numJobs = mysql_result(mysql_query("SELECT COUNT(*) FROM job_post WHERE JobCategory='{$title_result['jobcategory']}'"), 0);
# echo ""; (this does nothing)
$br = ($counter++ % 2 == 0) ? "<br>" : ""; # if divisble by 2 use <br>
echo "$br<a href="jobseekers/job-search2.php?JobCategory={$title_result['jobcategory']}">{$title_result['jobcategory']} ($numJobs)</a>n";
# echo " "; (adding linefeed to end of previous line makes this unnecessary
}
mysql_data_seek($title_query, 0)
?>
[/code]