frobak
-
Posts
96 -
Joined
-
Last visited
Posts posted by frobak
-
-
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> -
try putting the variable in quotes, like below?
<? echo "$number1"; ?>
-
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?
-
-
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
-
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?
dynamic links in ie6, possible?
in HTML Help
Posted
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 :'(