kra1978

Mr. Barand I really thank you very much for your effective help. It works now properly.

Thank you for your reply. But this is also not working.

Thank you for your reply but the thing you mentioned doesn't work. Please help further if possible.

Hello Everyone, I have following query and I am trying to display members in the order where members with highest average rating will be displayed first, if more than one members have same average rating then highest number of rating will be considered. Here, Member A has been rated by 3 visitors and average rating value is 5 while Member B has been rated by 2 visitors and average rating value is 5 So according to below query, Member A should display first because he has 5 average rating and rated by 3 persons while Member B should display on second position. But Member B is displaying first and Member A is displaying second so this is problem. Please let me know what wrong I am doing in query. SELECT m.*,mc.* FROM t_member m LEFT JOIN tr_member_category mc ON m.memberpkid=mc.memberpkid LEFT JOIN tr_comment c ON m.memberpkid=c.memberpkid AND c.approved='YES' AND c.visible='YES' WHERE m.visible='YES' AND m.approved='YES' AND m.gender='FEMALE' AND mc.archivecatpkid=1 GROUP BY m.memberpkid ORDER BY avg(c.ratingvalue) DESC, COUNT(c.ratingvalue) DESC Thank you very much in advance, KRA

Hello Everyone, I need help for following matter. I am preparing website using PHP-MySQL-Javascipt on IIS 6 server. In website people will be become members and I want them to have shorten personalized url. For Example: http://www.website.com/client/member_profile.php?mid=1&key=1&pp=1 I want to make above link like below using PHP script (or any other that can help me) http://www.website.com/client/memberID Please help me in any way. Thank you very much in advance. KRA

Sorry about placing at wrong place but can you please help me to solve this problem? I accept it has nothing to do with PHP. Thanks,

Hi All, I have .mov video that I am trying to post on website. It is playing fine in FireFox browser. But it is displaying only Quick time white screen with logo and "?" symbol above quick time logo when I try to play it in Internet Explorer version 6. Following is the OBJECT-EMBED code that I am using on website. <object height="256" width="320" classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="http://www.apple.com/qtactivex/qtplugin.cab"> <param name="type" value="video/quicktime"> <param name="FileName" value="http://www.sitename.com/video/videofilename.mov"> <param name="autoplay" value="true"> <param name="target" value="myself"> <param name="controller" value="true"> <param name="href" value="http://www.sitename.com/video/videofilename.mov"> <embed src="http://www.sitename.com/video/videofilename.mov" height="256" width="320" autoplay="true" type="video/quicktime" pluginspage="http://www.apple.com/quicktime/download/" controller="true" href="http://www.sitename.com/video/videofilename.mov" target="myself"></embed> </object> Please help me to solve this problem. Thanks in advance,

Hello, My website is developed and designed using PHP-MySQL on Windows Server 2003 (IIS) platform. Now, I am going to host my website on the server so I want to know that Should I get hosting server with PHP-MySQL & Windows Server 2003 support? Or Hosting server with PHP-MySQL & Linux can work for me without any problem? Please reply so I can decide for what I should do. Thanks in advance,

It does work !!! I really thank you very very much for your constant help through out the problem solution. Thanks again, KRA

Ok, I tried the code and now it is downloading file of only 1 KB. Also I found following link. Can you please advice that whether it may be the issue? They are saying that it is the bug in PHP 5.2.5....please let me know. http://bugs.php.net/bug.php?id=43306&edit=2 Thanks for your all efforts KRA

I have one thing to ask...Should I add any MIME types on the server for the code you just provided? Please advice. KRA

Ok. I have attached the 152 KB file here. Thanks, KRA [attachment deleted by admin]

The code you provided is not working. The file is downloaded only 152 KB each time instead of original 1.85 MB file size. I found following code from the internet. Please advice whether it can be helpful or not. ========================== $str_filename=""; $str_filepath=""; $str_ext=""; $str_filename=trim($rs_download_file->fields("photosetfilename")); $str_filepath=trim($UPLOAD_ZIPFILE_PATH.$str_filename); // $str_ext=getextension($str_filename); header("Pragma: public"); // required header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); // header("Cache-Control: private",false); // required for certain browsers header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream", FALSE); header("Content-Type: application/download", FALSE); // header("Content-Type:application/octet-stream"); header("Content-Disposition:attachment;filename=".$str_filename); header("Content-Transfer-Encoding: binary"); $fp=fopen($str_filepath,'rb'); header("Content-Length:".filesize($str_filepath)); fpassthru($fp); exit(); ==========================

Yes, There is .zip file created successfully on the server and I also downloaded it using FTP and then unzip...it is working!!! Dedicated Server Providers are saying that you need to change the script. I am not sure whether PHP 5.2.3 and PHP 5.2.5 can have different scripts to download .zip file from the website. Please advice, KRA

I checked all settings and they are same except one. output_buffering In old server, it is set output_buffering=4096 and in new server it is set output_buffering=no value Please let me know whether this may be problem Thanks again, KRA