Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
~50.5K People Reached
Interests
Writing, Avid Table Tennis player, reading, movies
Favorite Forums
Favorite Tags

82 Posted Topics

Member Avatar for mbarandao

I would like to create a series dropdown boxes, each containing the same listing content. However, when one option is selected from the preceeding dropdownbox, that element is removed from the remaining boxes. I would like this process to continue until all selection have been selected. 1 <select name="box1"> <option>value …

Member Avatar for mbarandao
0
162
Member Avatar for mbarandao

Hello All, I was wondering if anyone knows how I can get an estimated birthdate (dd/mm/yyyy) if I input in a textbox an age number. More specifically, suppose I had another known variable, the person is enrolling into an age specific program and want to start next month (supposedly next …

Member Avatar for hericles
0
174
Member Avatar for mbarandao

Hello, Is it possible to join two tables from two different databases? I have the following query whereas the table named "calendar" is in a separate database than the table named "history". Any ideas on how to join bottom? SELECT C.theDate as day, IFNULL( sum(case when DATE( CAST( H.timeentry AS …

Member Avatar for mbarandao
0
2K
Member Avatar for mbarandao

Hello, I was wondering if the following mysql query can be constructed in a much more efficient way? SELECT distinct(cr.email), m.fname, m.lname, m.email, (SELECT count(*) FROM campaignRecipts where email=cr.email )as ttlsent, (SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )as ttlreceived, ((SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )/(SELECT …

Member Avatar for mbarandao
0
363
Member Avatar for mbarandao

I need a secondary review of the following script to help identify an issue of inconsistency with a function. The code allows me to perform a live search on a specified content. If a match is fount, it allows for me to click on a link and toggle() the content …

Member Avatar for mbarandao
0
388
Member Avatar for mbarandao

Hello, If I have an array structured like the following: '0' ... '0' ... '1' ... '2' ... '1' ... '0' => "Mike" '1' => "1892" '2' => "1" '2' ... '0' => "Paul" '1' => "1672" '2' => "1" '3' ... '0' => "Sam" '1' => "1872" '2' => …

Member Avatar for mbarandao
0
369
Member Avatar for mbarandao

Hello, I have the following string [null,null,null],["Paul","2293",1],["eric","2099",0] which I will define as: var dataparsed ='[null,null,null],["Paul","2293",1],["eric","2099",0]'; and would like to construct three different arrays in the following format: var opponentName = new Array(null, "Paul","eric"); var numberVal =new Array(null, 2293,2099); var outComeVal = new Array(null, 1,0); Any ideas on how this can …

Member Avatar for mbarandao
0
509
Member Avatar for mbarandao

Hello all, I am needing some guidance on how to build an array from POST Variables an then insert the data into mysql. Here is what I have M Variable from submitted form $parentid ="7638sds"; $child3_1_name =$_POST['chld3_1_name']; $child3_1_age =$_POST['child3_1_age']; $child3_2_name =$_POST['chld3_2_name']; $child3_2_age =$_POST['child3_2_age']; $child3_3_name =$_POST['chld3_3_name']; $child3_3_age =$_POST['child3_3_age']; $cnt="3"; $childrenContainer =" …

Member Avatar for mbarandao
0
554
Member Avatar for mbarandao

Hello, I need a little bit of assistance with parsing data from an html using xpath. Please indulge me for a moment as I attempt to explain my problem and subsequently my question: The html code from which I am parsing data is below. I would like to specifically parse …

Member Avatar for v1shwa
0
251
Member Avatar for mbarandao

Hello, I have the following string and would like to use preg_match() to extract parts of the string. Yang club 4931 Wyaconda RdRockville, IA 20852 301-937-3401 Monday - Friday - 3:00 - 10:00PM and Saturday & Sunday -12:00 - 8:00PM another possible string is: Kahler Hall 5440 Old Tucker Row …

Member Avatar for mbarandao
0
818
Member Avatar for mbarandao

I am generating a multidimensional array which outputs in the following format: Array ( [0] => Array ( [cName] => "Club Name (Exp. Date)" [location] => "" [days_times] => '0' [zip] => 0 [state] => 0 [contact_person] => "" [contact_phone] => '0' ) ) Array ( [0] => Array ( …

Member Avatar for mbarandao
0
328
Member Avatar for mbarandao

Hello, I am using Simpe_html_dom to parse an html table; however, I am having problem getting the content of a <td> that have secondary <table> nested in them. I would like to grab the content of all parent <tr>, each of which contains 3 <td> cells. The middle cell is …

Member Avatar for diafol
0
2K
Member Avatar for mbarandao

Hello, I have the following array Array ( [0] => Array ( [cName] => 'Lexington Table Tennis Club (9/30/2014)' [local] => 'Castlewood Gym 201 Castlewood Dr. Lexington, KY 40505' [days_times] => 'Saturday - 2:30 - 6:00PM and Sunday - 9:15AM - 12:00PM' [contact] => 'Babak xxxx 859-xxx-2498' [marker] => '<-----CLUB …

Member Avatar for mbarandao
0
147
Member Avatar for mbarandao

Hello, I am building a multidimensional array with the following code: $array_two = array(); $arrayIndex=0; $loopCount=0; $second_index=""; foreach ($result as $myValue) { $loopCount = ($loopCount<5) ? $loopCount : 0; switch ($loopCount) { case '0': $second_index="cName"; break; case '1': $second_index="local"; break; case '2': $second_index="days_times"; break; case '3': $second_index="contact"; break; case '4': …

Member Avatar for mbarandao
0
2K
Member Avatar for mbarandao

Hello, I have the following array: Array ( [2] => Champlain Valley TTC(1/31/2015) [5] => Old Shelburne Town School5420 Shelburne RdSherburne, VT 05482 [6] => Friday - 6:30 - 10:00PM [9] => Jack Devine802-877-3341 [10] => <-----NEXT_CLUB -----> [13] => Green Mountain Table Tennis Club(GMTTC)(6/30/2014) [16] => Knights of Columbus …

Member Avatar for mbarandao
0
225
Member Avatar for mbarandao

Hello All: I am using a div to simulate a checkbox effect; thus, with each click of the div, my jquery displays a different option (in my case: whether the user wants to select a Monthly or Yearly Subscription). The Jquery code: $(document.body).ready(function () { $(function () { var main_obj_id …

Member Avatar for mbarandao
0
202
Member Avatar for mbarandao

Hello: I am wondering if there are any suggestions on how to pass variable to a div in the following manner: foreach (array_combine($playerState_array_clean_phase2, $membId_stripped_array_clean_phase2) as $playerState_array_clean_phase2 => $membId_stripped_array_clean_phase2) { echo" <a href=\"#_MultiDataProcessor?Pid=$membId_stripped_array_clean_phase2&Plname=$lname&Pfname=$fname\" title=\"$membId_stripped_array_clean_phase2\"><span style='font-size:1.5em'>$playerState_array_clean_phase2</span></a>"; } I want to get those variable in a div that looks like: <div class="iLayer" id="MultiDataProcessor" …

Member Avatar for iamthwee
0
3K
Member Avatar for mbarandao

Hello: I need some assistance with a jquery/javascript code. I have a form with chain-linked list box of product, and prices. Each product is inside a <tr> which are added as needed. So there can be many items added to the form. The total of the items cost (qty*cost) from …

Member Avatar for mbarandao
0
753
Member Avatar for mbarandao

Hello All: I need help constructing a mysql statement to post data from the following form to db <form id="updateHrs" name="updateHrs" method="post" action="process_updateHrs.php"> <table align=center class="ebc-table" cellpadding="0" cellspacing="0"> <thead> <tr> <th colspan="7"><?php echo $SBS_LANG['time_title']; ?></th> </tr> <tr> <th class="sub">Days</th> <th class="sub">Opens</th> <th class="sub">Closes</th> <th class="sub">Day Off</th> </tr> </thead> <tbody> <?php …

Member Avatar for iamthwee
0
280
Member Avatar for mbarandao

Hello All: I am some difficulties getting some database variables from an included file to my mysql connection. Here is what i have: file one Called config.inc.php: session_register("client_id"); $_SESSION['client_id'] = $_SESSION['SESS_ACCT_ID'];// $club_id=$_SESSION['client_id']; ob_start(); include('../../../page_title.php'); ob_end_clean(); include('../../../datalogin.php'); if (!defined('DEFAULT_HOST')) define('DEFAULT_HOST','localhost'); if (!defined('DEFAULT_USER')) define('DEFAULT_USER',$account_user); if (!defined('DEFAULT_PASS')) define('DEFAULT_PASS',$account_pass); if (!defined('DEFAULT_DB')) define('DEFAULT_DB',$account_db); the variables …

Member Avatar for mbarandao
0
428
Member Avatar for mbarandao

Good day all: I'm trying to create a graph using data from mysql on the jpgraph platform. I've been experiencing difficulties with an error 15009 and cannot seem to address the error --lots of reading on the net concerning this error has yield nothing. I'm hoping that someone here is …

Member Avatar for pritaeas
0
1K
Member Avatar for mbarandao

Hello: I need some assistance with the following script configuration. The goal is to run a cronjob with my initial script which would run a mysql query and pull some account ids, it then would create an array of those values and through a for() loop execute a second script …

Member Avatar for diafol
0
2K
Member Avatar for mbarandao

Hi all: I'm trying to pull from a table all values of a specific row (accountids) and would like to iterate through each query result while perform a specified task with each value. Example: The following q-- $get_acctids="select accountid from company_info"; $result = mysql_query($get_acctids) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $id_num= …

Member Avatar for pritaeas
0
267
Member Avatar for mbarandao

Hello! I was wondering if someone can take a look at the following if and else statement and point out what I have written incorrectly. In its current form, I cannot get it to work. So, essentially, I'm trying to construct an if conditional statement within another if statement. $var_test …

Member Avatar for mbarandao
0
191
Member Avatar for mbarandao

Hello all: I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period. More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the …

Member Avatar for adam_k
0
255
Member Avatar for mbarandao

Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records …

Member Avatar for mbarandao
0
458
Member Avatar for mbarandao

Hello: I have the following div popup window: <div id='PopUp' style='display: none; position: absolute; height: auto; left: 13px; top: 10px; border: solid black 1px; padding: 10px; background-color: rgb(255,255,225); opacity:.95; text-align: justify; font-size: 12px; width: 70%; z-index:1200;'> <iframe id=\"mate\" frameborder=0 scrolling=yes width=100% src='client_edit/edit_client_data.php?customerid=$customerid' height=\"790\" align=\"left\"></iframe><br /> <div valign=\"top\" style='text-align: right; display: …

Member Avatar for rkrockr
0
694
Member Avatar for mbarandao

I need some help getting the included ajax script's xmlhttp.open() to target a php code within the same page --something like $_SERVER[PHP_SELF] here is the script: [code] <script type="text/javascript"> function showResult3(strss) { if (strss.length==0) { document.getElementById("livesearch3").innerHTML=""; document.getElementById("livesearch3").style.border="0px"; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new …

Member Avatar for DrChocolate
0
4K
Member Avatar for mbarandao

Good day All: I was wondering if anyone have had experience dealing with the browser history inside an Iframe. Specifically, how to navigate with the back button throught the history inside the Iframe ONLY, and not the entire page. I have an Iframe that is called inside my page like …

Member Avatar for mbarandao
0
9K
Member Avatar for mbarandao

Hello: I'm trying to get a record from mysql based on the query of another the queries separately: set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,queue_num,clientID,customerid, todays_date, request, details,status FROM queue_sys ORDER BY todays_date; outputs row_number queue_num clientID customerid todays_date request details status 1 14 44DWS …

Member Avatar for mbarandao
0
196
Member Avatar for mbarandao

I have a list of customers on a waiting list for services to be rendered today. I want to calculate on average how long it takes from the time the customer was queued to the time that customer record was updated. I'm not really sure of the correct table structure …

Member Avatar for mbarandao
0
134
Member Avatar for mbarandao

Good day all: I'm wondering how does one go about excluding a particular item on a form from being taxed? I have a check box, which onclick, calculates the sales taxes on all items on the form. to perform the tax calculation, I'm using: var tax = ($('#taxbox').attr('checked')) ? (subtotal …

Member Avatar for dany12
0
113
Member Avatar for mbarandao

Hello: I would like to get confirmation from user, if a particular checkbox on form is not checked, whether they want to submit the form without checking this box. I have written the following, but need help with it --missing something. <script type="text/javascript"> function taxable(){ if (document.processEstimate.tax.checked == 0) { …

Member Avatar for mbarandao
0
176
Member Avatar for mbarandao

I'm populating a chained linked dropdown box with the following code: $(document).ready(function() { var data = <?php echo $arr;?>; var id; function getData(passCatID){ var content = ''; var content = '<option name="specify id="specify" style="background: url() right no-repeat; width: 20px">------SPECIFY-----</option>'; var product_desc = ''; var invt = ''; var qty = …

Member Avatar for mbarandao
0
245
Member Avatar for mbarandao

Hi: I was wondering if it is possible for an click() element for jquery to call another document.ready() element from within. Here is what I mean: I have: $('#addrow').click(function(){ $('.item-row:last').after('<tr class="item-row"><td valign="top" align=center style="border-left: 0px solid #cccccc;" width="100%" class="item-name"><div class="delete-wpr"><?php echo $dd2;?><a class="delete" href="javascript:;" title="Remove row">D</a></div></td><td valign="top" align=center ><select id="service_subcat_1" …

Member Avatar for mbarandao
0
134
Member Avatar for mbarandao

Hello: I need to obtain the text value of the select list instead of its numeric value. <select name="categories[]" class="categories" ><option value="0">--Select One--</option><option value="2">BRAKE SYSTEMS</option>.....</select> Based on the code above, I need to be get text Value "BRAKE SYSTEMS: rather than "2". Making the value equal to the text value …

Member Avatar for mbarandao
0
203
Member Avatar for pytup
Member Avatar for mbarandao
0
92
Member Avatar for mbarandao

Hello: Not sure if this the right forum for this question --my apology if I'm posting in error: However, I need to achieve the following implementation. I have complete php and ajax content file to outputs a multi-dropdown boxes with description to each items in the boxes. The code is …

0
82
Member Avatar for mbarandao

hello: I'm pulling mysql data and want to load into an array. I getting the data in like manner: $result = mysql_query("SELECT DISTINCT item2 FROM products"); echo "var option_array = new Array(num_of_cats);\n"; $count=1; echo"option_array[0] = new Array(\"Please Select a Merchandise\");"; while($row = mysql_fetch_array($result)) { echo"option_array[".$count."] = new Array(\"--select One--\",\"\",\"\");"; $count++; …

Member Avatar for diafol
0
269
Member Avatar for mbarandao

I have a form with a select box which is dynamically populated from db. Based on the selection, additional data populates other linked boxes (an input and a textarea). The general idea: the list box has a list of products; once a product is selected, three other input boxes are …

Member Avatar for mbarandao
0
80
Member Avatar for mbarandao

Hello: I have a bit of an interesting delima: I have a form with select box which is dynamically db populated and based on the first selection, additional data populates two other linked boxes (a input and a textarea). This process happens in a table row. here is the source …

Member Avatar for mbarandao
0
199
Member Avatar for mbarandao

Hello: I have an ajax file to loads the content of another file into a div, here is the js code: <script type="text/javascript"> function showUser(str) { if (str=="") { document.getElementById("txtHint").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, …

0
86
Member Avatar for mbarandao

I have a js confirmation function: function r_u_sure(message, url){ if(confirm(message)) location.href = url; } if I were calling this function with a regular href, I would use the following: <a HREF="javascript:r_u_sure('Are Sure You want to Delete or Modify Car Information?!','www.somewhere.com)"><a/> however my html link which begins the deletion process of …

Member Avatar for mbarandao
0
385
Member Avatar for mbarandao

Hello: I was wondering if I can get some guidance on how to pull data from mysql and inserted in js array in the following manner var option_array = new Array(num_of_cats); option_array[0] = new Array(\"You need to select a category\"); // This is the first (blank) category. Don't mess with …

Member Avatar for mbarandao
0
296
Member Avatar for mbarandao

Hello, I have a strange occurence when trying to execute the following sql: if($select_232 == 'Member Credit' && $paymenttype == 'Visa' || $paymenttype == 'Cash' || $paymenttype == 'Check' || $paymenttype == 'Master Card' || $paymenttype == 'Discover' || $paymenttype == 'Amex' || $paymenttype == 'Other') { $result = mysql_query("UPDATE …

Member Avatar for mbarandao
0
176
Member Avatar for mbarandao

Hello; I using the following sql to get information from two tables --through join; /[CODE]/ this join works in sql, but can $res = "select ad.firstname, ad.lastname, ad.address, ad.city, ad.state, ad.zipcode, ad.dhtmlgoodies_category, ad.dhtmlgoodies_subcategory, ad.caryear, ad.customerid, ad.servicedesc, aj.email, aj.areacode, aj.phoneprefix, ad.clientID, aj.phonesufix, aj.cellareacode, aj.cellprefix, aj.cellsufix, aj.commentonclient from additional_cars as ad, ajax_client …

Member Avatar for ddymacek
0
436
Member Avatar for mbarandao

Hello: I'm trying to select specific data from code 2 below, using the variable $clientID queried from code 1 (also below). The question is if code 1 iterates a series of rows containing variables $clientID (say about 10 unique $clientID's); how can I write code 2 to go through each …

Member Avatar for mbarandao
0
411
Member Avatar for mbarandao

I have the following code which performs a sql select with a where condition involving an array. I want subsequent queries (within the same code) to be performed using each unique value of the array Here are the specifics: This initial query begins the process by creating an array from …

Member Avatar for mbarandao
0
297
Member Avatar for mbarandao

hello: I'm trying to modify the following query so that it only select rows where [code]90 - DATEDIFF(CURDATE(),date) as days_remaining[/code] is greater than negative 15. (days_remaining > -15) [code]$query="select servicearea, date, customerid, clientID, 90 - DATEDIFF(CURDATE(),date) as days_remaining from servicesrendered where servicearea=' Oil Change ' and DATEDIFF(CURDATE(),date) > 79 group …

Member Avatar for mbarandao
0
104
Member Avatar for mbarandao

Hello, I'm trying to write a sql statement that would update a record only if a particular row column is empty; else, insert a new record. Is this doable? Currently, I have this update statement: [CODE]//query for additional cars 1 $mysql_query=("UPDATE additional_cars SET clientID='$edit_clientID', registeredstate='$edit_registeredstate', dhtmlgoodies_category='$dhtmlgoodies_categoryupdate', dhtmlgoodies_subcategory='$dhtmlgoodies_subcategoryupdate',caryear='$edit_caryear', servicearea='$lastservice', currentmileage='$edit_currentmileage', todays_date='$date2', …

Member Avatar for mbarandao
0
185

The End.