-
Posts
96 -
Joined
-
Last visited
Everything posted by frobak
-
thanks Mr Adam. I didnt alter the png fix, i just made the buttons jpg instead, which worked fine. Thanks for pointing me in the right direction. been stuck on this for about a week :'(
-
mmmm, i think not. how did you come to that conclusion? if i remove all styling, the text link is visible and underlined, but just not clickable?
-
/* ---------------------------- styles for job /vacancies page -------------------------------*/ #add_vacancy{ margin: 20px 0 0 0; width: 805px; position: relative; float: left; } #search_main_text{ margin: 0px 0 25px 0; padding: 25px 0 15px 0; width: 798px; height: 370px; overflow: auto; position: relative; float: left; border: 2px solid #cccccc; } .briefdesc { margin: 0px 0 10px 27px; padding: 0; width: 729px; height: 113px; position: relative; float: left; background: url(../images/vacancy_holder.png) no-repeat; } .desc_title{ margin: 20px 5px 0px 20px; padding: 0; width: 300px; height: 70px; position: relative; float: left; } .desc_details{ margin: 20px 5px 0px 0px; padding: 0; width: 270px; height: 70px; position: relative; float: left; } .desc_more{ margin: 20px 5px 0px 0px; padding: 0; width: 100px; height: 70px; position: relative; float: left; } img.more { margin: 50px 0px 0px 0px; padding: 0; width: 96px; height: 27px; position: relative; float: left; border: 0; } .title_text { margin: 0px 0 5px 0px; padding-top: 0; font-size: 12pt; font-weight: bold; color: #3366ff; text-decoration: none; font-family: tahoma, sans-serif; } .detail_text { height: 20px; margin: 0px 0 10px 0px; padding-top: 0; font-size: 9pt; font-weight: bold; color: black; text-decoration: none; font-family: tahoma, sans-serif; } #search_filter { margin: 0px 0 15px 40px; width: 740px; height: 45px; position: relative; float: left; } #filter_form { margin: 13px 0 0px 40px; width: 250px; height: 30px; position: relative; float: left; } img.filter { margin: 0px 0 0px 0px; position: relative; float: left; } .vacancydetail_btn { position: absolute; top: 60px; left: 600px; border: 0; text-decoration: none; } .viewvacbut { margin: 40px 0 0 0; width: 97px; height: 27px; position: relative; float: left; border: 0; text-decoration: none; }
-
heres the source from the output, looks ok to me! <div class='briefdesc'> <div class='desc_title'> <p class='title_text'>Senior Project Accountant - Cyprus</p> <p class='title_text'>Permanent</p> </div> <div class='desc_details'> <table> <tr> <td class='detail_text'>Location: </td> <td class='detail_text'>Limassol, Cyprus </td> </tr> <tr> <td class='detail_text'>Salary: </td> <td class='detail_text'>£70,000 - £110,000 </td> </tr> <tr> <td class='detail_text'>Contract: </td> <td class='detail_text'>Permanent </td> </tr> </table> </div> <div class='desc_more'> <a class='viewvacbut' href='view_vacancy_details.php?vacancy_id=MT 1001-13'><img class='no_marg' src='images/more_btn.png' /></a> </div> </div>
-
Heres the code thats displaying a div and link depending on how many rows in the db. this works in ie7/ie8 all firefox versions, safari, everythign except the dreaded ie6. thanks in advance1 <div id="search_main_text"> <?php include("includes/db_connect.inc.php"); $query= $filter; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $vacancy_id = mysql_result($result,$i,'vacancy_id'); $job_title = mysql_result($result,$i,'job_title'); $salary = mysql_result($result,$i,'salary'); $location = mysql_result($result,$i,'location'); $terms = mysql_result($result,$i,'terms'); echo " <div class='briefdesc'> <div class='desc_title'> <p class='title_text'>$job_title</p> <p class='title_text'>$terms</p> </div> <div class='desc_details'> <table> <tr> <td class='detail_text'>Location: </td> <td class='detail_text'>$location </td> </tr> <tr> <td class='detail_text'>Salary: </td> <td class='detail_text'>$salary </td> </tr> <tr> <td class='detail_text'>Contract: </td> <td class='detail_text'>$terms </td> </tr> </table> </div> <div class='desc_more'> <a class='viewvacbut' href='view_vacancy_details.php?vacancy_id=$vacancy_id'><img class='no_marg' src='images/more_btn.png' /></a> </div> </div> "; $i++; } ?> </div> </div>
-
Ive tried this without any variables. So this code is just dynamically displaying a link? why am i finding this difficult? surely im missing something really simple?
-
http://www.enetdesign.co.uk/onyx/view_vacancies.php cheers
-
once your happy with the users login details, add the username to global variable: $_SESSION['username'] = $username; and then display it as you would any other variable: <?php echo $_SESSION['username']; ?> Any good to ya?
-
Hi Ive got some php code thats dynamically generating a div with a link inside. For some reason the link is not clickable in ie6. Is this right or have i done something wrong? PHP Code: <div class='briefdesc'> <div class='desc_title'> <p class='title_text'>$job_title</p> <p class='title_text'>$terms</p> </div> <div class='desc_details'> <table> <tr> <td class='detail_text'>Location: </td> <td class='detail_text'>$location </td> </tr> <tr> <td class='detail_text'>Salary: </td> <td class='detail_text'>$salary </td> </tr> <tr> <td class='detail_text'>Contract: </td> <td class='detail_text'>$terms </td> </tr> </table> </div> <div class='desc_more'> <a class='viewvacbut' href='view_vacancy_details.php?vacancy_id=$vacancy_id'><img class='no_marg' src='images/more_btn.png' /></a> </div> </div> so the link to view_vacancy_details.php is not clickable in ie6. Your thoughts. Should this work?
-
Hi Is it possible to use get_file_contents to retreive code(from the same server but different domain) without running the php code inside the included file. I want to use a local include inside the retreived contents. is it possible to stop the code running on the original server? the following code works, pulling the content from the central file: <?php $xx = file_get_contents("http://www.mkoneweb.co.uk/central_includes/test.inc.php"); echo $xx; ?></p> but i want to have a local variable inside the contents of the retreived file: <? include("includes/area.inc.php"); ?> anyway to control when this code will run? Any help would be much appreciated cheers
-
that worked, many thanks how do i set the post as solved?
-
thanks but i get the following errors after changing as above: Warning: mysql_result() [function.mysql-result]: DATE_FORMAT not found in MySQL result index 4 in /home/frobakco/public_html/rockinghorsenights.com/eventpage.php on line 47 Warning: mysql_result() [function.mysql-result]: band_name not found in MySQL result index 4 in /home/frobakco/public_html/rockinghorsenights.com/eventpage.php on line 48 Warning: mysql_result() [function.mysql-result]: narrative not found in MySQL result index 4 in /home/frobakco/public_html/rockinghorsenights.com/eventpage.php on line 49 heres the full php code: <?php include("includes/db_connect.inc.php"); $query="SELECT DATE_FORMAT(event_date,'%d/%m/%Y') FROM events WHERE event_date >= CURDATE() ORDER BY event_date"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $event_date = mysql_result($result,$i,'event_date'); $band_name = mysql_result($result,$i,'band_name'); $narrative = mysql_result($result,$i,'narrative'); echo "<div id='eventbox'> <table id='events'> <th colspan='2'>$event_date </th> <tr> <th>$band_name </th> </tr> <tr> <td id='events'>$narrative </td> </tr> </table> </div>"; $i++; } ?>
-
no, just as date!
-
Hi Im trying to format mysql dates to uk dd/mm/yyyy in a select statement and im struggling to get it to work. Heres the select statement: $query="SELECT * FROM events WHERE event_date >= CURdate() ORDER BY event_date ASC"; ive tried this and it didnt work? $query="SELECT * FROM events WHERE DATE_FORMAT(event_date,'%d/%m/%Y') >= CURdate() ORDER BY event_date ASC"; any help would be appreciated cheers
-
[SOLVED] getting a variable to display another variable, possible?
frobak replied to frobak's topic in PHP Coding Help
yeah that worked. I had the actual $ in the table row, which wasnt working, so i took it off and did the above and it worked. thanks -
is it possible? i want to use a variable to display another variable thats populated by a mysql query? so far what happens is that it just prints the variable in the html page, and doesnt treat it as a variable. I am displaying the contect dynamically. basically $dl_count value is $dl_count_show1 it prints $dl_count_show1 in the html, but it should display the value of the variable, which is the result of a mysql query counting instances of a database row. hope ive explained that ok heres the code: $query="SELECT * FROM pbzarchive ORDER BY date_added"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $mix_title = mysql_result($result,$i,'mix_title'); $djname = mysql_result($result,$i,"djname"); $mix_length = mysql_result($result,$i,"mix_length"); $mix_size = mysql_result($result,$i,"mix_size"); $filename = mysql_result($result,$i,"filename"); $dl_count = mysql_result($result,$i,"dl_count"); echo "<div class='mix'> <table id='mix'> <th colspan='2'>$mix_title </th> <tr> <td id='mix'>DJ's : </td> <td id='mix'>$djname </td> </tr> <tr> <td id='mix'>Mix length : </td> <td id='mix'>$mix_length </td> </tr> <tr> <td id='mix'>Mix size : </td> <td id='mix'>$mix_size </td> </tr> <tr> <td id='mix'><A href='../downloads/$filename.php' onClick='popup = window.open('downloads/$filename.php', 'PopupPage', 'height=135,width=265,scrollbars=no,resizable=no'); return false' target='_blank'>Download</a> </td> <td id='mix'>"; print $dl_count; echo " </td> </tr> </table> </div>"; $i++; } ?>
-
Hi I am trying to count the number of instances of a field in a database table. So basically i want it to count how many times a value occurs and group them by value. I then want to display each count instance seperately. How would i get the result from the array and into a variable so i can use it? <?php include("includes/db_connect.inc.php"); $sql = "SELECT downloadid, COUNT(*) FROM downloadcount GROUP BY downloadid "; $result = mysql_query($sql); $row = mysql_fetch_array($result); $num1 = mysql_num_rows($row); ?>
-
i tried it because it wasnt working when i concatenated the variable to the php code in the html? just trying other things
-
right, so basically i cannot have some php code in my dynamically displayed html, it just doesnt recognise the code
-
so when i view the source, the correct code is there: <?php echo $dl_count_show1neilsodfrobak; ?> but it doesnt display the variable, it doesnt write it in html either? wtf?
-
what are short tags? what are code tags? $dl_count_show1neilsodfrobak is the result of a mysql query counting the instances of show1neilsodfrobak in the table, and returning the amount of rows. i cant use it instead of $dl_count, because theres many rows so i need each one to have its own code
-
Heres the dynamically produced content At the end of the download link, there should be a download count, the variable $dl_count, the value of download count is <?php echo $dl_count_show1neilsodfrobak; ?> <? include("includes/db_connect.inc.php"); $query="SELECT * FROM pbzarchive ORDER BY date_added"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $mix_title = mysql_result($result,$i,'mix_title'); $djname = mysql_result($result,$i,"djname"); $mix_length = mysql_result($result,$i,"mix_length"); $mix_size = mysql_result($result,$i,"mix_size"); $filename = mysql_result($result,$i,"filename"); $dl_count = mysql_result($result,$i,"dl_count"); echo "<div class='mix'> <table id='mix'> <th colspan='2'>$mix_title </th> <tr> <td id='mix'>DJ's : </td> <td id='mix'>$djname </td> </tr> <tr> <td id='mix'>Mix length : </td> <td id='mix'>$mix_length </td> </tr> <tr> <td id='mix'>Mix size : </td> <td id='mix'>$mix_size </td> </tr> <tr> <td id='mix'><A href='../downloads/$filename.php' onClick='popup = window.open('downloads/$filename.php', 'PopupPage', 'height=135,width=265,scrollbars=no,resizable=no'); return false' target='_blank'>Download</a>$dl_count </td> <td id='mix'> </td> </tr> </table> </div>"; $i++; } ?>
-
Hi i am trying to get a variable to be echo'd on a page that is being produced dynamically from a database table. So i have got the entire php code (<?php echo $dl_count_show1neilsodfrobak; ?>) in a database row and it should be returned in a html table row, but it doesnt work, even though when i view source the php code is there but it doesnt echo the variable. viewing through firefox view source the text is pink? any ideas?
-
ok, any chance you can kind of point me in the right direction?