Simpler method of getting variables from mysql

Posted on 16th Feb 2014 07:03 pm by admin

Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to me that there might be an easier way to get variables from a mysql query and that if anyone knew how to do it, it would be you guys.

Here is the code I use now:

Code: // Pulls the data from the database
$dblookup = "SELECT moduleID, menu_name, stylesheet_name, display_name, has_menu, access_control, installed, compatible, active FROM core_modules WHERE moduleID=" . $_GET['ID'];
$data = mysql_query($dblookup) or die('Failed to return data: ' . mysql_error());
/* sorts the data into variables and puts them in an array ready to be called when needed */
list($moduleID, $menu_name, $stylesheet_name, $display_name, $has_menu, $access_control, $installed, $compatible, $active) = mysql_fetch_array($data, MYSQL_NUM);
}
Is there a way I can just do SELECT * FROM and then have it automatically extract the data into variables based on the column name?

Your Answer:

Login to answer

Other forums

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists

Help with simple query
Hi,

I'm trying to do a Query with a Union where I want to print the number of rows $tc conta

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Recording popularity by day, week.. all time?
Hey everyone, I'm creating a site designed around users uploading music. How can I implement a syste

Pro-rata Billing in Periodic Billing for Rental
Hi guys,

We have a situation, where a rental contract starts at the mid of the month say

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public