Total newb - a MySQL query ...?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Bansaw
Forum Newbie
Posts: 1
Joined: Fri Nov 12, 2010 10:22 am

Total newb - a MySQL query ...?

Post by Bansaw »

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.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: Total newb - a MySQL query ...?

Post by Celauran »

If you're using Joomla, this article should help you out.
Post Reply