12
Sure, I can post as much code as you want. I intend to distribute this module free/open source when its done. At the moment I'm just trying to get something that works before I polish it. Its intended to allow admins to manage a guest list for an event (with RSVPs and such). At the moment inserting into the database with either my old method (above) or the given method (also above) both work with the offending lines commented out.
The table name is xoops_caseyguestlist
xoops_ will later be changed to be the prefix as in the documentation.
Here's the relevant function for (eventually) outputting a table of guests.
function OutputGuestList()
{
print(" n");
print("Name: | Street1: | Street2 | City: | State: | Zip | Edit: | Delete | n");
$result = $xoopsDB -> query("SELECT * FROM xoops_caseyguestlist LIMIT 0,30");
while ($row = $xoopsDB->fetchArray($result))
{
print "ID:".$row{'id'}." Name:".$row{'name'}." ".$row{'zip'}."
";
}
print("
n");
}
If there is any other code that might be relevant let me know and I'll put it up here.
Edit: Up until a couple days ago I used C++/perl so its entirely possible I pulled off some little PHP no-no that I haven't realized.