UGN Security Forums
My ProfileMember DirectoryLogin
Search our ForumsView our FAQView our Site Rules
View our CalendarView our Active TopicsGo to our Main Page

UGN Security Store
 

Network Sites UGN Security, The GoNix Initiative, Elite Web Gamers, Back of the Web, EveryDay Helper, VNC Web Design & Development
July
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
Sponsored Links
Latest Postings
Latest Reviews
Topic Options
Rate This Topic
#19378 - 04/29/03 09:51 AM PHP/MySQL Select and drop into multidemesional array
§intå× Offline


*****

Registered: 12/03/02
Posts: 3255
Loc: 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.
_________________________
My New site OpenEyes

Top
Sponsored Links
      
#19379 - 04/30/03 07:46 AM Re: PHP/MySQL Select and drop into multidemesional array
§intå× Offline


*****

Registered: 12/03/02
Posts: 3255
Loc: Maryland
No help? Common guys, anyone at all wana take a crack at this?
_________________________
My New site OpenEyes

Top
#19380 - 05/02/03 05:48 AM Re: PHP/MySQL Select and drop into multidemesional array
§intå× Offline


*****

Registered: 12/03/02
Posts: 3255
Loc: Maryland
Still now help? Anyone, anyone at all?
_________________________
My New site OpenEyes

Top
#19381 - 05/02/03 04:27 PM Re: PHP/MySQL Select and drop into multidemesional array
jonconley Offline
UGN Super Poster

Registered: 10/08/02
Posts: 955
Loc: Merrill, IA, USA
What have you tried?

Top
#19382 - 05/05/03 04:34 AM Re: PHP/MySQL Select and drop into multidemesional array
§intå× Offline


*****

Registered: 12/03/02
Posts: 3255
Loc: 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?
_________________________
My New site OpenEyes

Top
#19383 - 06/03/03 02:25 PM Re: PHP/MySQL Select and drop into multidemesional array
1Guess Offline
Junior Member

Registered: 06/14/02
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..

Top
#19384 - 06/03/03 02:59 PM Re: PHP/MySQL Select and drop into multidemesional array
1Guess Offline
Junior Member

Registered: 06/14/02
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 >

Top

Moderator:  §intå×, Gremelin 
Featured Member
Registered: 03/05/02
Posts: 9
Forum Stats
2145 Members
46 Forums
33526 Topics
68693 Posts

Max Online: 1567 @ 04/25/10 10:20 AM
Top Posters
UGN Security 26689
Gremelin 7192
§intå× 3255
SilentRage 1273
Ice 1146
pergesu 1136
Infinite 1041
jonconley 955
Girlie 908
unreal 860
Newest Members
Jimmie Menon, fghijk435948, Devo60, ali, lavos
2147 Registered Users
Who's Online
0 registered (), 715 Guests and 313 Spiders online.
Key: Admin, Global Mod, Mod
Latest News


Donate
  Get Firefox!
Get FireFox!