Outputting Just The Result Of An Array
I'm trying to print the results of an array taken from my database.
here's my code:
$subc = array($subcdat);
print_r($subc); The problem it's outputting: Array ( [categories_name] => Spoon Boy )when I only want it to output: Spoon Boy. I'm trying to save the spoonboy as a variable to use, so I'm using the print_r function to check what it's outputting. If it's outputting correctly I'll use $subc as the variable to read from.
View Complete Forum Thread with Replies
Related Forum Messages:
Outputting From Array
I have recently outsourced a site and having put it live have found that its outputting a number instead of a county from the database, the numbers are coming from an array that converts each county to a number for storing in the database but doesnt seem to be converting them back to text when outputted,
View Replies !
Outputting A 2D Array In A Certain Format
I have a mySQL result which is from a database of 9 columns and $x rows. I need to create a loop so that it displays the content of each field in a row before going to a new line and then displaying that row. The reason I am doing this is to cretae a loop system for adding data to an excel sheet I have created using COM. This works fine, its just a matter of looping through the results correctly. here is the loop code I have at the minute (which isn't working correctly) PHP Code:
View Replies !
Outputting Form Data Into Array..
how would I retrieve all values sent by a form with post method and put it in an array? I'm trying to do this because I have a form which has different inputs and textarea etc depending on some other variables. I'm then trying to read the data and pu it into a mysql command. I want to collect all the data from the form (regardless of what it is) and save it as an array which I can use.
View Replies !
Sort The Array Before Outputting The Data
I do a SQL query and normally just do a "while ($data = mysql_fetch_array($sql))" and echo the output. What I want to do now is to sort the array before outputting the data, to get it in the correct order. I cannot just sort the data in the SQL query as I have to sort a column containing data in the format of "Firstname1 Lastname1 and Firstname2 Lastname2" and the sorting for that column has to be sorted by Lastname1 ASC. I figure this is somehow done using a sort array command but I am very lost on how to do achieve this sorting.
View Replies !
Array Explode Problem Result In A 6 Item Array
I have the following: $BB_Basket = "basket=¦APL6007,2.00¦AVX8900,1.00¦ARCAV500,1.00"; $basket_containers = explode('¦', $BB_Basket); unset($basket_containers[0]); print_r($basket_containers); This results in Array ( [1] => APL6007,2.00 [2] => AVX8900,1.00 [3] => ARCAV500,1.00 ) Now when I try to explode further with $basket_items = explode(',', $basket_containers); print_r($basket_items); This results in Array ( [0] => Array ) This should result in a 6 item array. Any ideas what I'm doing wrong?
View Replies !
Add Sql Result To An Array
I am trying to add the results of a query (specifically a particular field's value) to a new array. The result is either an empty array or the last row in the query result instead of all the rows. Code:
View Replies !
Array Result
PHP Code: function match_username()         {             $connection = new db_connect;             $connection->connect();             $this->table  = "bs_user_member";             $this->query  = mysql_query("SELECT username FROM $this->table");                 while ($this->result = mysql_fetch_object($this->query))                 {                     global $uname;                                         $uname = array($this->result -> username);                 }                            } Should show all right?
View Replies !
Getting First Result From Array?
Trying to get the top 10 male authors from my database that works fine .. but id also like to just get the top male author too So since ive fecthed the top 10 , shouldnt i be able to get the top 1 from that? Code:
View Replies !
Mysql Result Into Array?
I have a shopping cart script sending info to a processor. I need to send the qty's and item name's in some sort of string via a single variable to the process form. i.e. (3) Hipster Turnips, (6) Butter Milk Baby Brains, (2) Super Freaks Code:
View Replies !
How To Add Function Result To Array?
The way I'd like to set up a particular set of functions is to have them either return TRUE or, for example: $errors[type] = "Sorry, the file type is not allowed. Allowed types are ".print_array_inline($acceptedTypes).". "; Then later, I have a foreach loop that echos each array element. However, when I echo each array element is doesn't output the whatever the print_array_inline function does. Any suggestions?
View Replies !
Mysql Result Set As An Array
the question is, is there a way of assigning each value returned from the sql query and assinging them to a single array. for example i have a a query like so; $table = "sales_table";         $query = "select treatments from $table where date between  ད/08/2006' and ཕ/08/2006'"; $result = mysql_query($query); because the values stored in the treatments field are imploded as a single string when the user submits the form the value looks like; 1, 22, 33. Code:
View Replies !
Result Of Array Diff()
I'm successfully able to compare two different arrays with array_diff(). The result of this comparison is, of course, assigned to a new array. Unfortunatly (for my purposes) the array indeces of the resulting matching items are retained, yet empty: [a][b][empty][d][empty][empty][g] - and so on. I'm wondering if there's a built-in function that would sequentially assign all non-empty index items of my array_diff() result to a second array, like: [a][b][d][g] I know I can do this with a loop, but am wondering if there's already a function to handle this.
View Replies !
MySQL Result As Array
$db= new MySQL($host,$dbUser,$dbPass,$dbName); $sql=("SELECT * FROM sticker_files WHERE sticker_cat_id=Ǝ'"); $catdirs = $db->query($sql); $dirs=$catdirs->fetch() and I need a for each loop (i think) to insert that data below: $params = array( 'mode' => 'Jumping', 'perPage' => 3, 'delta' => 2, 'itemData' => array(****RESULTS HERE AS COMMA SEPARATED string) );
View Replies !
Mysql Result To Array
I have this query, it gives the suspected information in myphpadmin: select listid, count(*) from table1 group by listid How do I put this the result into an array in php? I have problems with the count(*) field
View Replies !
Skip First Result In Array
I have an array that contains both key and value. The first key/value is used to store a heading so it is not needed in the rest of the loop. How can I skip that first key/value and display the rest. Example: $myarray = array("key1"=>"heading", "key2"=>1, "key3"=>2....... Without knowing the key/value of the first result, how can I skip it foreach($myarray as $k =>$v){ //if first key skip //else continue the loop }
View Replies !
Query Result To Array
i have a table with two field ID and CAPACITY. i want the ID to point to the capacity on an array $top = "SELECT * from topics"; $db = new mysqli('localhost','root',?'); $db -> select_db('testing'); $res_top = $db->query($top); $topics = array(); while ($row = $res_top->fetch_row()) { $topics[$row['id']] = $row['capacity']; }
View Replies !
Array With MySQL Result
//MAIN FLOW $counter = 0; $sql[$counter] = "SELECT * FROM category WHERE parent = 0 ORDER BY parent"; $result[$counter] = mysql_query($sql) or die(display_and_log_error("SQL ERROR: ".__LINE__)); while($myrow[$counter] = mysql_fetch_assoc($result[$counter])){ echo $myrow[$counter][category_name]; ...
View Replies !
How To Fetch Result Set As An Array
I use $result_set = mysql_query($query) to get a set of rows, and then I can use mysql_fetch_array($result_set)to access each value of column in a row, but each element inside is a column value of one row. I want to get the result as an array from $result_set so that each element of array is an ENTIRE row, so I can add or remove elements inside. Is there such function?
View Replies !
Replacing Array With Mysql Result
I wanted to repalce the following line of code $data = array(40,21,17,14,23); with for($i=0;$i<$numrows;$i++) { //print(mysql_result($result,$i,2));print("<br>"); array_push($data,mysql_result($result,$i,2));} where mysql_result($result,$i,2) is the value and when i print it displays the values. But $data array is the Y axis value for drawing a chart. Here I wanted to replace the hard coded value with values from mysql but the second code does not function. Does anybody have idea how can I replace the $data array or what may be the problem with my coding The first one works but the second one does not work but in both cases it does not display any error.
View Replies !
Moving A Query Result Into An Array
I have read all the array stuff done searches for examples, but am still not clear if there is a way to do a query from a MySQL table and move those vaules into an arry. I am sure it can be done, but I thought I would find a function that would do it. Am I just overlooking something? $resultID = mysql_query("SELECT DISTINCT slot FROM items"); while(list ($slot) = mysql_fetch_row($resultID)){echo"$slot";} So anyone have a good way to move the result into some array?
View Replies !
Query Giving Array As Result
I just started PHP and getting the following error when trying to read and echo something from my DB. I get Array as an result of a working SQL query (I tested it in PHPMyAdmin SQL Query) and it should be something else. Array doesnt return in the database i selected, but still it's here. <? $host="localhost"; $user="xxxxxxxxx"; $password="xxxxxxxxxxx"; $dbname="mohaaleague"; $connection = mysql_connect($host, $user, $password) or die ("Kan niet verbinden"); $clan = "Belgian Fun Clan"; $db = mysql_select_db ($dbname,$connection) or die("Je Stinkt"); //SELECT clan FROM clan WHERE clan='Belgian Fun Clan' $query = "SELECT clan FROM clan" or die("Query Mislukt"); $result = mysql_query($query) or die("Query Mislukt1"); $row = mysql_fetch_array($result, MYSQL_ASSOC) or die("Query Mislukt2"); extract($row); echo($row. "<br>"); if ( $clan == $row ) { echo "het werkt"; } else { echo "het werkt niet"; } $disconnect = "mysql_close"; ?>
View Replies !
Sort A Mysql Result According To A Php Array
Hi everybody ! I have a question for the gurus ;+) I have to arrays : PHP Code: $id = array(45,9,21); $pos = array(3,1,2); I select in my mysql table using the ids : PHP Code: $sql = "SELECT * FROM MyTable WHERE id IN(".implode("",$id).")"; and I now want to sort the result according to the $pos array. Is there a way to do this directly in mysql ? If not, what would be the smartest way to do it in PHP ? Because I would prefer NOT to do the following : PHP Code: while ($t = mysql_fetch_array($ret)) { Â Â Â Â $a_field1[] = $t["field1"]; Â Â Â Â $a_field2[] = $t["field2"]; Â Â Â Â $a_field3[] = $t["field3"]; Â Â Â Â $a_field4[] = $t["field4"]; ... } array_multisort($pos,$a_field1,$a_field2,$a_field3,$a_field4) I fear it could be a very time consuming process when there is a lot of results and a lot of fields. But may be the no other solution... Thanks
View Replies !
Reformatting An Array And Printing The Result.
I have an array called $value which, when echoed, returns [12345]. Instead, I desire to reformat this array so that it prints or echoes in the following format: ["1","2","3","4","5"]. So far, I have: echo """ , $value , "", ";Â ////["1","2","3","4","5"]. This yields my desired result, but I want to encapsulate that result in a variable. Code:
View Replies !
Display Array Result Horizontally
I have two issues but i'll diplay them in two threads for clearity sake. one now and the other in a different thread. thanks for your support. I want to display the output of the script below horizontally, say in five colums without diplaying an element twice. Code:
View Replies !
MySQL Result To Real Array In Function
I'd like to create a function which input is the result of a mySQL query. The output should be exactly the same, only not a mySQL result array, but a 'real' array. So it should also get the fieldnames returned by mySQL and use those as keys. I can't get things to work properly: it should return a multidimensional array, like $result_array[1] = array( [field1] => field1 value, [field2] => field2 value, etc. ) somehow my result is (with code below) $result_array[1] = array( [0] => field1 value, [field1] => field1 value, [1] => field2 value, [field2] => field2 value, etc. ) +++++ code ++++++ $get_res= mysql_query(QUERY); if( $res = mysql_fetch_array( $get_res ) ) { do{ $result[] = $res; }while( $res = mysql_fetch_array( $get_res ) ); }; foreach( $result as $key => $value ){ print_r($value); };
View Replies !
Duplicating Form Elements With Array Result Set
order form with repeating element areas 1) Item: select/option 2) Quantity: input I have a query which returns the result I want to display in area 1) which is a list of products. I tried to setup a loop to populate the select/option with the same list as many times as needed - 4X with option to show 15x with each Item/Quantity line named with the increment of the loop. Code:
View Replies !
Loop Through A Result Array And Apply => Htmlspecialchars
I think that this could be easy, but my brain cramps up part way and I can't seem to get it right (I'm in the middle of a marathon coding/programming session). I have a result set: $query = "SELECT * FROM mytable WHERE code = 'topsecret!'"; $result = mysql_query($query); Now I want to loop thru the resulting $row's and apply the htmlspecialchars() function. My brain cramps right about at the point where I start to build the foreach. Can someone walk me through this? while ($row = mysql_fetch_array($result)) { foreach ($row as $key => $val) { CRAMP! }
View Replies !
Changing Array Format From Result Of MySQL
here is what MySQL returns in a visual way.. game_id | team_id | stat_id 1 | 1 | 1 1 | 2 | 3 1 | 3 | 7 1 | 3 | 6 2 | 1 | 1 2 | 4 | 3 in records with the same game_id, there will be no repeating team_id in records with the same team_id, there will be no repeating stat_id so, after I got the query, I made them into this format PHP Code:
View Replies !
Can I Put A Mysql Query Result Directly Into A Multidimensional Array?
I have two joined tables: Departments - which contains the department description and a key Positions - which contains position data What I'm attempting to achieve is to display the department title in one table cell and then list all the positions associated with that department in the cell under neither the title. I need to generate a table two column table with as many rows as required, depending on the number of departments, which is dynamic. Do this I'm trying to turn the result of my SQL query into multidimensional array e.g. dept = VioP positions = "designer", "engineer" etc, which I can do then use to generate the table. I've done a search on the forum and looked around the manual and I'm stumped on how to achieve this, a point in the right direction would be greatly appreciated. The query I'm using is below. PHP Code:
View Replies !
An Extra Last Empty Field In An 'mysql_fetch_array' Result Array?
I seem to get an extra empty field in every 'mysql_fetch_array' command I issue. For example: I have a simple table 'tblName': ID Name 1 Jane 2 Joe 2 Doe The following code: $oCursor = mysql_query("SELECT ID from tblName WHERE Name='Jane'"); if (!$oCursor) { $bGo = false; } else { $aRow = mysql_fetch_array($oCursor); } results in: count($aRow) = 2; $aRow[0] = 1; $aRow[1] = '' Am I missing something, doing something wrong, a wrong PHP setting?
View Replies !
Making Mysql Result Into Multi-dimensional Array
My php problem is I want to make the result of 3 tables linked through foreign keys into a 3-dimensional array that reflects their relationship without repetition and without having to call the database more three times. I know I'm doing a couple of things wrong, one thing for instance is initializing a variable at the end of the loop to remember the previous value s that it does not repeat itself, surely there must be a more elegant way to go about this, but I'm lost and I've been stuck on this all day. Code:
View Replies !
Outputting XML From PHP
Today I decided to teach myself both PHP and XML ... so I decided to make a little address book. After I finished it I found this: http://www.tonymarston.net/php-mysql/sablotron.html which describes more or less what I did. The main difference is that users are able to add entries into my address book. When an entry is added I get all of the address book info as post data. I take this data then print out a whole new xml file. Is there a better way to do this? Right now 95% of the PHP I wrote saves a new XML file ... the other 4 lines transform the XML with some XSL and displays the results. I suppose Im too used to working with databases where I can (more or less) write "Insert Whatever into AddressBook"
View Replies !
Outputting A Sum
I'm trying to output the sum of a column. Here is the code I have. <? $query2="SELECT Sum(num) FROM tbl_secrets"; $totalviews = mysql_query($query2); echo $totalviews; ?> The output I get is: Resource id #6 I've tried everything. I got so angry I just got up and left, because I knew I would have started hitting my computer or someone else. So, I tried mysql_fetch_array, and mysql_fetch_assoc. Neither worked. Can someone help me calm my nerves?
View Replies !
Nl2br But Outputting <p> </p> Rather Than <br />
I have a news sytem and at the moment I am using nl2br() (php and mysql). My styles have been designed for, and I would prefer to use paragraphs. I am requiring a method instead: news<br /> blah<br /> To output: <p>news</p> <p>blah</p> to be valid xhtml
View Replies !
Outputting The /usr/bin/top Command.
The code below will display the server uptime using the uptime command in linux. How would you go about displaying the /usr/bin/top command? i've noticed there are miscellaneous commands in linux relating to performance etc.. is there a way in php just to run a command like uptime and output it in its raw format? PHP Code:
View Replies !
PHP & SQL - Outputting Messages
Ive managed to connect my sql database using php but the problem im coming across is outputing a message if something equals to null, i.e. i have an attribute in the database called 'Imagename1' so what i want to do is print out a message saying 'no image exist' Code:
View Replies !
PHP Not Outputting Information
I am trying to pull info from a MySQL dbase with a simple script that recieves info from a get request such as http://mysite/subfolder/index.php?where=Alaska The code for the request is as follows Code:
View Replies !
Outputting HTML In PHP
I have a page called basket.php that is supposed to output the basket. So I have all the html and then it gets to the part in the page where I neeed to output the item sin the basket. I have a class called Basket.php that I used to add items and delete items. Should I add a function called Output that outputs them all in a table? It's just I heard it was bad to output html in php like this: echo "<table> <tr> <td style='.....'>"; echo "blahhh">; So how do you normally output tables, images, links and other dynamic content?
View Replies !
Outputting To Be Taken Literally
im dynamically generating a page for which i have a javascript function that can generate errors. i have several lines like : error += "error message"; so i can then alert a list of errors, on seperate lines but when i create the page, it outputs it as: error += "error message";
View Replies !
Outputting Distinct
I'm trying to output ONLY once, as a list of the items that have been updated. Now, some of the items may have multiple entries. I've tried something like that but keep getting duplicates: Quote: SELECT DISTINCT * FROM T1 LEFT JOIN T2 ON ( T1.a1 = T2.a2 ) WHERE a1 = 'x'
View Replies !
Outputting $_GET
I am trying to dynamically build links at the bottom of a search result page, and am having a problem carrying the querystring info over. On the search form the user has the option of selecting multiple cities as part of the search criteria, so the resulting querystring looks something like this: result.php?country=1&city%5B%5D=72&city%5B%5D=12&city%5B%5D=14&industry=12 I don't know how to handle that array in terms of echoing it out to the page as part of the "Previous" "next" links at the bottom of the page. I just get a link such as: "next=array" instead of the proper querystring info.
View Replies !
Outputting A List
PHP Code: foreach($emailArray AS $name=>$email){ Â Â Â Â if(mail($email,"Subject","Body","From: Whoever <me@me.com>")){ Â Â Â Â Â Â Â Â echo "E-mail sent to: <b>".$email."</b><br>"; Â Â Â Â } else { Â Â Â Â Â Â Â Â echo "<font color="red">E-mail NOT sent to: <b>".$email."</b></font><br>"; Â Â Â Â } } So basically, what currently happens, is that it only displays the output of the script once the entire script has finished. So when you are sending 2000 emails, only once the script has completed does it display the results.
View Replies !
Outputting Image To File
Trying to get any image format to save an image to file instead of displaying it in the browser, the only one i can get working is wbmp which does'nt seem to save correctly as an image and can't be opened in photoshop. anyone have any ideas, below is the code i am using with png which just displays a broken image. <? //header makes sure it refreshes header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); //Date in the past header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header ("Cache-Control: no-cache, must-revalidate"); //HTTP/1.1 header ("Pragma: no-cache"); $image = imagecreate(200, 200); //colors $grey = ImageColorAllocate($image,200,200,200); $white = ImageColorAllocate($image,255,255,255); //visualise image header("content-type: image/png"); imagepng($image, "image.png"); imagedestroy($image); ?>
View Replies !
Outputting Data In Categories
I'm trying to organize some data into categories. Lets say for example we have this: while ($row = mysql_fetch_assoc($result)) { $data1 = $row["field1"]; $data2 = $row["field2"]; $data3 = $row["field3"]; $data4 = $row["category"]; echo $data4?><br><?php; echo $data1,$data2,$data3?><br><?php; } Which would have a sample output like this: Category1 Field1Field2Field3 Category1 Field1Field2Field3 Category2 Field1Field2Field3 Category2 Field1Field2Field3 How would I get it to print the category name once, then everything belonging to that category, then move to the next category, etc. So it'd look like this: Category1 Field1Field2Field3 Field1Field2Field3 Category2 Field1Field2Field3 Field1Field2Field3 That's the simplest way I can think of putting it. :) Seems to me like it'd be an easy answer, but I've tried a couple of different approaches and can't seem to get it to work.
View Replies !
|
TRACKER
