rupam_jaiswal

Thanks for your reply. Regards

Hi, Please excuse if similar issue has been posted earlier, my array is like this newScore1 is Array( [0] => Array ( [scoreid] => 12 [compid] => 4 [name] => andrew [score1] => 4 [score2] => 122 [score3] => 12 [score4] => DNF [rank1] => 5 ) [1] => Array ( [scoreid] => 15 [compid] => 4 [name] => Ed [score1] => DNF [score2] => DNF [score3] => 34 [score4] => DNF [rank1] => 0 ) [2] => Array ( [scoreid] => 14 [compid] => 4 [name] => andy [score1] => 34 [score2] => 21 [score3] => 34 [score4] => 34 [rank1] => 4 ) [3] => Array ( [scoreid] => 13 [compid] => 4 [name] => crusty [score1] => 1 [score2] => 0 [score3] => 34 [score4] => 0 [rank1] => T2 ) [4] => Array ( [scoreid] => 10 [compid] => 4 [name] => larry g [score1] => 1 [score2] => 1 [score3] => 23 [score4] => 34 [rank1] => T2 ) [5] => Array ( [scoreid] => 11 [compid] => 4 [name] => alex [score1] => 0 [score2] => 33 [score3] => 0 [score4] => 44 [rank1] => 0 )) I have to sort array with score1 values in ascending or descending order but if the value is 0 and DNF then it should always be at the bottom. eg priority_array = (0,'DNF')1) ascending ordernewScore1 is Array( [3] => Array ( [scoreid] => 13 [compid] => 4 [name] => crusty [score1] => 1 [score2] => 0 [score3] => 34 [score4] => 0 [rank1] => T2 ) [4] => Array ( [scoreid] => 10 [compid] => 4 [name] => larry g [score1] => 1 [score2] => 1 [score3] => 23 [score4] => 34 [rank1] => T2 ) [0] => Array ( [scoreid] => 12 [compid] => 4 [name] => andrew [score1] => 4 [score2] => 122 [score3] => 12 [score4] => DNF [rank1] => 5 ) [2] => Array ( [scoreid] => 14 [compid] => 4 [name] => andy [score1] => 34 [score2] => 21 [score3] => 34 [score4] => 34 [rank1] => 4 ) [1] => Array ( [scoreid] => 15 [compid] => 4 [name] => Ed [score1] => DNF [score2] => DNF [score3] => 34 [score4] => DNF [rank1] => 0 ) [5] => Array ( [scoreid] => 11 [compid] => 4 [name] => alex [score1] => 0 [score2] => 33 [score3] => 0 [score4] => 44 [rank1] => 0 ))2) descending ordernewScore1 is Array( [2] => Array ( [scoreid] => 14 [compid] => 4 [name] => andy [score1] => 34 [score2] => 21 [score3] => 34 [score4] => 34 [rank1] => 4 ) [0] => Array ( [scoreid] => 12 [compid] => 4 [name] => andrew [score1] => 4 [score2] => 122 [score3] => 12 [score4] => DNF [rank1] => 5 ) [3] => Array ( [scoreid] => 13 [compid] => 4 [name] => crusty [score1] => 1 [score2] => 0 [score3] => 34 [score4] => 0 [rank1] => T2 ) [4] => Array ( [scoreid] => 10 [compid] => 4 [name] => larry g [score1] => 1 [score2] => 1 [score3] => 23 [score4] => 34 [rank1] => T2 ) [1] => Array ( [scoreid] => 15 [compid] => 4 [name] => Ed [score1] => DNF [score2] => DNF [score3] => 34 [score4] => DNF [rank1] => 0 ) [5] => Array ( [scoreid] => 11 [compid] => 4 [name] => alex [score1] => 0 [score2] => 33 [score3] => 0 [score4] => 44 [rank1] => 0 )) Thanks

