[posted and emailed]
If you're looking for a simple way to work with databases I would use
phplib. Phplib is a db abstraction layer which supports over a dozen
databases including mysql. You can get the libraries at
http://phplib.netuse.de/download/phplib-7.2c.tar.gz You will need to
use "db_mysql.inc"
I think using mysql specific functions is bad programming. Database
specific calls should be abstracted out whenever possible.
To do something like you would want to do you would use code like
this:
// create the db object
$db = new DB_Sql;
// initialize db parameters
$this->Host = <your host>;
$this->Database = <db>;
$this->User = <user name>;
$this->Password = <password>;
// E.g. make a simple query
$db->query("select username, uid, security_level from access where
username='$f_username' and password='$f_password';");
$db->next_record();
$db_username = $db->f("username");
$si_userid = (int)($db->f("uid"));
$si_security_level = (int)($db->f("security_level"));
// putting the values in an array is trivial, but you should do it
like this
// or you will confuse your numeric ids with the ids that php
puts in an array automatically
$my_array["username"] = $db_username;
$my_array["userid"] = $si_userid;
On 11 Apr 2001 09:09:09 -0700, [EMAIL PROTECTED] ("Ashley M.
Kirchner") wrote:
>
> I need to convert an MySQL result into an Array...somehow. The
>query returns the following:
>
> +----+-----------+
> | ID | Project |
> +----+-----------+
> | 1 | Home |
> | 2 | Work |
> | 3 | Family |
> | 4 | Misc. |
> | . | ... |
> | . | ... |
> +----+-----------+
>
> ...which I want to convert into:
>
>Array(1 => "Home", 2 => "Work", 3 => "Family", 4 => Misc.", etc....);
>
> What's the best way to do this.
>
> AMK4
>
>--
>W |
> | I haven't lost my mind; it's backed up on tape somewhere.
> |____________________________________________________________________
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
> SysAdmin / Websmith . 800.441.3873 x130
> Photo Craft Laboratories, Inc. . eFax 248.671.0909
> http://www.pcraft.com . 3550 Arapahoe Ave #6
> .................. . . . . Boulder, CO 80303, USA
--
Jeff Greer
- B.S. computer science - Univ. MO - Rolla
- I do web hosting and development. Details
at http://www.singlesconnection.org/services/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
