You are not logged in. Please login or register.
PunBB Forums → Programming → What am I doing wrong?
What is wrong about this query?
$result = $db->query('SELECT t.name, m.name AS metalname FROM '.$db->prefix.'metaltypes AS t INNER JOIN '.$db->prefix.'metals AS m ON m.id=t.metal_id WHERE t.id='.$id) or error('Unable to fetch metal type info', __FILE__, __LINE__, $db->error());
if (!$db->result($result))
message($lang_common['Bad request']);
else
$name = $db->fetch_assoc($result);Moved to Programming
Enable debug mode, paste the full error
It is no error, it just doesn't return anything from this:
<?php echo $name['metalname'], " - ", $name['name'] ?>
lie2815 try this. im not sure what it does. and im trying to learn sql functions within punbb!
i was looking at my custom page menu seeing how it just pulls the name with a hyperlink.
Q
<?php
$result = $db->query('SELECT t.name, m.name AS metalname FROM '.$db->prefix.'metaltypes AS t INNER JOIN '.$db->prefix.'metals AS m ON m.id=t.metal_id WHERE t.id='.$id) or error('Unable to fetch metal type info', __FILE__, __LINE__, $db->error());
if ($db->num_rows($result))
{
?>
<div class="block">
<h2 class="block2">Custom Menu</h2>
<div class="box">
<div class="inbox">
<ul>
<?php
while($name = $db->fetch_assoc($result))
echo "\t\t\t\t\t".'<li>'."\n\t\t\t\t\t\t".$name['metalname']."-".$name['name'].'</li>'."\n\t\t\t\t\t"."\n";
?>
</ul>
</div>
</div>
</div>
<?php
}
?>I think the while loop is not needed since the query should only return one result.
k, i really dont know what im doing.. so i thought that I would try to help and learn at the same time.
Q
you actually did help...it works
GENIUS! 
Thanks a lot!
EDIT: except that you forgot two of these: }...but even I can figure that one out 
wow... i did it..hahaha... now im a sql master... lmao...
i looked at the code and thought that something close to my cp menu..
give me a link so i can see it in actions....
Q
if you dont mind repost the working code.
that something that i see a lot people get stuff working and never post the working code.
Q
Sorry. Here it comes:
$result = $db->query('SELECT t.name, m.name AS metalname FROM '.$db->prefix.'metaltypes AS t INNER JOIN '.$db->prefix.'metals AS m ON m.id=t.metal_id WHERE t.id='.$id) or error('Unable to fetch metal type info', __FILE__, __LINE__, $db->error());
if ($db->num_rows($result))
{
while($name = $db->fetch_assoc($result))
{
$outputstring = "\t\t\t\t\t".'<li>'."\n\t\t\t\t\t\t".$name['metalname']." - ".$name['name'].'</li>'."\n\t\t\t\t\t"."\n";
}
}
else
message($lang_common['Bad request']);
?>
<div class="block">
<h2><span><?php echo $outputstring ?></span></h2>
<div class="box">
<div class="inbox">kewl.. thanks i hope i can try to help again...lol..
Q
Another one:
$result = $db->query('SELECT full_name, desc, spec, color FROM '.$db->prefix.'alloys WHERE id='.$id) or error('Unable to fetch alloy information', __FILE__, __LINE__, $db->error());Error message:
Unable to fetch alloy information
Database reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, spec, color FROM inventory_alloys WHERE id=1' at line 1 (Errno: 1064)solved it. desc seems to be a special php word, so I obviously couldn't use it. I changed it to description and now everything works fine...
that good ! sorry i was not much of a help..
again im trying to learn it.
seem i can sorta debug it but not create it..haha
Q
i googled it and the only thing I found that it probably was mistakenly taken as the DESC for descending (MySQL)...
Indeed. You could've just put the name in backticks (`) though.
PunBB Forums → Programming → What am I doing wrong?
Powered by PunBB, supported by Informer Technologies, Inc.