HI, Please excuse if similar issue has been posted earlier. I want to check if a remote image exists or not. say if url is http://example/image.png and no image exists there, then...?? Earlier I was using @getimagesize function, but later on found this comment saying that it makes server slow for on large images. http://www.php.net/manual/en/function.getimagesize.php#88793 I don't know if the solution mentioned in that comment is correct rather efficient? Is there any other efficient, fast, small solution for this? Thanks in advance... Regards

Hi, Excuse me if similar issue has been posted earlier. Am using ajax, calling url function getFeedWithComments(table,feed_id_1,page,cpage,hashval){ url = 'file1.php?action=feeds_comments&output=xml&table='+table+'&feed_id='+feed_id_1+'&page='+page+'&comment_page='+cpage; if(hashval){ url+= '&hashval=f'+hashval+'_c'; } createXHR(); sendRequest(url); } I can get the url called by either putting alert OR using live http headers but my client is not a savvy. I want him to view the current request url sent but how?? What will be the easiest way for this? Thanks in advance. Regards

HI, In mysql, I have 2 tables friends, my_page. friends -------- id int(11) username char(40) person char(40) type enum('Friend','Blocked') id username person type ------------------------------------------------------ 13 king_nothing Musechild Friend 587 MrRogue ammo Friend 17 Honey MrRogue Friend my_page -------- id int(11) username varchar(30) page_owner varchar(30) date_posted datetime text text id username page_owner text date ------------------------------------------------------------ 4 Honey MrRogue PHP 2010-06-11 12:30:18 5 ammo MrRogue java 2010-06-08 10:54:52 6 mobster ammo both 2010-06-12 21:20:14 7 ammo Wizkid wrong 2010-06-12 21:39:29 8 Honey ammo show 2010-06-12 22:28:52 friends table tells freinds of each member, say MrRogue is friend of ammo, Honey.Note that MrRogue can come in either username/person field, not necessarily to be in username field. Now I want rows from my_page where my_page.username, my_page.page_owner both are friends of MrRogue, like 8 Honey ammo show 2010-06-12 22:28:52 Thanks in advance!!!! Regards

HI, In mysql, I have 2 tables A and B Table A --- fields id int(50) message varchar(10000) username varchar(100) type enum('friend','game','admin') date_posted timestamp Table B --- fields id int(11) message text username varchar(30) page_owner varchar(30) date_posted datetime with some fields matching and some different. Now I have to select some values from both tables and combine the result in single something like SELECT distinct(id), message, username, type, date_posted FROM table A WHERE whereclause UNION SELECT distinct(id), message, username, page_owner, date_posted FROM table B WHERE whereclause ORDER BY date_posted DESC LIMIT 0, 12. Now my result set shows me id message username type date_posted ----------------------------------------------------------------------------------- 5 java ammo MrRogue 2010-06-11 13:39:38 4 PHP Honey MrRogue 2010-06-11 12:30:18 24 Rock MrRogue admin 2010-06-08 10:54:52 3 tata MrRogue game 2010-06-03 04:25:24 although 'type' field is present in not present for results of table B and 'page_owner' field is missing in results of table B. rows with id 5,4 are from table B rows with id 3,24 are from table A Its merging the 'type' and 'page_owner' fields into 1 field i,e 'type' in resultset. I want resultset like this id message username type page_owner date_posted ------------------------------------------------------------------------------------------------------------ 5 java is cool ammo NULL MrRogue 2010-06-11 13:39:38 4 PHP is my page Honey NULL MrRogue 2010-06-11 12:30:18 24 Rock and roll$$$$$ MrRogue admin NULL 2010-06-08 10:54:52 3 tata MrRogue game NULL 2010-06-03 04:25:24 id message username type page_owner date_posted ----------------------------------------------------------------------------------- 5 java ammo MrRogue NULL 2010-06-11 13:39:38 4 PHP Honey MrRogue NULL 2010-06-11 12:30:18 24 Rock MrRogue NULL admin 2010-06-08 10:54:52 3 tata MrRogue NULL game 2010-06-03 04:25:24 is it possible?? Thanks in advance!!!!!! Regards

