Jump to content

sam123

Members
 View Profile  See their activity

  • Posts

    44

  • Joined

  • Last visited

 Content Type 

Everything posted by sam123

  1. sam123
    Your code works great. Thank you so much mac_gyver. With your help I have got a better approach for the code. Thanks a lot.
  2. sam123
    Modified code is here. Please let me know if you can suggest anything else on modifiying the code. //Send mail two days prior to deadline if ($diff == "-2") || ($diff == "-1") { //Selecting emails $dquery = "select * from users where uid ='$aid'"; // echo"<br>dquery=$dquery<br>"; $dresult = mysql_query($dquery) or die("".mysql_errno()." Error: ".mysql_error()); if(mysql_num_rows($dresult) > 0) { $recipients = array(); while($row = mysql_fetch_array($dresult)) { $recipients[] = $row['email']; // echo '<span style="color:#FF7600">',$row['email'], '</span>'; } } //Sending message $subject = "Job $id is due on $ddate"; $message .= "<html><body><table width=500 border=1px solid #ccc align=center cellpadding=0 cellspacing=0 bgcolor=#E8E8E8>"; $message .="<tr><th colspan=2 align=center bgcolor=#4D4D4D height=26><b>"; $message .= "Job Details</b> </th></tr>"; $message .= "<tr><th width=120 align=left>Id:</th><th width=280 align=left>$id</th></tr>"; $message .= "<tr><th width=120 align=left>Created By: </th><th width=280 align=left> $owner</th></tr>"; $message .= "<tr><th width=120 align=left>Deadline:</th><th width=280 align=left> $ddate</th></tr>"; $message .= "</table>"; $message .= "</body></html>"; $adminemail = "admin@website.com"; $headers .= "From:{$adminemail}". "\r\n"; $headers .= 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; foreach ($recipients as $to) { $success = mail($to,$subject,$message,$headers); } if ($success) { echo "Due Reminder send successfully to the following recipients.<br>"; echo "Name:$aname - Id:$id <br>"; } else { echo "Something wrong happend.Please try again."; } }//end if //Send mail if the job is overdue if ($diff > "0") { //Selecting emails $dquery = "select * from users where uid ='$aid'"; // echo"<br>dquery=$dquery<br>"; $dresult = mysql_query($dquery) or die("".mysql_errno()." Error: ".mysql_error()); if(mysql_num_rows($dresult) > 0) { $recipients = array(); while($row = mysql_fetch_array($dresult)) { $recipients[] = $row['email']; //echo '<span style="color:#FF7600">',$row['email'], '</span>'; } } //Sending message $subject = "Job $id is Overdue by $diff"; $message .= "<html><body><table width=500 border=1px solid #ccc align=center cellpadding=0 cellspacing=0 bgcolor=#E8E8E8>"; $message .="<tr><th colspan=2 align=center bgcolor=#4D4D4D height=26><b>"; $message .= "Job Details</b></th></tr>"; $message .= "<tr><th width=120 align=left>Id:</th><th width=280 align=left> $id</th></tr>"; $message .= "<tr><th width=120 align=left>Created By: </th><th width=280 align=left> $owner</th></tr>"; $message .= "<tr><th width=120 align=left>Deadline:</th><th width=280 align=left> $ddate</th></tr>"; $message .= "</table>"; $message .= "</body></html>"; $from = "admin@website.com"; $adminemail = "admin@website.com"; $headers .= "From:{$adminemail}". "\r\n"; $headers .= "Cc: $remail\r\n"; $headers .= 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; foreach ($recipients as $to) { $success = mail($to,$subject,$message,$headers); } if ($success) { echo "Job Over Due Reminder send successfully to the following recipients.<br>"; echo "Name:$aname - Id:$id <br>"; } else { echo "Something wrong happend.Please try again."; } }//end if } // end reminder
  3. sam123
    Thank you somuch for your valuable reply mac_gyver. I have modified the code according to your suggestion, but still having the problem. In user table i am saving all the user details and job table i am saving all the job details. Here is the example. id---------Job -------------rname-----------remail-----------------------deadline-------status-------aname----aid-----createdby 1 -----Test Job1----------Sam--------sam@test.com----------2013-06-20------Open---------sara------12--------Sam 2 -----Test Job2---------David-------david@test.com---------2013-06-18------Open---------Jim-------10--------David 3 -----Test Job3---------Don---------don@test.com-----------2013-06-19------Open---------Kale------8----------Don rname-requestername and aname-assignee name. I am not saving assignees email id in the job table,it is stored in the user table and i am getting the assignees email using aid $dquery = "select * from users where uid ='$aid'. But the poblem what i am facing is that if the job is over due, as i told you earlier, i need to send that to supervisor also. That email(remail) i am getting from the job table directly since i saved it while creating the job. So it will be on the first loop while ($raw = mysql_fetch_array($scheduleResult)) { $remail = $raw['remail']; } so it is taking all the $remail values for the cc feild. In the above example, 2 jobs crossed the deadline. While sending email to the assignee, it will send cc mails to both requesters david@test.com and don@test.com. But i want to testjob2's cc email need to send only david@test.com and testjob3's cc mail need to send only to don@test .com. Now the the correct email is sending to the assignee with the corresponding job details.This part is working perfectly alright.. Sorry for the lengthy reply, i was working on this for this last couple of days ,but in vain..I know iam doing something wrong here, but i could not figure it out. Thank you.
  4. sam123
    Is there any suggestion/solution for solving the cc field issue? Thanks in Advance.
  5. sam123
    Hi All, I have been working on an application where I need to send reminder mails to my users when the condition is met. I will send the reminder mail only to the users 2 days prior to the deadline. Once they crossed the deadline i need to send mail to users along with his supervisor(cc). My code is working perfectly on sending reminder mails to the users but cc to the supervisor part is not working. I have stored all the details to the same table while creating the job. $remail is the field where i am saving the supervisor email.Now the problem is that once the job is overdue its taking all the emails from the $remail instead of taking the jobs corresponding $remail. Can any one help me on this? Anyone have suggestions on a better way of getting this done? <?php //Send mail after checking the date difference $viewSchedule = "select * from job WHERE status = 'Open'"; $scheduleResult = mysql_query($viewSchedule,$link) or trigger_error("SQL", E_USER_ERROR); while ($raw = mysql_fetch_array($scheduleResult)) { $id=$raw['id']; $aid = $raw['aid']; $aname = $raw['aname']; $remail = $raw['remail']; $owner = $raw['owner']; $reminder = $raw['reminder']; $status=$raw['status']; $deadline = $raw['deadline']; $todaysdate = date("Y-m-d"); $date_diff=strtotime($todaysdate) - strtotime($deadline); $diff=($date_diff/(60 * 60 * 24)); $ddate = date('d-m-Y', strtotime($deadline)); //Cheking date difference //Send mail two days prior to deadline if ($diff == "-2") { //Selecting emails $dquery = "select * from users where uid ='$aid'"; // echo"<br>dquery=$dquery<br>"; $dresult = mysql_query($dquery) or die("".mysql_errno()." Error: ".mysql_error()); if(mysql_num_rows($dresult) > 0) { $recipients = array(); while($row = mysql_fetch_array($dresult)) { $recipients[] = $row['email']; // echo '<span style="color:#FF7600">',$row['email'], '</span>'; } } //Sending message $subject = "Job $id is due on $ddate"; $message .= "<html><body><table width=500 border=1px solid #ccc align=center cellpadding=0 cellspacing=0 bgcolor=#E8E8E8>"; $message .="<tr><th colspan=2 align=center bgcolor=#4D4D4D height=26><b>"; $message .= "Job Details</b> </th></tr>"; $message .= "<tr><th width=120 align=left>Id:</th><th width=280 align=left>$id</th></tr>"; $message .= "<tr><th width=120 align=left>Created By: </th><th width=280 align=left> $owner</th></tr>"; $message .= "<tr><th width=120 align=left>Deadline:</th><th width=280 align=left> $ddate</th></tr>"; $message .= "</table>"; $message .= "</body></html>"; $adminemail = "admin@website.com"; $headers .= "From:{$adminemail}". "\r\n"; $headers .= 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; foreach ($recipients as $to) { $success = mail($to,$subject,$message,$headers); } if ($success) { echo "Due Reminder (2 day Prior) send successfully to the following recipients.<br>"; echo "Name:$aname - Id:$id <br>"; } else { echo "Something wrong happend.Please try again."; } }//end if //Send mail one day prior to deadline if ($diff == "-1") { //Selecting emails $dquery = "select * from users where uid ='$aid'"; // echo"<br>dquery=$dquery<br>"; $dresult = mysql_query($dquery) or die("".mysql_errno()." Error: ".mysql_error()); if(mysql_num_rows($dresult) > 0) { $recipients = array(); while($row = mysql_fetch_array($dresult)) { $recipients[] = $row['email']; // echo '<span style="color:#FF7600">',$row['email'], '</span>'; } } //Sending message $subject = "Job $id is due on $ddate"; $message .= "<html><body><table width=500 border=1px solid #ccc align=center cellpadding=0 cellspacing=0 bgcolor=#E8E8E8>"; $message .="<tr><th colspan=2 align=center bgcolor=#4D4D4D height=26><font color=#FFFFFF face=Arial, Helvetica, sans-serif><b>"; $message .= "Job Details</b></th></tr>"; $message .= "<tr><th width=120 align=left>Id:</th><th width=280 align=left> $id</th></tr>"; $message .= "<tr><th width=120 align=left>Created By: </th><th width=280 align=left> $owner</th></tr>"; $message .= "<tr><th width=120 align=left>Deadline:</th><th width=280 align=left> $ddate</th></tr>"; $message .= "</table>"; $message .= "</body></html>"; $adminemail = "admin@website.com"; $headers .= "From:{$adminemail}". "\r\n"; $headers .= 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; foreach ($recipients as $to) { $success = mail($to,$subject,$message,$headers); } if ($success) { echo "Job Due Reminder (1 day Prior) send successfully to the following recipients.<br>"; echo "Name:$aname - Id:$id <br>"; } else { echo "Something wrong happend.Please try again."; } }//end if //Send mail if the job is overdue if ($diff > "1") { //Selecting emails $dquery = "select * from users where uid ='$aid'"; // echo"<br>dquery=$dquery<br>"; $dresult = mysql_query($dquery) or die("".mysql_errno()." Error: ".mysql_error()); if(mysql_num_rows($dresult) > 0) { $recipients = array(); while($row = mysql_fetch_array($dresult)) { $recipients[] = $row['email']; //echo '<span style="color:#FF7600">',$row['email'], '</span>'; } } //Sending message $subject = "Job $id is Overdue by $diff"; $message .= "<html><body><table width=500 border=1px solid #ccc align=center cellpadding=0 cellspacing=0 bgcolor=#E8E8E8>"; $message .="<tr><th colspan=2 align=center bgcolor=#4D4D4D height=26><b>"; $message .= "Job Details</b></th></tr>"; $message .= "<tr><th width=120 align=left>Id:</th><th width=280 align=left> $id</th></tr>"; $message .= "<tr><th width=120 align=left>Created By: </th><th width=280 align=left> $owner</th></tr>"; $message .= "<tr><th width=120 align=left>Deadline:</th><th width=280 align=left> $ddate</th></tr>"; $message .= "</table>"; $message .= "</body></html>"; $from = "admin@website.com"; $adminemail = "admin@website.com"; $headers .= "From:{$adminemail}". "\r\n"; $headers .= "Cc: $remail\r\n"; $headers .= 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; foreach ($recipients as $to) { $success = mail($to,$subject,$message,$headers); } if ($success) { echo "Job Over Due Reminder send successfully to the following recipients.<br>"; echo "Name:$aname - Id:$id <br>"; } else { echo "Something wrong happend.Please try again."; } }//end if } // end reminder ?>
  6. sam123
    Thanks for your help PFMaBiSmAd. Working perfectly now. Thanks again.
  7. sam123
    Hi PFMaBiSmAd, This the query i am using . $query="SELECT gc.category_id, gc.category_name, p.photo_id, p.photo_caption, p.photo_filename FROM gallery_category AS gc INNERJOIN photos AS p ON p.category_id = gc.category_id ORDERBY gc.category_id ASC , p.photo_id DESC"; and while running this query in phpmyadmin i am getting the following output. category_id ---/--- category_name ---/--- photo_id ---/--- photo_caption ---/--- photo_filename -------1----------/---- Test1------------/---- 54---------/---- test1-----------/--- 54.jpg --------1----------/---- Test2------------/----53---------/---- test2-----------/--- 53.jpg --------1----------/---- Test3------------/---- 52---------/---- test3-----------/--- 52.jpg --------1----------/---- Test4------------/---- 51---------/---- test4-----------/--- 51.jpg --------2----------/---- Test5------------/---- 55---------/---- test5-----------/--- 55.jpg----- Here is the html page code. <?php $title = "Photogallery"; include "header.php"; include "config.php"; //$catid = (int)($_GET['catid']); //$pid = (int)($_GET['pid']); // Category Listing //$number_of_categories_in_row = 4; ?> <div id="breadcrumbs"><a href="index.php">Home</a> / <span>Photogallery</span></div> <div class="left_side"> <h2>Photogallery</h2> <div class="left_side_content"> <!--p>Coming Soon...</p--> <!-- the tabs --> <?php $tab_content = ''; $gallery_content = ''; $last_gallery = null; $query = "SELECT gc.category_id, gc.category_name, p.photo_id, p.photo_caption, p.photo_filename FROM gallery_category AS gc INNER JOIN photos AS p ON p.category_id = gc.category_id ORDER BY gc.category_id ASC , p.photo_id DESC"; $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) {// category/tab values $catid = $row['category_id']; $category_name = $row['category_name']; // gallery values $photo_caption = $row['photo_caption']; $photo_filename = $row['photo_filename']; // build tab content if($last_gallery != $catid) { $tab_content .= "<li><a href='#' rel='view{$catid}'>$category_name</a></li>"; $last_gallery = $catid; } // build gallery content $gallery_content .= "<div id='view{$catid}' class='tabcontent'>"; $gallery_content .= "$photo_caption</br>"; $gallery_content .= "<img src='{$images_dir}/tb_{$photo_filename}' border='0'>"; $gallery_content .= "</div>"; } // output the HTML document - ?> <ul class="tabs"><?php echo $tab_content; ?></ul> <div class="tabcontents"><?php echo $gallery_content; ?></div> <!-- tab ends --> </div> </div> <?php include "sidebar.php"; ?> </div> <?php include "footer.php"; ?> Since i am still working on this, i am using this test data only. Thanks, Sam.
  8. sam123
    Thanks Christian. I changed int(20) to int(11). Also i changed the query as follows $query = "SELECT gc.category_id, gc.category_name, p.photo_id, p.photo_caption, p.photo_filename FROM gallery_category AS gc INNER JOIN photos AS p ON p.category_id = gc.category_id ORDER BY gc.category_id ASC , p.photo_id DESC"; But still getting the wrong display result. Is there any simple way i can do it..?
  9. sam123
    Hi PFMaBiSmAd, I didnot change anything on your code. Just copied and posted on my php page.The html output i checked and i also got the way as yours. But not getting the expected result. Is it due to my tabbed content script error..? Thanks, Sara.
  10. sam123
    Hi Christian, I wanted to make one-to-many relationship between the categories and pictures, so i altered my tables as follows. ALTER TABLE photos ADD FOREIGN KEY (category_id) REFERENCES gallery_category(category_id) Now the table structure is like this. CREATE TABLE IF NOT EXISTS `gallery_category` ( `category_id` int(11) NOT NULL auto_increment, `category_name` text NOT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; CREATE TABLE IF NOT EXISTS `photos` ( `photo_id` int(20) NOT NULL auto_increment, `photo_filename` varchar(25) NOT NULL, `photo_caption` text NOT NULL, `category_id` int(20) NOT NULL, PRIMARY KEY (`photo_id`), KEY `category_id` (`category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ; so now category_ID is AUTO_INCREMENT and PRIMARY KEY in gallery_category table and category ID is the FOREIGN KEY in photo table. Please check it and let me know this is correct.. Thanks, Sam.
  11. sam123
    In the HTML output the tabs is displaying correctly as tabs1->Test1(category1) and tab2->Test2(category2). But the problem is with the content of each category.(please check the screenshot which i have added in my last reply) Test1(category1) should display the content photo_caption test1,test2,test3,test4 with images 1.jpg,2.jpg,3.jpg,4.jpg and Test2(category2) should display the content photo_caption test5 with images 5.jpg (please check the database result after running the query which i have added earlier.) But now what i am getting is that, Test1(category1) displays the result as the content photo_caption test1,test2,test3,test4 with images 1.jpg,2.jpg,3.jpg,4.jpg and Test2(category2) displays the result as the content photo_caption 1.jpg,2.jpg,3.jpg,test5 with images test1,test2,test3,5.jpg. Here in Test2(category2) it should display the the content photo_caption test5 with images 5.jpg only. I have not yet set the correct $images_dir variable since i am still working on the code to get it working. Thanks for your help and time. Sam.
  12. sam123
    I tried the edited code and i am getting the result like this.Please see the attachment. Tab is showing correct category, but corresponding category content is not displaying.
  13. sam123
    Thank you both of you for helping me in this problem. But still its not working as expected. $query = "single query that gets the joined information you want in the order that you want it"; Here i used the query " SELECT gc.category_id, gc.category_name, p.photo_id, p.photo_caption, p.photo_filename FROM gallery_category AS gc INNER JOIN photos AS p ON p.photo_category = gc.category_id ORDER BY gc.category_id ASC , p.photo_id DESC " as Christian suggested and i got the following result. category_id ---/--- category_name ---/--- photo_id ---/--- photo_caption ---/--- photo_filename ---1----------/---- Test1------------/---- 1---------/---- test1-----------/--- 1.jpg----- ---1----------/---- Test2------------/---- 2---------/---- test2-----------/--- 2.jpg----- ---1----------/---- Test3------------/---- 3---------/---- test3-----------/--- 3.jpg----- ---1----------/---- Test4------------/---- 4---------/---- test4-----------/--- 4.jpg----- ---2----------/---- Test5------------/---- 5---------/---- test5-----------/--- 5.jpg----- But the tabs are not working as expected.I have attached the results which i got it after running the query. Thanks for your time. Sam.
  14. sam123
    I didnot clear this part to make a join. Sorry i am not that much good in writting sql queries. I have added a javascript part also with the code which i got it from the same script site. var tabs=function(){var c=function(c,a){var b=new RegExp("(^| )"+a+"( |$)");return b.test(c.className)?true:false},j=function(a,B){if(!c(a,B))if(a.className=="")a.className=b;else a.className+=" "+b},h=function(a,B){var c=new RegExp("(^| )"+b+"( |$)");a.className=a.className.replace(c,"$1");a.className=a.className.replace(/ $/,"")},g=function(c,B){var a=document.getElementsByTagName("html");if(a)a[0].scrollTop+=b},e=function(){var a=window.location.pathname;if(a.indexOf("/")!=-1)a=a.split("/");var b=a[a.length-1]||"root";if(b>20)b=b.substring(b.length-19);return b},a=e(),d=function(a){this.a=0;this.b=[];this.c=[];this.d=[];this.e=0;this.f(a)}.prototype={g:function(c){var d=new RegExp(a+c+"=[^;&]+"),b=document.cookie.match(d);return b?b[0].split("=")[1]:this.h()},h:function(){for(var a=0,b=this.d.length;a<b;a++)if(c(this.d[a],"selected"))return a;return 0},j:function(d,c){for(var b=d.getAttribute("rel"),a=0;a<this.b.length;a++)if(this.b[a].getAttribute("rel")==B){j(this.b[a].parentNode,"selected");c&&this.e&&this.k(this.a,a)}else h(this.b[a].parentNode,"selected");this.l(B)},k:function(b,c){if(document.cookie.indexOf("tabContent=")==-1)document.cookie="tabContent="+a+b+"="+c+";path=/";else if(document.cookie.indexOf(a+B)==-1){var e=new RegExp("tabContent=[^;]+");document.cookie=document.cookie.match(e)[0]+"&"+a+b+"="+c+";path=/"}else{var e=new RegExp(a+b+"=\\d+","g"),d=document.cookie.replace(e,a+b+"="+c);document.cookie=d.substring(d.indexOf("tabContent="))}},l:function(B){for(var a=0;a<this.c.length;a++)this.c[a].style.display=this.c[a].id==b?"block":"none"},m:function(a){if(a.id)for(var b=0;b<this.b.length;b++)if(this.b[b].getAttribute("rel")==a.id)return this.b[b];return a.parentNode.nodeName!="BODY"?this.m(a.parentNode):null},n:function(d,c){var a=document.getElementById(d);if(a){var b=this.m(a);if(B){this.j(b,0);if(!c)setTimeout(function(){a.scrollIntoView();g(a,-120)},0);else setTimeout(function(){window.scrollTo(0,0)},0);return 1}else return 0}},f:function(a){this.a=a.i;this.b=a.getElementsByTagName("a");this.d=a.getElementsByTagName("li");for(var b=0;b<this.b.length;b++)if(this.b[b].getAttribute("rel")){this.c.push(document.getElementById(this.b[b].getAttribute("rel")));var f=this;this.b[b].onclick=function(){f.j(this,1);return false}}var e=a.getAttribute("persist")||"";this.e=e.toLowerCase()=="true"?1:0;var d=window.location.hash;if(d&&d.length>1)if(this.n(d.substring(1),window.location.search.indexOf("noscroll=true")>-1))return;var c=this.e?parseInt(this.g(a.i)):this.h();if(c>=this.b.length)c=0;this.j(this.b[c],0)}};var b=[],i=function(d){var b=false;function a(){if(b)return;b=true;setTimeout(d,4)}if(document.addEventListener)document.addEventListener("DOMContentLoaded",a,false);else if(document.attachEvent){try{var e=window.frameElement!=null}catch(f){}if(document.documentElement.doScroll&&!e){function c(){if(b)return;try{document.documentElement.doScroll("left");a()}catch(d){setTimeout(c,10)}}c()}document.attachEvent("onreadystatechange",function(){document.readyState==="complete"&&a()})}if(window.addEventListener)window.addEventListener("load",a,false);else window.attachEvent&&window.attachEvent("onload",a)},f=function(){for(var e=document.getElementsByTagName("ul"),a=0,f=e.length;a<f;a++)if(c(e[a],"tabs")){e[a].i=b.length;b.push(new d(e[a]))}};i(f);return{open:function(c,d){for(var a=0;a<b.length;a++)b[a].n(c,d)}}}() What i am trying to acheive is that if i click a tab its content should display there. But in my case its not displaying. If i click the tab1, its content is showing. But if i click on the second tab the content is not showing. Also if I click a link under a tab, page refreshes and all ok, then move to another tab and click a link under that tab(tab2) and on the page refresh the tab goes back to the first tab(tab1). Thats the problem i am facing now. Its not showing any errors, but i am getting tabs with out any content.I am thinking something wrong in getting the value of catid or the value is not moving to the second tab. Please let me know if you need any more clarification of the problem. Is there any simple way i can display the image gallery pictures in a tabbed view? Thanks, Sam.
  15. sam123
    Hi PFMaBiSmAd, Thanks for your reply. Sorry for the errors in my posting. I was trying to make this work from last one week and many versions i tried. But still it is not working. I am trying to make a tabbed gallery. I got this tabbed page script from the net. It actually works like this. <ul class="tabs"> <li><a href="#" rel="view1">tab1</a></li> <li><a href="#" rel="view2">tab2</a></li> </ul> <div class="tabcontents"> <div id="view1" class="tabcontent"> tab1 content goes here. </div> <div id="view2" class="tabcontent"> tab2 content goes here. </div> </div> There is no javacript to get the value of tabs. I have modified the above code to make my gallery works. <ul class="tabs"> <?php $sql = "SELECT * FROM gallery_category ORDER BY category_id ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $cid = $row['category_id']; $category_name = $row['category_name']; echo "<li><a href='?catid=".$cid."' rel='view".$cid."'>$category_name</a></li> "; } echo "</ul>"; ?> The above part is working fine. May be i am doing wrong here. <div class="tabcontents"> <?php //$catid = (int)($_GET['catid']); $sql = "SELECT * FROM gallery_category ORDER BY category_id ASC"; $query = mysql_query($sql); $catarray = array(); while($row = mysql_fetch_array($query)) { $catarray[] = $row['category_id']; // $catid = $row['category_id']; foreach($catarray as $catid){ echo"<div id='view".$catid."' class='tabcontent'>"; $catid = (int)($_GET['catid']); $sql = "SELECT * FROM photos WHERE photo_category = $catid ORDER BY photo_id DESC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $pid = $row['photo_id']; $photo_caption = $row['photo_caption']; $photo_filename = $row['photo_filename']; echo "$photo_caption</br>"; echo "<img src='".$images_dir."/tb_".$row[photo_filename]."' border='0'"; } echo "</div>"; } } ?> </div> Can you please help me to solve my problem here. I am really confused how to do that..and i am wasting lot of time also without any success. Any help will be greatly appreciated. Thanks, Sam.
  16. sam123
    Is there anybody know how to get the value of an active tab (id value) to make the content part working..?
  17. sam123
    Can anyone please point out me the problem in the above code. ? Thanks in advance, Sam.
  18. sam123
    Hi, I am trying to create a tabbed image gallery using php and mysql . The following are my table structure. CREATE TABLE IF NOT EXISTS `gallery_category` ( `category_id` int(11) NOT NULL auto_increment, `category_name` text NOT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; CREATE TABLE IF NOT EXISTS `photos` ( `photo_id` int(20) NOT NULL auto_increment, `photo_filename` varchar(25) NOT NULL, `photo_caption` text NOT NULL, `photo_category` bigint(20) NOT NULL, PRIMARY KEY (`photo_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ; I am tring to create a tabbed gallery like this. <ul class="tabs"> <li><a href="#" rel="view1">gallery1</a></li> <li><a href="#" rel="view2">gallery2</a></li> </ul> <div class="tabcontents"> <div id="view1" class="tabcontent"> Gallery1 images goes here. </div> <div id="view2" class="tabcontent"> Gallery2 images goes here. </div> </div> Here is my code which i am trying to make this work. <ul class="tabs"> <?php $sql = "SELECT * FROM category ORDER BY category_id ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $cid = $row['category_id']; $category_name = $row['category_name']; echo "<li><a href='?catid=".$cid."' rel='view".$cid."'>$category_name</a></li> "; } echo "</ul>"; ?> <div class="tabcontents"> <?php $sql = "SELECT * FROM category ORDER BY category_id ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $catid = $row['category_id']; $category_name = $row['category_name']; $count = $row['COUNT(photo_id)']; echo"<div id='view".$catid."' class='tabcontent'>"; $catid = (int)($_GET['catid']); $sql = "SELECT * FROM gallery_photos WHERE photo_category = $catid ORDER BY photo_id DESC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $pid = $row['photo_id']; $photo_caption = $row['photo_caption']; $photo_filename = $row['photo_filename']; echo "$photo_caption</br>"; echo "<img src='".$images_dir."/tb_".$row[photo_filename]."' border='0'"; } } ?> </div> </div> The category is displaying correctly (first <ul> </ul> part) but it content display part is not working. Can any one please help me with this.. Thanks, Sam.
  19. sam123
    Thank you so much Barand. It worked.
  20. sam123
    The problem what i am facing is that , the user is saying i am ready to pay this much amount for one product. May be that time there will not be any product added by the retailer. If after sometime the retailer added the 2 products with different price. eg. Samsung 30 LED and Samsung 40 HD and he is setting the offer if 3 customers request product of this price range he will give it for offerprice. So how do we do that..? Here i got confused. Can you please advice..?
  21. sam123
    Yes, i swapped the low and high prices and it worked for panasonic. But it is not working if more that one product of same type with different price. Please see the attachement for sample data. Thanks for your help. sample_data_v1.txt
  22. sam123
    I have made some modifications in my database and ran your sql and I got the following results. +-----+---------------+--------+------------------+-------+--------+----------------+ | uid | e_mail | prodID | name | total | arp | discount_price | +-----+---------------+--------+------------------+-------+--------+----------------+ | 1 | test@your.net | 1 | Samsung 30 LED | 3 | 550.00 | 540.00 | | 1 | test@your.net | 4 | Panasonic 36 LED | 3 | 700.00 | 640.00 | +-----+---------------+--------+------------------+-------+--------+----------------+ But i want to get the following result as i wrote it in the prvious reply. +-----+---------------+--------+------------------+-------+--------+----------------+ | uid | e_mail | prodID | name | total | arp | discount_price | +-----+---------------+--------+------------------+-------+--------+----------------+ | 1 | test@your.net | 1 | Samsung 30 LED | 3 | 550.00 | 540.00 | | 1 | test@your.net | 4 | Panasonic 36 LED | 3 | 700.00 | 640.00 | | 1 | test@your.net | 2 | Samsung 40 HD | 3 | 600.00 | 580.00 | +-----+---------------+--------+------------------+-------+--------+----------------+ If i have two samsung entry in the prod table how can i get the above expected result..? Is this possible..? Thanks for your help.
  23. sam123
    Thanks for your help Barand. But my code is giving me only one result. I tried your query also.The result which i am getting as follows. +-----+---------------+--------+------------------+-------+--------+----------------+ | uid | e_mail | prodID | name | total | arp | discount_price | +-----+---------------+--------+------------------+-------+--------+----------------+ | 1 | test@your.net | 1 | Samsung 30 LED | 3 | 550.00 | 540.00 | +-----+---------------+--------+------------------+-------+--------+----------------+ Can you please post the code which you were trying? The retiler can add the same product with different feature and different price. So if any retiler add a product " Samsung 40 HD " and its price is $ 600,and if he is ready to give offer if 3 customers price quote request the product with the price range of $400-$800, the result we should get like this. +-----+---------------+--------+------------------+-------+--------+----------------+ | uid | e_mail | prodID | name | total | arp | discount_price | +-----+---------------+--------+------------------+-------+--------+----------------+ | 1 | test@your.net | 1 | Samsung 30 LED | 3 | 550.00 | 540.00 | | 1 | test@your.net | 4 | Panasonic 36 LED | 3 | 700.00 | 640.00 | | 1 | test@your.net | 2 | Samsung 40 HD | 3 | 600.00 | 580.00 | +-----+---------------+--------+------------------+-------+--------+----------------+ This is what i am trying to acheive here.
  24. sam123
    Also the query is not working if i add the product panasonic and then the user number is 3, it should show the offerprice. But it is not showing any offer. Please help me. I am scratching my head here, but in vein..I am attaching sample data with this mail. sample_data.txt
  25. sam123
    Muddy I have one more problem. The prodID in prod and whishlist tables are different. The user is saying that i am ready to buy a product if it is with in a specific range with out seeing the product which retailer had already added.I.e he is ready to buy a product say samsung if the price is with in the range of $400-$700. Then retiler is adding samsung and setting its price to $500. So for differentiating the products i have added one more field mfID in both prod and offer table. I have modified your sql and it is working but not as expected in the offer field.Rest of the fields are working fine. SELECT prodID, mfID, num_watchers, no_required, ARP, priceLow, ROUND(discount, 2) as offerPrice, priceHigh, firstName, lastName, e_mail FROM (SELECT pp_prod.prodID, pp_prod.mfID, num_watchers, no_required, ARP, priceLow, CASE WHEN discount_as_percent IS NOT NULL THEN(SELECT ARP-(ARP/100*discount_as_percent) as discount) WHEN discount_as_value IS NOT NULL THEN(SELECT ARP-(discount_as_value) as discount) ELSE (SELECT discount_as_price as discount) END as discount, priceHigh, firstName, lastName, e_mail FROM pp_user INNER JOIN (SELECT pp_watchlist.uid, pp_watchlist.prodID, priceLow, priceHigh, no_required, num_watchers, discount_as_percent, discount_as_value, discount_as_price FROM pp_watchlist INNER JOIN (SELECT prodID, uid, count(*) AS num_watchers FROM pp_watchlist GROUP BY prodID ) AS user_count ON (user_count.uid = pp_watchlist.uid) INNER JOIN pp_offers ON (pp_offers.mfID = pp_watchlist.prodID) )AS watcher_info ON (watcher_info.uid = pp_user.uid) INNER JOIN pp_prod ON (watcher_info.prodID = pp_prod.mfID) WHERE num_watchers >= no_required GROUP BY prodID) as pp_value_return WHERE discount BETWEEN priceLow AND priceHigh Query Result: prodID, mfID, num_watchers, no_required, ARP , priceLow, offerPrice, priceHigh, firstName, lastName, email 1 | 1 | 3 | 3 | 550.00 | 400.00 | 540.00 | 700.00 | Test | Last | test@test.com 2 | 1 | 3 | 3 | 500.00 | 400.00 | 540.00 | 700.00 | Test | Last | test@test.com Only in the offer filed it is giving me wrong answer. For the prodID2 the offerprice i should get 480 instead of 540. Is there any way i can achieve this. Thanks for your help.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.