dsbpac

Can someone please help me!! How can I get the value in an link like <a href="#first">Link</a> I need to get first in an variable. I have search an search but I can't find any help. I know I can get it if i pass it in the URL name but the way the css is coded. I need to get the value like it is. Thank you.

I have an array that has salary, position, and projected. $arr[] = array('salary' => $row["salary"], 'position' => $row["position"], 'projected' => $row["projected"]) Position = QB, RB, WR, TE, PK, DEF Salary = 7000, 8300, 5000 Projection = 10, 20, 30 I need help wrapping my head around how to do the following. I want the script to give me the most possible projected points based on a total salary number and limited to specific amount of players in each position. QB -1 RB - 2 WR - 3 TE - 1 PK - 1 DEF - 1 Max salary of 60k. Any help is greatly appreciated.

I changed array1 to be more structured now. [0] => Array1 ( [0] => 32347 [1] => 22188 [2] => 37493 [3] => 37056) [1] => Array ( [0] => 8 [1] => 3 [2] => 4 [3] => 7)

I actually did look in there. I already took several arrays and combined them into two seperate arrays. I'm pretty sure I need to do a nested foreach loop in order to do this. I just don't understand how to do it.

I have two arrays that are listed like this. Array1 ( [0] => Array ( [32347] => 8 [22188] => 3 [37493] => 4 [37201] => 7 ) ) Array2 ( [0] => Array ( [0] => Array ( [0] => 32347 [1] => 28470 [2] => 35319 [3] => 37493 ) [1] => Array ( [0] => 5 [1] => 2 [2] => [3] => 4 ) [2] => Array ( [0] => 484 [1] => 383 [2] => 315 [3] => 320 ) ) ) I want to combine both arrays if value is the same. Example [32347] => 8 => 5 => 484 Thank you in advance.

Thank you very much for your help. I was able to get the script up and running just like I wanted and it works perfect. Shout out to mac_gyver, scootstah, Ch0cu3r, and Barand for assisting me.

First off let me thank everyone for their help so far. After trying a few different things and getting an error message. I figured out that allow_url_fopen is OFF. How would I go about CURL to get the data I'm requesting since I'm pretty sure that would be an alternative option.

Okay I have been playing with this all day and decided to go back to the first script i started with and it's still producing the error. Warning: Invalid argument supplied for foreach() in <?php ini_set('display_errors', 1); error_reporting(-1); $postcode1=('CB13HR'); $postcode2=('CB23JX'); $url = "http://maps.googleapis.com/maps/api/distancematrix/json?origins=$postcode2&destinations=$postcode1&mode=driving&language=en- EN&sensor=false"; $data = @file_get_contents($url); $result = json_decode($data, true); foreach($result['rows'] as $distance) { echo 'Distance from you: ' . $distance['elements'][0]['distance']['text'] . ' (' . $distance['elements'][0]['duration']['text'] . ' in current traffic)'; } ?> I also tried to replace json_decode with json_decode( preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $json_string);, true ); and it returned nothing. Thanks for any and all help ahead of time.

I did already try taking that out. I copy and pasted the working original into here since I tried several things and didn't want an self made error. When i turn on error reporting i get Notice: Undefined offset: 1 line 16