Hi, In mysql, I have a table A with fields f1,f1,f3,f4. I want to select some selected column values like f1,f2 and a new fictional column f5 whose value will always be 'luck'. say it should return f1 f2 f5 ------------------ a1 a2 luck b1 b2 luck c1 c2 luck Is there any way out?? Thanks in advance!!!!!! Regards

Hi, There can be a records with username = '$username' even before running the UPDATE query, so If use SELECT * FROM inventory WHERE username = '$username' then it will fetch all the records which have not been modified by UPDATE command. I want only the affected rows with the UPDATE command. Regards

Hi, I am using the following mysql query statement: mysql_query("UPDATE inventory SET username='$username' WHERE username='$target->username' ORDER BY RAND() LIMIT 15"); now I want to also display to the user which rows were affected by the above query and list all those rows in an echo or something. I know i can use mysql_affected_rows() to find HOW MANY rows were affected but can you make a script that will list the rows that were affected? or is it not possible? Regards

Hi, I have a table tableA with fields id,item,sent_to,date_posted (datetime), delivery_hrs(int(2)) date_posted is time at which record is inserted into table, delivery_hrs in hrs (int) Here I want records whose date_posted when added to delivery_hrs results in date lesser than or equal to current date and time. eg If date_posted = '2010-01-13 02:30:00', delivery_hrs = 2, current datetime = '2010-01-13 05:30:00' then delivery_time = date_posted + delivery_hrs i,e '2010-01-13 04:30:00' which is lesser than current datetime = '2010-01-13 05:30:00'. What will be the sql for this?? Thanks in advance!! Regards

Hi, Please excuse if similar issue has been posted earlier. My data is like I am going [ABCDEF]123[/ABCDEF] to movie. I want a regex to get the value between [ABCDEF] and [/ABCDEF] only if its integer. eg if its [ABCDEF]junk characters[/ABCDEF] then I dont want...but if its [ABCDEF]123[/ABCDEF] then I require 123 Regards

Thanx for your help. Am using gmmktime

Hi, I am using php gmdate(). Now I am entering all dates in my dbase using gmdate("Y-m-d H:i:s") I want 1 hr before datetime. So am using like gmdate("Y-m-d H:i:s", mktime(gmdate("H")-$hrs, gmdate("i"), gmdate("s"), gmdate("m"), gmdate("d"), gmdate("Y"))); where $hr = 1 When I echo current date i,e $date = gmdate('Y-m-d H:i:s'); echo "<br/>current date is $date"; its 2009-12-27 03:54:08 and when echo my code of getting 1 hr before $date1 = gmdate("Y-m-d H:i:s", mktime(gmdate("H")-1, gmdate("i"), gmdate("s"), gmdate("m"), gmdate("d"), gmdate("Y"))); its 2009-12-26 02:54:08 difference between these 2 days is 1 day and not 1 hr. I want 1 hr before datetime to be 2009-12-27 02:54:08 Can please anybody help. Thanks in advance Regards

Hi, Thanks for your reply. But what will be the structure of new hobby table then?Will it be PersonID, Hobby and this hobby will have comma separated values like a1,a2...

Hi, My table is like this Id,Name,Location,Hobby Condition is - if location is 1 then possible values of Hobby can be a1,a2,a3,a4,a5 - if location is 2 then possible values of Hobby can be b1,b2,b3,b4,b5 - if location is 3 then possible values of Hobby can be c1,c2,c3,c4,c5 - if location is 4 then possible values of Hobby can be d1,d2,d3,d4,d5 Now I have to get the row whose hobby value is suppose a1. How can I do this.I can't use like operator a1% as a100 will match then Regards

HI, My table has 2 fields Id,Marks. Marks can be 100/200.Now I want to update marks by 2 ways. 1) add 5 to both numerator and denominator i,e 105/205. 2) add 5 to numerator i,e 105/200. What is the way to implement this? Regards Rupam

Hi, Please excuse if similar issue has been posted earlier. My scenario is Login to a https site . Once I login,I find a link to download a file. Now all this I want to do with the help of curl. I want the script for 1) login to https site 2)download the file?After applying the regex,I can get the link of the file easily but problem comes for downloading the file?Do I have to use JavaScript for that or use location header to redirect to file download link? Thanks in advance

