Lost in query... Trying to get output from query....

From: Date: Mon, 11 Oct 2004 14:58:45 +0000
Subject: Lost in query... Trying to get output from query....
Groups: php.db php.general 
Request: Send a blank email to php-general+get-199177@lists.php.net to get a copy of this message
Greetings: I am having a problem with trying to get data out of my mySql database. I run my query which works fine and everything... I use: $admin_get_options_query_text = "Select * from adminpage"; $admin_get_options_results_reference = mysql_query($admin_get_options_query_text,$db_access) or die("Admin Get Options: ". mysql_error()); $admin_get_options_result = mysql_fetch_assoc($admin_get_options_results_reference); --------------------------------------------- When I run the query in mysql directly the results are. mysql> Select * from adminpage; +-------------+--------------------+------------------------------------------+ | adminpageid | file_name | description | +-------------+--------------------+------------------------------------------+ | 101 | nycalertstatus.php | Change New York City Threat Alert Status | +-------------+--------------------+------------------------------------------+ 1 row in set (0.00 sec) ------------------------------------------------ my problem is that I would like to get that output into my php code....I would like to have something that goes like this for each record.. The api# $adminpageid allows you to $description, and uses the file #file_name can anyone please assist.

« previous php.general (#199177) next »