XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / Xoops DB functions: howto
Register
1
kaotik
Xoops DB functions: howto

  • 2004/10/4 14:05

  • kaotik

  • Just can't stay away

  • Posts: 861

  • Since: 2004/2/19


I've been tring to understand how to access tables in the XOOPS DB.
So far I've got this:
// To delete rom from table
$query = "Delete from ".$xoopsDB->prefix("xoops_table")." where id='$id'";

// To insert a row into the table
$query = "Insert into ".$xoopsDB->prefix("xoops_table")." (testing1, testing2) values ('$test1','$test2')";


But what if I want the value of a particular column from a certain row? How would I retreive it?

Thanks
2
ackbarr
Re: Xoops DB functions: howto

that is a select query:

$query = 'SELECT field1, field2 FROM ' . $xoopsDB->prefix('tablename') . ' WHERE searchfield1 = 'value1'';
3
kaotik
Re:Xoops DB functions: howto

  • 2004/10/4 15:58

  • kaotik

  • Just can't stay away

  • Posts: 861

  • Since: 2004/2/19


Thanks!! That's exactly what I was looking for

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

401 user(s) are online (337 user(s) are browsing Support Forums)

Members: 0

Guests: 401

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits