Your browser does not seem to support CSS. If images appear below, please disregard them.
It appears that you're running an Ad-Blocker. This site is monetized by Advertising and by ">User Donations; we ask that if you find this site helpful that you whitelist us in your Ad-Blocker, or make a ">Donation to help aid in operating costs.
Previous Thread
Next Thread
Print Thread
Rate This Thread
#19378 - 04/29/03 08:51 AM PHP/MySQL Select and drop into multidemesional array  
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå×  Offline


Joined: Dec 2002
Posts: 3,255
Likes: 3
Maryland
I want to perfect some of my scripts. To do this I need to minimize the number of times I hit the databases. Currentley for a drop down menu I do something like the following.

Code
<select name="somename">
 $quer = mysql_query("SELECT * FROM Svc_mgr WHERE id  = '$id'");
while($quer2 = mysql_fetch_array($quer)) {
echo "<option value=\"".quer2['id']."\">".$quer2['name']."</option>";
}
</select>

 
I should be able to make a single call to each table and draw all the infor mation I need and set it into a multi demesional array to call throughout each section of the script.

For example

Table1 is in database one. It has the following collums

name(varcher(25)) - timestamp(varchar(20)) - id(int(11))

some examples of rows might be

John Doe - 04/29/03 - 05:34:06 - 01
Jane Doe - 04/28/03 - 05:34:06 - 02
Jimmy Doe - 04/27/03 - 05:34:06 - 03

I want to call to the database and put each colum into a array dynamicaly.
Code
  
$multiarray = array(
  "name" => array(
               1 => "John Doe",
               2 => "Jane Doe",
               3 => "Jimmy Doe"
                    ),
  "timestamp" => array(
               1 => "04/29/03 - 05:34:06", 
               2 => "04/28/03 - 05:34:06",
               3 => "04/27/03 - 05:34:06" 
                    ),
  "id" => array(
               1,
               2,
               3
                    )   
                );                  
 
How do I do that dynamicaly? First problem I have is the commas. The last entry can not have a comma. It will cause a parse error. This is harder than it seems at first. I have spent a few hours ripping my hair out and reading on arrays on php.net

http://www.php.net/manual/en/language.types.array.php

Any help I am most thankful.

Sponsored Links
#19379 - 04/30/03 06:46 AM Re: PHP/MySQL Select and drop into multidemesional array  
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå×  Offline


Joined: Dec 2002
Posts: 3,255
Likes: 3
Maryland
No help? Common guys, anyone at all wana take a crack at this?

#19380 - 05/02/03 04:48 AM Re: PHP/MySQL Select and drop into multidemesional array  
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå×  Offline


Joined: Dec 2002
Posts: 3,255
Likes: 3
Maryland
Still now help? Anyone, anyone at all?

#19381 - 05/02/03 03:27 PM Re: PHP/MySQL Select and drop into multidemesional array  
Joined: Oct 2002
Posts: 955
jonconley Offline
UGN Super Poster
jonconley  Offline
UGN Super Poster

Joined: Oct 2002
Posts: 955
Merrill, IA, USA
What have you tried?

#19382 - 05/05/03 03:34 AM Re: PHP/MySQL Select and drop into multidemesional array  
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå×  Offline


Joined: Dec 2002
Posts: 3,255
Likes: 3
Maryland
Code
 
$quer = mysql_query("SELECT * FROM Svc_mgr WHERE id  = '$id'");
$count = 0;
$some_array = array(
while($quer2 = mysql_fetch_array($quer)) {


                    "name" => array(
                          $count => "".$quer2['fname']."" "".$quer2['lname']."",)
}                   "phone" => araay(
                          $count => "".$quer2['phone']."",)
                    "cell" => array(
                          $count => "".quer2['cell_phone']."",)
$count = $count++;
}
)
Now this will not work for obvious reasons. for one the last entry for each sub array can not have a trailing comma. Also every time it loops
through it will look like so


Code
  
$multiarray = array(
               "name" => array(1 => "John Doe",)
               "name" => array(2 => "Jane Doe",)
               "name" => array(3 => "Jimmy Doe",)
                  ), ), ),

               "name" => array(1 => "04/29/03 - 05:34:06",) 
               "name" => array(2 => "04/28/03 - 05:34:06",)
               "name" => array(3 => "04/27/03 - 05:34:06",) 
                    ),),),
  
               "id" => array(1,)
              "id" => array( 2,)
               "id" => array(3,)
                    )   
                );                  
 
So here I am slaming my head into the desk out of frustration. I know I am doing something all wrong. I just want to know what the right way is. I have been all through http://www.php.net looking for how to do what I want to do.

Any ideas?

Sponsored Links
#19383 - 06/03/03 01:25 PM Re: PHP/MySQL Select and drop into multidemesional array  
Joined: Jun 2002
Posts: 3
1Guess Offline
Junior Member
1Guess  Offline
Junior Member

Joined: Jun 2002
Posts: 3
your code doesn't make sense for a multi-dimesional array because your naming the parts between a named array.
secondly why don't you just use three sperate arrays because u can use many functions to modify one array which does the same to the others..

#19384 - 06/03/03 01:59 PM Re: PHP/MySQL Select and drop into multidemesional array  
Joined: Jun 2002
Posts: 3
1Guess Offline
Junior Member
1Guess  Offline
Junior Member

Joined: Jun 2002
Posts: 3
from what i can figure why don't you do something like:

Code
$num = mysql_numrows( $result );
$i = 0;
$names = "";
$ids = "";
$timestamps = "";
while (i < $num)
{
$name=mysql_result($result,$i,"name");
$timestamp=mysql_result($result,$i,"timestamp");
$id=mysql_result($result,$i,"id");
$names = $name . "\"name\" => array($id => \"$name\",)";
$timestamps = $timestamps . "$id =g> \"$timestamp\", ";
$ids = $ids . "$id,";
$i = i + 1;
}
$multiarray = array(  "name" => array(     $names        ),  "timestamp" => array(  $timestamps ),  "id" => array( $ids )                   );  
edit to replace greaterthansymbol with >


Member Spotlight
Gremelin
Gremelin
Portland, OR; USA
Posts: 7,202
Joined: February 2002
Show All Member Profiles 
Forum Statistics
Forums41
Topics33,702
Posts68,797
Average Daily Posts0
Members2,172
Most Online1,567
Apr 25th, 2010
Latest Postings
Okay WTF?
by HenryMiring on 09/27/17 08:45 AM
The History Thread...
by Gremelin on 08/11/17 07:11 PM
my old account still exists!
by Gremelin on 08/11/17 07:02 PM
My friend NEEDS your HELP!
by Lena01 on 07/21/17 07:06 AM
I'm having fun with this guy.
by gabithompson730 on 07/20/17 08:50 AM
I want to upgrade my phone
by gabithompson730 on 07/20/17 08:49 AM
Newbie here
by gabithompson730 on 07/20/17 08:46 AM
Blackbeard.....
by Gremelin on 01/14/17 07:03 PM
Top Posters(All Time)
UGN Security 41,392
Gremelin 7,202
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Liked Users (All Time)
§intå× Likes: 3
Black Beard Likes: 1
Cold Sunn Likes: 1
Crime Likes: 1
Cyrez Likes: 1
fleshwound Likes: 1
Ghost Likes: 2
Gremelin Likes: 12
Ice Likes: 1
ninjaneo Likes: 1
Powered by UBB.threads™ PHP Forum Software 7.6.0
(Snapshot build 20170206)