PHP/MySQL Select and drop into multidemesional array - 04/29/03 08:51 AM
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.
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.
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.
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>
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 ) );
http:/
Any help I am most thankful.