Thank you everyone for your help!! I have my code working just as I want on my test hosting server that is running php version 5.2.17. When I move it over to the actual server I want to use it on that is running php version 5.3.29. its not displaying any type of input inside the foreach loop including a simple echo test text. Section of code the issue is in I think $url = "http://maps.googleapis.com/maps/api/distancematrix/json?origins=$postcode2&destinations=$postcode1&mode=driving&language=en-EN&sensor=false"; $data = @file_get_contents($url); $result = json_decode($data, true); foreach($result['rows'] as $distance) {; $items2[] = array( 'info' => $distance['elements'][0]['distance'], 'venue' => $venue, 'vid' => $vid, ); } FULL CODE <?php ini_set('display_errors', 1); error_reporting(-1); include 'config/db_functions.php'; //run the query $loop = mysql_query("SELECT * FROM NEW_Venues WHERE game_nights = '5' AND status = '1'") or die (mysql_error()); $items = null; $items1 = null; while ($row = mysql_fetch_array($loop)) { $postcode2 = $row['zip']; $venue = $row['venue']; $vid = $row['vid']; $postcode1=('33462');; $url = "http://maps.googleapis.com/maps/api/distancematrix/json?origins=$postcode2&destinations=$postcode1&mode=driving&language=en-EN&sensor=false"; $data = @file_get_contents($url); $result = json_decode($data, true); foreach($result['rows'] as $distance) {; $items2[] = array( 'info' => $distance['elements'][0]['distance'], 'venue' => $venue, 'vid' => $vid, ); } } function sortValues($a, $b) { return strnatcmp($a['info']['text'], $b['info']['text']); } usort($items2, 'sortValues'); $venueid = $items2[0]['vid']; $venuename = $items2[0]['venue']; echo "Sunday - $venuename<br>"; ?>

I'm getting an syntax error, unexpected T_FUNCTION when I add usort($data, function($a, $b) { return strnatcmp($a['text'], $b['text']); }); echo '<pre>',print_r($data, true),'</pre>';

I get this when turning those on. Strict Standards: ksort() [function.ksort]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CDT/-5.0/DST'

I'm having an issue sorting an array. I'm getting an error of "Warning: ksort() expects parameter 1 to be array, null given in" The print_r output of the array is Array ( [0] => Array ( [text] => 96.1 km [value] => 96113 ) [1] => Array ( [text] => 52.1 km [value] => 52096 ) [2] => Array ( [text] => 102 km [value] => 102064 ) [3] => Array ( [text] => 30.0 km [value] => 29992 ) [4] => Array ( [text] => 43.9 km [value] => 43864 ) [5] => Array ( [text] => 57.4 km [value] => 57408 ) [6] => Array ( [text] => 82.2 km [value] => 82154 ) [7] => Array ( [text] => 73.6 km [value] => 73620 ) [8] => Array ( [text] => 118 km [value] => 118016 ) [9] => Array ( [text] => 137 km [value] => 136921 ) [10] => Array ( [text] => 61.6 km [value] => 61574 ) [11] => Array ( [text] => 74.2 km [value] => 74193 ) [12] => Array ( [text] => 226 km [value] => 226166 ) [13] => Array ( [text] => 140 km [value] => 140145 ) [14] => Array ( [text] => 126 km [value] => 126140 ) [15] => Array ( [text] => 45.5 km [value] => 45520 ) [16] => Array ( [text] => 211 km [value] => 211070 ) [17] => Array ( [text] => 54.1 km [value] => 54145 ) [18] => Array ( [text] => 187 km [value] => 186855 ) [19] => Array ( [text] => 271 km [value] => 271334 ) [20] => Array ( [text] => 219 km [value] => 218848 ) [21] => Array ( [text] => 67.0 km [value] => 67016 ) [22] => Array ( [text] => 13.6 km [value] => 13591 ) [23] => Array ( [text] => 153 km [value] => 153396 ) [24] => Array ( [text] => 11.5 km [value] => 11492 ) ). All I want to do is be able to sort the array by the lowest number in either text or value and display that single number. <?php include 'config/db_functions.php'; //run the query $loop = mysql_query("SELECT * FROM NEW_Venues WHERE game_nights = '5' AND status = '1'") or die (mysql_error()); while ($row = mysql_fetch_array($loop)) { $postcode2 = $row['zip']; $venue = $row['venue']; $postcode1=('33071');; $url = "http://maps.googleapis.com/maps/api/distancematrix/json?origins=$postcode2&destinations=$postcode1&mode=driving&language=en-EN&sensor=false"; $data = @file_get_contents($url); $result = json_decode($data, true); ksort($items); foreach($result['rows'] as $distance) {; echo '' . $venue . ' - ' . $distance['elements'][0]['distance']['text'] . ' <br>'; $items[] = $distance['elements'][0]['distance']; $items1[] = $distance['elements'][0]['distance']; $itemsname[] = $venue; } } ksort($items1); foreach ($items1 as $key => $val) { echo "$key = $val <br>"; } print_r(array_values($items)); ?>

