Home :: Forums :: Downloads :: Shop
  1. Home
  2. Forums
  3. General PHP Nuke Help
  4. mysql query returing blank results for my new module

mysql query returing blank results for my new module

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1.    mysql query returing blank results for my new module
scrotaur
CZ Newbie
 Codezwiz Site Donator
scrotaur has been a member for over 19 year's 19 Year Member
usa.gif texas.gif
Occupation: CPSC Student
Age: 38
Gender: Male
Fav. Sports Team: Fightin´ Texas Aggies
Website:
Status: Offline
Joined: Oct 12, 2005
0.00 posts per day
Posts: 6
Points: 75
   
Howdy,

Ive recently been working on making a new phpnke module on my own, and all was going well, but then i got stuck on this problem:

Ive got this query:

$cquery = "SELECT * FROM ".$prefix."_clan_members_config";
    $cresult = $db->sql_query($cquery);
    while($conifgs = $db->sql_fetchrow($cresult))
    {
      echo "<form action=\"admin.php\" method=\"post\">\n"
       ."<table border=\"0\" width=\"100%\" cellspacing=\"5\">\n";
       
       //Enable Categories
       if($configs['enable_cats']=="1") {$chk1 = "checked"; $chk0 = " ";}
       else { $chk1 = " "; $chk0 = "checked";}
       echo "<tr><td width=\"30%\">Enable Categories?</td>\n<td width=\"70%\"><input type=\"radio\" name=\"en_cats\" value=\"1\" $chk1> Yes <input type=\"radio\" name=\"en_cats\" value=\"0\" $chk0> No</td></tr>\n";


There are a few more of the radi inputs, but thats pretty much what im having a problem with. Im not getting any values for the $configs array. The database table is one row with either a one or a zero for each column. Ive tried printing out the values. EX.
echo "<h4>Value".$config['enable_cats']."</h4>";


And it wil print out "Value ". I dunno whats wrong with it. Its probably something really simple im overlooking, but ive been working on this bug for about 2 hours now, and figured itd be good to try to get some help with it.

Thanks much,

~scro
Back to top Reply with quote
#2.    re: mysql query returing blank results for my new module
scrotaur
CZ Newbie
 Codezwiz Site Donator
scrotaur has been a member for over 19 year's 19 Year Member
usa.gif texas.gif
Occupation: CPSC Student
Age: 38
Gender: Male
Fav. Sports Team: Fightin´ Texas Aggies
Website:
Status: Offline
Joined: Oct 12, 2005
0.00 posts per day
Posts: 6
Points: 75
   
holy crap, sorry to waste anyones time whos reading this. I had it pointed out to me that one of the variable names is mis-spelled. Its just that it gets hard to catch those errors at 1 in the morning.

Once again, my appologies.

~Scro
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

∧