Sending and recalling data to/from MySql

Have a programming question regarding your component, plug-in, extension or core hacks? Have an interesting tidbit, FAQ or programming tip you’d like to share? This is the place for you.

Moderators: tjay, seadap, Rogue4ngel, matthewhayashida

Post Reply
User avatar
bohn002
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Thu Aug 18, 2005 6:14 pm
Location: Ohio-USA

Sending and recalling data to/from MySql

Post by bohn002 » Fri Aug 31, 2007 1:37 am

Ok, still new to this programming to MySql. I am making a comic store pull list, there is company name, comic name, issue number and how many needed set up in a form. I understand the php side mostly on building the component, just the sql stuff is messing up. I am collecting the username/real name in the form. How can i store the info to a table called pulllist and then be able to recall it based on username. thanks for the help!
remember pillage...then burn.

User avatar
moijafcor
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Mar 02, 2006 9:41 am
Location: Santo Domingo, Dominican Republic
Contact:

Re: Sending and recalling data to/from MySql

Post by moijafcor » Sat Sep 01, 2007 10:55 pm

Nicht mehr!
Los acentos en castellano omitidos intencionalmente. | Les accents et les signes en français omis intentionnellement.
http://bio.moisesjafet.com

User avatar
bohn002
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Thu Aug 18, 2005 6:14 pm
Location: Ohio-USA

Re: Sending and recalling data to/from MySql

Post by bohn002 » Sun Sep 02, 2007 2:00 am

Hmm, sorry, I'm working on th joomla 1.0.x series.
remember pillage...then burn.

User avatar
ianmac
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sat Sep 24, 2005 11:01 pm
Location: Toronto, Canada

Re: Sending and recalling data to/from MySql

Post by ianmac » Sun Sep 02, 2007 12:31 pm

Most of that document will still work, but:

instead of $db =& JFactory::getDBO()

put:
global $database at the top of your function.
And then substitute $database for $db.

Ian
Help test my Component XML Generator Tool!
http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,1997/Itemid,35/
All feedback appreciated!


Post Reply