I have a db wiith the following fields userid, postuserid, info users post information as follows userid 2 posteruserid 6 info blah blah blah The postuserid is the id number of the person that is logged in and posting an article. Userid is the users profile they are posting to. I'm having an issue figuring out how to display [sOMETHING] only if the user logged in has not posted on that users profile. Any help is appreciated. Thank you

I'm a little stuck on how to make it to where only images can be uploaded and not all files. Thanks in advance! <?php // Your file name you are uploading $file_name = $HTTP_POST_FILES['ufile']['name']; // random 4 digit to add to our file name // some people use date and time in stead of random digit $random_digit=rand(0000,9999); //combine random digit to you file name to create new file name //use dot (.) to combile these two variables $new_file_name=$random_digit.$file_name; //set where you want to store files //in this example we keep file in folder upload //$new_file_name = new upload file name //for example upload file name cartoon.gif . $path will be upload/cartoon.gif $path= "upload/".$new_file_name; if($ufile !=none) { if(copy($HTTP_POST_FILES['ufile']['tmp_name'], $path)) { echo "Successful<BR/>"; //$new_file_name = new file name //$HTTP_POST_FILES['ufile']['size'] = file size //$HTTP_POST_FILES['ufile']['type'] = type of file echo "File Name :".$new_file_name."<BR/>"; echo "File Size :".$HTTP_POST_FILES['ufile']['size']."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type']."<BR/>"; } else { echo "Error"; } } ?>

Thanks for pointing me in the right direction guys

