Total newb - a MySQL query ...?
Posted: Fri Nov 12, 2010 10:28 am
I've been writing my first php programs for my site.
This is the first time I am trying to access my SQL database.
I am not sure how to do it.
I want to access a text field. The database name is: Web37-j15
the table seems to be jos_modules
and the field name is a text field called param
I want to write something like this:
$currentvalue = $db->SetQuery(from params in jos_modules);
(I am trying to learn from the previous coder who helped on my site and he seems to be opening the database with: $db =& JFactory::getDBO();)
I think he used SetQuery to get the info, I am not sure. Total newb in this.
This is the first time I am trying to access my SQL database.
I am not sure how to do it.
I want to access a text field. The database name is: Web37-j15
the table seems to be jos_modules
and the field name is a text field called param
I want to write something like this:
$currentvalue = $db->SetQuery(from params in jos_modules);
(I am trying to learn from the previous coder who helped on my site and he seems to be opening the database with: $db =& JFactory::getDBO();)
I think he used SetQuery to get the info, I am not sure. Total newb in this.