Re: Need Help bad!.. today.. of all days!
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough alot dont Upload it as your_code_name.txt to your website and send an URL to the list. filter: mysql query sql Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Help bad!.. today.. of all days!
Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two differant surveys.. anytime anew person fills out the survey they get a unique id i have it set to grabe the results from each unigue id for each question through mysql.. but it seems to stop shot about 4 questions.. i even tried dropped the while loop 4 questions shorter -4 and it still stop the same place.. of all days for this to occure.. i know but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] with your reply.. thanks -- Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ Come Cruisin with the Angels http://www.AngelCruise.com Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Help bad!.. today.. of all days!
I think you need to post the code. The description of the problem is a bit ambiguous. _justin Webmaster wrote: Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two differant surveys.. anytime anew person fills out the survey they get a unique id i have it set to grabe the results from each unigue id for each question through mysql.. but it seems to stop shot about 4 questions.. i even tried dropped the while loop 4 questions shorter -4 and it still stop the same place.. of all days for this to occure.. i know but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] with your reply.. thanks -- Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ Come Cruisin with the Angels http://www.AngelCruise.com Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Help bad!.. today.. of all days!
the code is huge i'll post whats relevant. there may be a few irrelevant things in there... but hell... if your willing to look i'm willing to post i know what works so will skip down lower to prevent wasting your time and if ya could please cc your responce to [EMAIL PROTECTED], though if to much trouble i understand i thought i was close.. but then compared the data and it doesnt match.. for instance its spitting out the right subcluters.. and untill i asked for the coomparison it was fine.. i cant do a percentage match or trial till it gives right info.. while($i_sub$num_sub){ $sub_id = @mysql_result($result_sub,$i_sub,subcluster_id); $result_per = mysql_query(select ques_ans from data_1 where ass_id=$ass_id AND user_id=$user_id AND subcluster_id='$sub_id',$db); $num_per = mysql_num_rows($result_per); $i_per=0; //this seems wrong but will count all subclusters equally 1 at a time through the while should $i_per1 = 0; // need a double count so need two seperate $cper = 0; while($i_per$num_per){ // so we need to run the while, probably need to cut the ending out here to add to end of total //gonna change this into an include so its not listed 3 times here-maybe // do math function $nper = $num_per; $nper2 = ($nper*5); // max reading to devide by //answer = // need to add all the answers here while($i_per1$num_per){ $cper = $cper; $cper1 = @mysql_result($result_per,$i_per1,ques_ans); $i_per1++; $cper2 = @mysql_result($result_per,$i_per1,ques_ans); $cper = ($cper+$cper1+$cper2); // $cper3 = $cper; // this is just an easy extraction // i think this actualy might work echo sub=$sub_id = $cperp; $i_per1++;}; // this should loop through output to count the results total //TEST //echo cper3 = $cper3; $i_per++; }; $i_sub++;}; i know theres some redundant code in there etc.. but hey.. till it works i dont like to delete -- Original Message -- From: Justin Farnsworth [EMAIL PROTECTED] Date: Tue, 25 Dec 2001 09:28:53 -0500 I think you need to post the code. The description of the problem is a bit ambiguous. _justin Webmaster wrote: Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two differant surveys.. anytime anew person fills out the survey they get a unique id i have it set to grabe the results from each unigue id for each question through mysql.. but it seems to stop shot about 4 questions.. i even tried dropped the while loop 4 questions shorter -4 and it still stop the same place.. of all days for this to occure.. i know but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] with your reply.. thanks
Re: Need Help bad!.. today.. of all days!
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough alot dont -- Original Message -- From: Webmaster [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 25 Dec 2001 09:53:50 -0500 the code is huge i'll post whats relevant. there may be a few irrelevant things in there... but hell... if your willing to look i'm willing to post i know what works so will skip down lower to prevent wasting your time and if ya could please cc your responce to [EMAIL PROTECTED], though if to much trouble i understand i thought i was close.. but then compared the data and it doesnt match.. for instance its spitting out the right subcluters.. and untill i asked for the coomparison it was fine.. i cant do a percentage match or trial till it gives right info.. while($i_sub$num_sub){ $sub_id = @mysql_result($result_sub,$i_sub,subcluster_id); $result_per = mysql_query(select ques_ans from data_1 where ass_id=$ass_id AND user_id=$user_id AND subcluster_id='$sub_id',$db); $num_per = mysql_num_rows($result_per); $i_per=0; //this seems wrong but will count all subclusters equally 1 at a time through the while should $i_per1 = 0; // need a double count so need two seperate $cper = 0; while($i_per$num_per){ // so we need to run the while, probably need to cut the ending out here to add to end of total //gonna change this into an include so its not listed 3 times here-maybe // do math function $nper = $num_per; $nper2 = ($nper*5); // max reading to devide by //answer = // need to add all the answers here while($i_per1$num_per){ $cper = $cper; $cper1 = @mysql_result($result_per,$i_per1,ques_ans); $i_per1++; $cper2 = @mysql_result($result_per,$i_per1,ques_ans); $cper = ($cper+$cper1+$cper2); // $cper3 = $cper; // this is just an easy extraction // i think this actualy might work echo sub=$sub_id = $cperp; $i_per1++;}; // this should loop through output to count the results total //TEST //echo cper3 = $cper3; $i_per++; }; $i_sub++;}; i know theres some redundant code in there etc.. but hey.. till it works i dont like to delete -- Original Message -- From: Justin Farnsworth [EMAIL PROTECTED] Date: Tue, 25 Dec 2001 09:28:53 -0500 I think you need to post the code. The description of the problem is a bit ambiguous. _justin Webmaster wrote: Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two differant surveys.. anytime anew person fills out the survey they get a unique id i have it set to grabe the results from each unigue id for each question through mysql.. but it seems to
Re: Need Help bad!.. today.. of all days!
Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will [snip] Is the performance of your code data independent? That is to say, if you remove (from the database) the set of data where it currently stops, does it stop there again? Does the code stop in the same place with different data? Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php