This is working for adding a new record $query = "insert into ucmp_note (owner_id,note,note_time,rel_data,reminder,date_created,create_user_id,create_ip_address,refills,supply,rxname,refilldate,owner_table) values ('$customer_ids','$m_note','$m_note_time','$m_rel_data','$m_reminder','$m_date','$user_id','$m_create_ip_address','$m_refills','$m_supply','$m_rxname','$m_refilldate','$m_owner_table')"; mysql_query($query) or die(mysql_error()); but when I try to update the record using $query = "UPDATE ucmp_note (owner_id,note,note_time,rel_data,reminder,date_created,create_user_id,create_ip_address,refills,supply,rxname,refilldate,owner_table) values ('$customer_ids','$m_note','$m_note_time','$m_rel_data','$m_reminder','$m_date','$user_id','$m_create_ip_address','$m_refills','$m_supply','$m_rxname','$m_refilldate', '$m_owner_table')"; mysql_query($query) or die(mysql_error()); its kicking me an error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into ucmp_note (owner_id,note,note_time,rel_data,reminder,date_created,create_us' at line 1

There is not some type or work around that I can do in order for it to ready these as values?

I'm having an issue counting a table with table columns listed as numbers. I have a table called timetable with fields 1, 2, 3, 4 so on. If I try to count like this <?php $query = "SELECT 96, COUNT(96) FROM timetable WHERE 96='blah'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo " (". $row['COUNT(96)'] .")"; } ?> It will return the value as zero. If i change the columns from 96 to name like <?php $query = "SELECT name, COUNT(96) FROM timetable WHERE name='blah'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo " (". $row['COUNT(96)'] .")"; } ?> It will return the correct value?? Thank you for any help

Okay let me take a step back. Lets start with a 3 tier referral system to keep it simple and so I can gather the logic and build from there. So you have someone that signs up named james. James gets his buddy mike to sign up and mike gets his buddy steve to sign up. So so far we have level 1 (20% commision) James level 2 (10% commision) mike, michelle level 3 (5% commision) steve(mike referral), stacy(mike referral), sarah(michelle referral), sean(michelle referral) The first level is pretty simple since everything is a direct referral. How would I go about doing the second and third levels? I know it's some type of query but I would think you need to make each level into an array. Since I plan to expand this more levels I will need it to ++ count as well correct? Any help and example to get me started would be greatly appriciated

I just need some help with login in order to wrap my head around how to code this. I have a site that is going to sell a product. Each sale is going to be logged into an db with all the normal info(user, sale id number so on). My question is this... I'm trying to create a 10 level commission system. Any idea's and logic that you would use to create this would be much appriciated. Thanks in advance.

UPDATE: I figured out a solution. I took out the DISTINCT and change it to GROUP BY. Thank you everyone for your time $result = mysql_query("SELECT tier_one, tier_one_value FROM three_drops GROUP BY tier_one") or die(mysql_error());

data-cost="'.$tier['tier_one_value'].'" Is the finished code I want. How can I pull the tier_one_value from the mysql DB. When I try to do something like $result = mysql_query("SELECT DISTINCT tier_one, tier_one_value FROM three_drops") it doesn't work.

Hello guys, my code is a 3 teir auto populate form based on the selected option. The information is pulling from a mysql DB. Everything is working fine, now I'm wanting to expand to giving the options a value number from the MYSQL values. Example: MYSQL DB is setup as follows: teir_one | teir_one_value | tier_two | teir_two_value | tier_three | tier_three_value Honda 1 civic 10 blue 100 How can I pull tier_one_value from the DB and display it for data-cost= ?? Thanks in advance function getTierOne() { $result = mysql_query("SELECT DISTINCT tier_one FROM three_drops") or die(mysql_error()); while($tier = mysql_fetch_array( $result )) { echo '<option value="'.$tier['tier_one'].'" data-cost="'.$tier['tier_one_value'].'">'.$tier['tier_one'].'</option>'; } } Here is my full code <?php //************************************** // Page load dropdown results // //************************************** function getTierOne() { $result = mysql_query("SELECT DISTINCT tier_one FROM three_drops") or die(mysql_error()); while($tier = mysql_fetch_array( $result )) { echo '<option value="'.$tier['tier_one'].'" data-cost="1">'.$tier['tier_one'].'</option>'; } } //************************************** // First selection results // //************************************** if($_GET['func'] == "drop_1" && isset($_GET['func'])) { drop_1($_GET['drop_var']); } function drop_1($drop_var) { include_once('db.php'); $result = mysql_query("SELECT DISTINCT tier_two FROM three_drops WHERE tier_one='$drop_var'") or die(mysql_error()); echo '<select name="drop_2" id="drop_2"> <option value=" " disabled="disabled" selected="selected">Choose one</option>'; while($drop_2 = mysql_fetch_array( $result )) { echo '<option value="'.$drop_2['tier_two'].'" data-cost="10">'.$drop_2['tier_two'].'</option>'; } echo '</select>'; echo "<script type=\"text/javascript\"> $('#wait_2').hide(); $('#drop_2').change(function(){ $('#wait_2').show(); $('#result_2').hide(); $.get(\"func.php\", { func: \"drop_2\", drop_var: $('#drop_2').val() }, function(response){ $('#result_2').fadeOut(); setTimeout(\"finishAjax_tier_three('result_2', '\"+escape(response)+\"')\", 400); }); return; }); </script>"; } //************************************** // Second selection results // //************************************** if($_GET['func'] == "drop_2" && isset($_GET['func'])) { drop_2($_GET['drop_var']); } function drop_2($drop_var) { include_once('db.php'); $result = mysql_query("SELECT DISTINCT tier_three FROM three_drops WHERE tier_two='$drop_var'") or die(mysql_error()); echo '<select name="drop_3" id="drop_3"> <option value=" " disabled="disabled" selected="selected">Choose one</option>'; while($drop_3 = mysql_fetch_array( $result )) { echo '<option value="'.$drop_3['tier_three'].'" data-cost="100">'.$drop_3['tier_three'].'</option>'; } echo '</select> '; } ?>

The following code will print out each product name from start to finish. How can i make it print out the same list and let me specify how it prints out for the first and last as their own code and still keep this code as the middle? <?php foreach ($products as $row): ?> <li><a href="product_details.php?product_id=<?php echo $row['product_id']; ?>"><?php echo $row['product_name']; ?></a></li> <?php endforeach; ?>