-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Clare Media wrote:
> Guys really in need of some assistance here.
>
> I am reading an xml file and want to loop through the entire file and
> display the information.
>
> Unfortunately I am only showing 1 item. how can I go about showing all news
> i
That is not a two dimensional array. Its two one dimensional arrays and yo
do it like this
while ($row = mysql_fetch_array($result))
{
$title[] =$row['title'];
$description[] =$row['description'];
}
bastien
From: elk dolk <[EMAIL PROTECTED]>
To: "php-db@lists.php.net"
Subje
Sancar Saran wrote:
> Thanks for all those replies. It seems there was no easy solution (and or
> serializing was better solution) for us.
>
> Our arrays contains lots of things.. XML may not fit because content of
> array may broke xml structure.
>
Before you give up, take a look at the XMLDBX
Wrong! Take a look at the SET datatype
http://dev.mysql.com/doc/refman/4.1/en/set.html. This allows you to have an
array of values in a single field, and the user can select any number of
them.
Sort of, but not really: This is a really specialized keyword, and
depends on binary mapping o
"Sancar Saran" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Sunday 04 March 2007 23:04, Sancar Saran wrote:
>> Hi,
>>
>> I want to know is there any db server around there for store php arrays
>> natively.
>>
>> Regards
>>
>> Sancar
> Thanks for responses, it seems I have to g
Thanks for all those replies. It seems there was no easy solution (and or
serializing was better solution) for us.
Our arrays contains lots of things.. XML may not fit because content of array
may broke xml structure.
Thanks for help.
Regards
Sancar.
> >>>Hi,
> >>>
> >>>I want to know is th
CTED]>
CC: php-db@lists.php.net, php-general@lists.php.net
Subject: Re: [PHP-DB] array field type
Date: Sun, 04 Mar 2007 15:04:42 -0800
Not a single field, but there's several methods of storing trees of
information, which is what an array is. Here's one:
Nested Array storag
Not a single field, but there's several methods of storing trees of
information, which is what an array is. Here's one:
Nested Array storage table:
ArrayID (int, autonumber)
keyname (text)
parent (int)
data (bigtext or whatever would be appropriate for the data you're storing)
For an array l
On Sunday 04 March 2007 23:04, Sancar Saran wrote:
> Hi,
>
> I want to know is there any db server around there for store php arrays
> natively.
>
> Regards
>
> Sancar
Thanks for responses, it seems I have to give more info about situation.
In my current project, we had tons of arrays. They are ve
Title: RE: [PHP-DB] Array
This is hardly database related but nonetheless.
$myString = "Check one two three four. You did well to count to four.";
$myString = str_replace(".","",$myString);
$myString = strtolower($myString);
$myWords = explode(" ",
Use the strtolower function to reduce all letters to lower case.
Then use the stripos() function to find where the spaces are in the string
and use that position in the substr() function to parse out the individual
words in the string. From there you can put the chunks into an array or a
query or
Hi Ron,
> how do I put each word into an array (so there would be 12 components in
> the array) as well as remove the period and make the C in Check and the
> Y in You lower case
This isn't a DB question, please ask questions in the appropriate list.
But for reference, look up the str_replace, s
Dunno if its relevant, but the recommended way to use sessions is to assign
stuff to a $_SESSION['varname']...I don't really see anything wrong with the
code...
Also, what arrays are causing the problems?
bastien
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To:
Subject: [PHP-DB] Array
Hopefully these functions will explain it.
I'm starting the transaction, then provided it takes
with no errors it gets the commit
function begin()
{
mysql_query("BEGIN");
}
function commit()
{
mysql_query("COMMIT");
}
function rollback()
{
mysql_query("ROLLBACK");
}
begin();
$query = "INSERT INTO
When are you actually performing the insert into the database? The code
you posted is only changing the value of the variable $query. You also
need to have the database function to insert into the database.
Assuming it MySQL:
...
foreach(...) {
$query = "INSERT INTO ...";
mysql_query($query);
Actually it did just loop. I need to test again.
The insert statement is the the one $query =
So it's after yes, but contained in the braces, like
you diagram below.
Stuart
--- "Matt M." <[EMAIL PROTECTED]> wrote:
> where is your insert statement? I am guessing it is
> after your loop
>
>
where is your insert statement? I am guessing it is after your loop
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = "INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p)";
/This is where y
Yep, I had found it shortly before.
Only it's not looping. It is taking last value only.
Stuart
--- "Matt M." <[EMAIL PROTECTED]> wrote:
> if ( is_array( $_SESSION['l_industry'] ) ) {
> foreach ( $_SESSION['l_industry'] as $p ) {
> $query = "INSERT INTO Profiles_Industries
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = "INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p)";
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
Where would that go?
Stuart
--- "Matt M." <[EMAIL PROTECTED]> wrote:
> > if ( is_array( $_SESSION['l_industry'] ) ) {
> > foreach ( $_SESSION['l_industry'] as $p )
> {
> > $query = "INSERT INTO Profiles_Industries
> (ProfileID,
> > IndID)
> > VALUES ($LID, $p)";
> > }
>
> do you have a
> if ( is_array( $_SESSION['l_industry'] ) ) {
> foreach ( $_SESSION['l_industry'] as $p ) {
> $query = "INSERT INTO Profiles_Industries (ProfileID,
> IndID)
> VALUES ($LID, $p)";
> }
do you have a } for the if statement?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Since you provided no value's it's a little tough, but the general for would
be:
$parts = array(
array("PN" => $row1col1, "Desc" => $row1col2, "Qty" => $row1col3),
array("PN" => $row2col1, "Desc" => $row2col2, "Qty" => $row2col3)
);
Depending on your implimentation, it maybe easier to use s
$arr = array('key' => array('key2' => 'value', 'key3' => 'value', ...),
...);
$arr['key2'] = array('key2' => 'value', ...);
$arr['key3]['key2'] = 'value';
On Thu, 26 Aug 2004 16:11:27 -0500, Miguel Guirao <[EMAIL PROTECTED]> wrote:
> Hi!!
>
> I have a table with many options from when the user
On Fri, 23 Jan 2004, NIPP, SCOTT V (SBCSI) wrote:
> I am trying to populate an array from a MySQL database. I think I
> have the code correct to populate the array, but I need to somehow sort the
> array eliminating duplicate values. I think I can loop through the array
> doing a compariso
NIPP, SCOTT V (SBCSI) wrote:
> I am trying to populate an array from a MySQL database. I think I
> have the code correct to populate the array, but I need to somehow
> sort the array eliminating duplicate values. I think I can loop
> through the array doing a comparison and building a new a
Hi
Pete I forgot to write that $acces is a field from Db and there are values
1,2,3,4
a need to split those values to make that IF
Brettking thanx mate I think that is a solution
"Brettking" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> Hi
>
> From what I can work out you need t
Hi
>From what I can work out you need to use a function called
in_array(value,array);
http://www.php.net/manual/en/function.in-array.php here is the php manual
link
Hope this is what you want
Brett
-Original Message-
From: peppe [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 16:07
To:
From: "ShortStay" <[EMAIL PROTECTED]>
> How do you delete a value and key from an array? I know the value.
You need to know the key.
unset($Array[$key]);
There are various array functions that'll find the key for you if you know
the value.
> Is it OK to post array questions to the db list?
N
tion system not seen by many users.
Aaron
> -Original Message-
> From: OpenSource [mailto:[EMAIL PROTECTED]
> Sent: August 17, 2003 12:28 PM
> To: Aaron Wolski
> Cc: PHP-DB; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] array issue
> Importance: High
>
> Hey guys
>
To: <[EMAIL PROTECTED]>
Cc: "'PHP-DB'" <[EMAIL PROTECTED]>; "'OpenSource'" <[EMAIL PROTECTED]>
Sent: Sunday, August 17, 2003 10:04 AM
Subject: RE: [PHP-DB] array issue
> Good point and nice find, Jeff!
>
> I wasn't sure
y too?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: August 17, 2003 11:48 AM
> To: Aaron Wolski
> Cc: 'PHP-DB'; 'OpenSource'
> Subject: RE: [PHP-DB] array issue
>
>
> This may or may not make sense for your iss
PROTECTED]>, "'PHP-DB'" <[EMAIL PROTECTED]>
z.com> cc:
First, are you sure there is data in $my_array?
Add this after you set the array:
echo """.print_r($my_array)."";
You'll need to loop through the array , writing each line in the file at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $va
Snijders, Mark wrote:
hi,
no the both sollutions won't work cause:
I can't sort within a query cause subnetaddr is a varchar ("10.10.10.10")
so it will be ordere like this
10.10.10.10
100.10.10.10
60.10.10.10
and that's not good cause 60 is smaller as 100, so with the function
ip2long() i will
() )
- compare successively item by item
HTH
Ignatius
_
- Original Message -
From: "Snijders, Mark" <[EMAIL PROTECTED]>
To: "'Becoming Digital'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 8:33 A
do a query again to get the other
fields of the table, and that's not good (2500 rows)
so can please still somebody help me with this?
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: dinsdag 10 juni 2003 15:42
To: [EMAIL PROTECTED]
Subject: Re: [
I might be overlooking something, but can't you just do this?
$query = "SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddr";
If you can't, you can sort the array like this.
You can subsequently sort the array for the desired r
hi,
you can add the ip2long() function into your SELECT statement and have
an ORDER BY clause at the end like this...
SELECT s_id, subnet_name, ip2long('subnetaddr'), subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddrr;
hope it helps.
KD
On Tue, 10 Jun 2003, Snijders
My database is set up in this way:
fan_roster: has player id (play_id) , week, and stats on that player for
that week. So there are 20 records for each player, because there are 20
weeks.
So what I need to do is add up all the players weekly totals. so pass_yrd1
for week1 + pass_yrd1 for week2 et
> -Original Message-
> From: Ian Fingold [mailto:[EMAIL PROTECTED]
> Sent: 03 June 2003 16:58
>
> Ok I'm trying to write this function to up date some fields
> in my database
> so i'm grabbing some info from a query and throwing it into
> an array (with
> mysql_fetch_array).
>
> one of
> Hello everyone. If I wanted to pass a item ID along with a quantity to an
> associative array called "CartArray" how would I pass it to the PHP
script?
>
> I'll get this shopping cart working yet !!
If the question is how do you pass an array to another PHP page, you
serialize() and urlencode()
27;]['qty']="32";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Boa Constructor [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 02,
RE: [PHP-DB] Array QuestionCheers Gary, and in the html would I put something like:
buy this item
Simple question I know!
Jay, yup thats all I want to do, just assign two values into an array.
Thank you,
Graeme :)
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
CartArray['itemid'] = $itemid;
where $qty = CartArray['qty'];
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Boa Constructor [mailto:[EMAIL PROTECTED]
> Sent: Monday,
On Wednesday 26 February 2003 00:37, Jorge Miguel Fonseca Martins wrote:
As this has nothing to do with databases you should post to the php-general
list.
> $test[]="a";
> $test[]="b";
>
> foreach ($test as $key=>$value)
> {
> if($key == "something") echo $key
> }
>
> even though theres n
There are really a few ways that you can solve this problem. I would use
and associative array to do this.
Making the array associative would work like this:
$ALL_VALUES["$year"] += $value;
To retrieve the information back you would use the following loop:
While($element = each($ALL_VALUES))
{
On Friday 24 January 2003 14:18, Tyler Whitesides wrote:
> I have been having a lot of trouble getting an array into the MySQL table
> like I want it. This is supposed to take the current maintenance tasks
> from a table in the database on apple.php each of these is given a name
> $item[autoNo] w
on 1/22/03 12:08 AM, Michael Conway at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I find myself stuck in coming up with a way to cycle through this
> array of db results for porting to a graphing script that I did not
> write. My latest attempt to get around this problem is below
On Monday 20 January 2003 17:50, Dave Carrera wrote:
> I have nearly got this working but it dose not seem to loop though or
> return the result
>
> I have done something wrong and I ask one of you coders that are much
> cleverer that I to glance over my code to see the obvious mistake / s.
Can y
$arr = array(".co.uk",".com",".net",".me.uk");
echo "Top Level Domains: ";
while(list(,$tld)=each($arr)) {
echo $tld.", ";
}
On Sun, 19 Jan 2003, Dave Carrera wrote:
> Hi All
> I am trying to create a tld lookup script for uk and main us domains.
>
> I have success by creating multiple functi
Just loop through the first index, then search on the second index:
while ( list( $key, $value ) = each( $my_arr ) ) {
// now $value is your ( [0] => 10 [1] => 40 [2] => 50 [3] => 80 [4] =>
130 [5] => 220 [6] => 320 ) array
// sort your array by values
sort( $value ) ;
// get the
to precise:
$array = Array('name'=>'Maxim', 'surname'=>'Maletsky');
unset($array['name']);
// now array has this structure:
// Array('surname'=>'Maletsky')
--
Maxim Maletsky
[EMAIL PROTECTED]
Jason Wong <[EMAIL PROTECTED]> wrote... :
> On Friday 08 November 2002 17:25, nikos wrote:
> > Doe
On Friday 08 November 2002 17:25, nikos wrote:
> Does anybody know how to remove an item from an array?
> Let's say
>
> $array('banna', 'apple','cherry')
> foreach ($array as $value) {
> if ($value=='chery') DELETE $value FROM $array
> ...
unset().
--
Jason Wong -> Gremlins Associates -> ww
$newInfo[$stripped] = $value;
---John Holmes...
> -Original Message-
> From: Rich Hutchins [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 13, 2002 3:42 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Array Initialization
>
> Please forgive me ahead of time, but I didn't want to subsc
On Thursday 20 June 2002 23:26, Richard Black wrote:
> By passing a second parameter to mysql_fetch_array, MYSQL_ASSOC
>
> This means you only get back an array with the values indexed by
> fieldname.
Or just use mysql_fetch_assoc().
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
O
Try putting the hidden element statement down inside the while loop in he
second page, but change it to "" and add
$id=$row['id'];
before it.
I will show below where it should go.
HTH
MB
jas <[EMAIL PROTECTED]> said:
> I have made the changes you suggested which if you ask me have been
I have made the changes you suggested which if you ask me have been the most
informative answers I have recieved thus far. I did run into a slight snag
on line 21 which is this on my confirmation page "" and the parse error is as follows...
Parse error: parse error, expecting `STRING' or `NUM_STR
Ok, you have almost got it. I have made little remarks further down in your
code which should just about do it for you.
jas <[EMAIL PROTECTED]> said:
> I don't know what it is but I am having a hell of a time trying to get some
> results of a query setup into an array or variable (too much of
Well ok now that I know it isn't an array I am having problems with, how
exactly am I supposed to create a variable (that can be passed to another
page) from a selected set of records?
Thanks again for the politeness,
Jas
"Spyproductions Support Team" <[EMAIL PROTECTED]> wrote in message
[EMAIL PR
That's not Array Hell, this is Array Hell:
$Hell = array("satan","fire","brimstone");
-Mike
> -Original Message-
> From: jas [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 22, 2002 4:37 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Array HELL
>
>
> I don't know what it is bu
Need to show us more code...
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 2:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Array not supported for strings???
Hi there,
I have a problem with an array:
This code:
$country[] = $row->country;
Cre
- Original Message -
From: "Jim Lucas" <[EMAIL PROTECTED]>
To: "Bart Verbeek" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 12:42 PM
Subject: Re: [PHP-DB] array-problems
> Try this:
>
> <<< BEGIN:PHP-C
It looks like you need only one array, $date[begin] = $date[end].
Let's see, I think it'll work. I'll write it in your code then you try:
$i=0;
$result = mysql_query ("SELECT DISTINCT date FROM linktracker WHERE name
LIKE '$PHP_AUTH_USER' ORDER BY date");
if ($row = mysql_fetch_array($result)) {
the subarrays contain variable data and I tried to express that by showing
the array structure that way
if I access $needed_data[0]
it would be an array of two pieces of data ( both variable)
$needed_data[1] would also be an array of two variable pieces of data, etc
if I loop through them all
For one, why are you redefining the array 3 times in that script? ...
I'm trying to follow here... and its not making sense.
-Original Message-
From: Larry Linthicum [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:14 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array from html
scratch that, i had a syntax error in the array..
you were completely right dobromir eval() works perfectly..
thanks!
Brendan wrote:
> thanks dobromir,
> unfortunately that doesnt seem to work ...
> although looking at the php manual you seem to be on the right track..
> could the way the
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the textfield is parsed & passed back affect the array?
cheers!
brendan
Dobromir Velev wrote:
> Hi,
> I think you can use the eval() function to exec
Hi,
I think you can use the eval() function to execute the stored info. The code
will look something like this
$res=mysql_query(...)
eval($row_from_query);
If you want to change the name of the array you could use
eval(str_replace("$array","$newarray",$row_from_query));
HTH
Dobromir Velev
-
> Perhaps I've misunderstood.
>
> I thought this IS a PHP list (see Rolf Hopkins below).
It's a PHP/Database list, not just PHP. POsts should have something to do
with BOTH.
> Secondly, this list is not only for MySQL questions and issues (see Cal
> Evans below). It is for all database questio
Richard L. Emery
IT Sr. Project Manager
"There is no 'trying'...
There is only 'Do' or 'Not Do' "
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:50 AM
To: Keith Spiller
Cc: [EMAIL PROTECTED]
Subject: R
Hi Keith,
1: Don't cross-post. It's rude. Especially since this has nothing to do with
MySQL.
2: You are not building a multi-dimensional array. The code below won't even
build a single dimensional array because you didn't put your keys in quotes
so it's probably blowing chunks. At the very leas
In article <061201c0a063$08eab5a0$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Keith Spiller") wrote:
> This associative array embedded within a function and declared as a global at
> the start of the function, is meant to be a multidimensional array, but with
> every loop of the while ($myrow = my
""JJeffman"" <[EMAIL PROTECTED]> wrote in message
000701c09ba2$3b2bb020$f0d4d7c8@jjeffman">news:000701c09ba2$3b2bb020$f0d4d7c8@jjeffman...
> I've already made an object which had a property that was an array. Now I
> need to have an array that can hold objects as its elements is It possible
?
>
73 matches
Mail list logo