I am not getting anything..what the use of # here..can you write the full regex...

Hey .. thanx..for your help...am sorry but still it couldnot solve my problem. I am getting empty $matches from the very first regex preg_match("/Code:\i.*<pre.*>.*<\/pre>/", $html, $matches);

Thanks for you help. But I have posted only a part of my html page.This page has several pre tags and my concern is to 1)get values with pre tags only if it comes after the string Code: 2)My pre tag has certain attributes (<pre class="alt2" dir="ltr" style=" ...) so I can't use <pre>. If i use <pre.*<\/pre> or <pre(.*)<\/pre>,still it returns empty array. Regards

Hi, My html looks like this <meta name="description" content="New info! Code: http://www.example/index.html Code: http://testing.com/fil" /> <!-- message --> <div id="post_message_510223" class="vb_postbit"><font color="green"><font size="3">Temp</font></font><br /> <br /> <br /> <img src="http://sample/test.jpg" border="0" alt="" onload="NcodeImageResizer.createOn(this);" /><br /> <br /> <br /> info!<br /> <br /> <div style="margin:20px; margin-top:5px"> <div class="smallfont" style="margin-bottom:2px">Code:</div> <pre class="alt2" dir="ltr" style=" margin: 0px; padding: 6px; border: 1px inset; width: 470px; height: 34px; text-align: left; overflow: auto">http://www.sample1.com/part1.html http://www.sample1.com/part1.html http://www.sample1.com/part1.html</pre> </div><br /> <div class="smallfont" style="margin-bottom:2px">Code:</div> <pre class="alt2" dir="ltr" style=" margin: 0px; padding: 6px; border: 1px inset; width: 470px; height: 1490px; text-align: left; overflow: auto">http://www.sample1.com/part1/sample_code.part01.rar http://www.sample1.com/part1/sample_code.part01.rar</pre> </div></div> I want all the values that are after Code:</div> and between pre tags. eg http://www.sample1.com/part1.html http://www.sample1.com/part1.html http://www.sample1.com/part1.html and http://www.sample1.com/part1/sample_code.part01.rar http://www.sample1.com/part1/sample_code.part01.rar Please note that at the start in meta tag there is also string Code: and I don't value from it. Thanks in advance Regards

Hi, Please excuse if similar query has been posted earlier. I have text file in which I have to search a word and replace it with a new word. First I do is to get the file contents with fopen,then read the contents , maintain a string $newcontent that holds the contents of file ,the moment i get my word,replace it with new word in the string $newcontent After that I write the whole string $newcontent to file again. What I want is to just while scanning the file,the moment I find my word,replace it with new word there only instead of rewriting the whole file again. Regards

Hi, Please let me know how can I post a reply in PHP Freelancing?I dont find any link for post reply in the topic. Regards Fn Ln

Hi, i am a newbie in using ajax. Please excuse me if a similar query has been posted earlier. I have to create pagination for my website that has already been done in php.I m using smarty templates . Now i have to do pagination using ajax.Links displayed will be like First | Prev | 1-15 | Next | Last where first,prev,next,last are the links. what are the the changes that i have to make in my template and php files. should my php files returns result in xml format?? Regards Rupam

Hi, I am a newbie in web development. I want display hindi charsets on my website, for that I need utf-8 support. When I test on browser, hindi chars are displayed properly but when I test in my mobile's browser(which also supports utf8,utf16,iso10646-ucs-2,iso8859-1,iso8859-2,iso8859-15) it wasn’t displayed properly(printed some square chars). When checked I found that there one more param in utf-8 called q which is passed. So here I can say that if my browser supports 'Utf-8' there is no guarantee that it will display hindi characters properly. So can any one tell me which is the charset (utf8,utf16,iso10646-ucs-2,iso8859-1,iso8859-2,iso8859-15) that supports hindi fully (100%) and not even 90%. Regards Rupam