Hola a todos tengo un problema al intentar insertar en la base de datos desde el backend me da este error al abrir la opción.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
Le he echo un $result=mysql_query($sql) or die( "Error en query: $sql, el error es: " . mysql_error() );
y lo que me da es "Error en query: , el error es: Query was empty"
la linea de código es esta:
Código PHP:
$getname=mysql_fetch_array(mysql_query("SELECT * FROM D3_boxes WHERE box_id =".$qid));
Bueno os dejo el code del archivo completo a ver si me podéis ayudar por favor.
Código PHP:
<?
session_start();
define ('IN_ADMIN', 1);
include_once ('../includes/global.php');
if ($session->value('adminarea')!='Active')
{
header_redirect('login.php');
}
else
{
include_once ('header.php');
$msg_changes_saved = '<p align="center" class="contentfont">' . AMSG_CHANGES_SAVED . '</p>';
if (isset($_POST['savesettsok']))
{
for ($i=0;$i<count($_POST['caption']);$i++) {
$updateQuestion[$i] = mysql_query("
UPDATE D3_boxes_sub SET
box_name='".$_POST['caption'][$i]."', box_url='".$_POST['box_url'][$i]."' , theorder=".$_POST['theorder'][$i]."
WHERE sub_id=".$_POST['id'][$i]."") or die(mysql_error());
}
if ($_POST['newcaption']!="") {
$insertNewQuestion = mysql_query("
INSERT INTO D3_boxes_sub
(box_name,box_url,box_id) VALUES
('".$_POST['newcaption']."','".$_POST['url']."','".$qid."')");
}
if (count($_POST['delete'])>0) {
for ($i=0;$i<count($_POST['delete']);$i++) {
$deleteQuestion[$i] = mysql_query("DELETE FROM D3_boxes_sub
WHERE sub_id='".$_POST['delete'][$i]."'");
}
}
$arrangeCurrencies=mysql_query("ALTER TABLE D3_boxes_sub ORDER BY sub_id");
}
$template->set('header_section', AMSG_FEES);
$template->set('subpage_title', AMSG_MAIN_SETTINGS);
$getname=mysql_fetch_array(mysql_query("SELECT * FROM D3_boxes WHERE box_id =".$qid));
$getad = $db->query("SELECT * FROM D3_boxes_sub WHERE box_id =".$qid."theorder");
while ($row=mysql_fetch_array($getad)) {
$background = ($counter++%2) ? 'c1' : 'c2';
$item_durations_page_content .="<input type=\"hidden\" name=\"id[]\" value=\"".$row["sub_id"]."\"><tr class=\"".$background."\">
<td><input style=\"width:99%\" name=\"caption[]\" type=\"text\" id=\"caption[]\" value=\"".$row['box_name']."\" size=\"50\" /></td>
<td align=\"center\">
<input style=\"width:99%\" name=\"box_url[]\" type=\"text\" id=\"box_url[]\" value=\"".$row['box_url']."\" size=\"50\" /></td>
<td align=\"center\"><input style=\"width:99%\" name=\"theorder[]\" type=\"text\" id=\"theorder[]\" value=\"".$row['theorder']."\" size=\"50\" /></td>
<td align=\"center\"><input type=\"checkbox\" name=\"delete[]\" id=\"delete[".$row['sub_id']."]\" value=\"".$row['sub_id']."\"></td>
</tr>";
}
$template->set('box_name', $getname["box_name"]);
$template->set('item_durations_page_content', $item_durations_page_content);
$template_output .= $template->process('D3_add_boxes.tpl.php');
include_once ('footer.php');
echo $template_output;
}
?>
Muchas gracias a todos.