Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
Jamroom Developers:
pulling a specific db entry for db table
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 09/18/09 21:21 
I would like to pull this by status but i want to pull all of 1 status how would i do this
lets say i have 3 status's new pended and completed how would i have this just pull the new status any suggestions thanks james..... sorry i know this is just simple php/sql

ORDER BY db_update DESC";
$_rt = dbQuery($req,'NUMERIC');
if (isset($_rt) && is_array($_rt)) {
foreach ($_rt as $_module) {
$dat[1]['title'] = $_module['db_id'];
$dat[2]['title'] = $_module['db_update'];
$dat[3]['title'] = $_module['db_status'];


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
elygen



Joined: 22 Feb 2007
Posts: 637

Posted: 09/19/09 19:45 
Need to add a where clause in the query. post the full $req variable. I may be able to do it for you.


_________________
~ Todd
=================
Happy Jamrooming
New Jersey
www.bandarray.com
Back to top
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 09/19/09 20:41 
Thanks that helped out a lot once I knew what direction to head in Where I looked it up in my php 6 book seen what i needed to see to work some trial and error and found out more interesting things I can do as well which should be easy because i use them at work in the system we work with.
Thnaks again


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
Jamroom Developers

 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.