[SOLVED] form does not show?

[darkfreaks]

ok so i have a compaint form and iti snot showing up any ideas ???

 

 

Code:

 

<?php
$strTitle = "Complaints/Reports";
define('QUADODO_IN_SYSTEM', true);
require_once('includes/header2.php');
$qls->Security->check_auth_page('complaints.php');

echo "<h2>Complaints/Reports</h2>
<form name=\"action\" id=\"action\" method=\"post\" action=\"commentsdelete.php\">
";

include ('config.php');
$query=trim(mysql_real_escape_string($query));
$query = "SELECT * FROM vc_comments WHERE username='admin' ORDER BY `id` DESC LIMIT 0,9";
$result = mysql_query($query);

$num=mysql_num_rows($result) or die(mysql_error());

mysql_close();

$i=0;
while ($i < $num) {

$id = mysql_result($result,$i,"id");
$from = mysql_result($result,$i,"fname");
$date = mysql_result($result,$i,"date");
$message = mysql_result($result,$i,"message");
{
echo "<table border=\"0\" width=\"100%\" cellpadding=\0\" cellspacing=\"0\" class=\"table\">
<tr>
<td width=\"20\"><input type=\"checkbox\" id=\"$id\" value=\"$id\" name=\"$id\"></td>
<td width=\"30%\" align=\"center\">
<a href=\"../profile/$from\">$from</a><br>$date<br>
<a href=\"commentsadd.php?u=$from\">[ Reply ]</a>
</td>
<td width=\"70%\">
$message
</td></tr></table>
<p>";
};

$i++;
}

echo "<input type=\"submit\" name=\"delete\" id=\"delete\" value=\"Delete Comments\">
</form>";

include ('includes/footer.php');
?>

 

 

 

[teng84]

<?php
$strTitle = "Complaints/Reports";
define('QUADODO_IN_SYSTEM', true);
require_once('includes/header2.php');
$qls->Security->check_auth_page('complaints.php');

echo "<h2>Complaints/Reports</h2>
<form name=\"action\" id=\"action\" method=\"post\" action=\"commentsdelete.php\">
";

include ('config.php');
$query=trim(mysql_real_escape_string($query));
$query = "SELECT * FROM vc_comments WHERE username='admin' ORDER BY `id` DESC LIMIT 0,9";
$result = mysql_query($query);

$num=mysql_num_rows($result) or die(mysql_error());

mysql_close();

$i=0;
while ($i < $num) {

$id = mysql_result($result,$i,"id");
$from = mysql_result($result,$i,"fname");
$date = mysql_result($result,$i,"date");
$message = mysql_result($result,$i,"message");
{///////<-----------------------------------------------------------------------------------what is that
echo "<table border=\"0\" width=\"100%\" cellpadding=\0\" cellspacing=\"0\" class=\"table\">
<tr>
<td width=\"20\"><input type=\"checkbox\" id=\"$id\" value=\"$id\" name=\"$id\"></td>
<td width=\"30%\" align=\"center\">
<a href=\"../profile/$from\">$from</a><br>$date<br>
<a href=\"commentsadd.php?u=$from\">[ Reply ]</a>
</td>
<td width=\"70%\">
$message
</td></tr></table>
<p>";
};//----------------------------------------------------------------what is this?

$i++;
}

echo "<input type=\"submit\" name=\"delete\" id=\"delete\" value=\"Delete Comments\">
</form>";

include ('includes/footer.php');
?>

see the comments

[phorcon3]

<?php

$strTitle = "Complaints/Reports";

define('QUADODO_IN_SYSTEM', true);

require_once 'includes/header2.php';

$qls->Security->check_auth_page('complaints.php');

echo '<h2>Complaints/Reports</h2><form name="action" id="action" method="post" action="/commentsdelete.php">';

include 'config.php';

$total_a = mysql_query("SELECT Count(*) AS Count FROM `vc_comments` WHERE `username` = 'admin'");
$total_b = mysql_result($total_a, 0, 0);

if(!empty($total_b))
{
$a = mysql_query("SELECT * FROM `vc_comments` WHERE `username` = 'admin' ORDER BY `id` DESC LIMIT 0,9");
while($b = mysql_fetch_assoc($a))
{
echo '<table border="0" width="100%" cellpadding="0" cellspacing="0" class="table">
<tr>
<td width="20"><input type="checkbox" id="'.$b['id'].'" value="'.$b['id'].'" name="id[]"></td>
<td width="30%" align="center">
<a href="../profile/'.$b['fname'].'">'.$b['fname'].'</a><br>'.$b['date'].'<br>
<a href="/commentsadd.php?u='.$b['fname'].'">[ Reply ]</a>
</td>
<td width="70%">'.$b['message'].'</td>
</tr>
</table>';
}
}

echo '<input type="submit" name="delete" id="delete" value="Delete Comments"></form>';

include 'includes/footer.php';
?>

 

thats how id do it..

[darkfreaks]

the form does not show butthedelete button does ???

[haku]

Are you sure $num isn't an empty value? If it is, none of the form fields would display.

[phorcon3]

just ..in case someone reads what i wrote lol ..

 

i got the

 

<?php
if(!empty($total_b))
?>

 

screwed up, it should be

 

<?php
if($total_b != 0)
?>

 

or

 

<?php
if(!$total_b)
?>

 

whatever is better ..dunno lol

[teng84]

<?php
$strTitle = "Complaints/Reports";
define('QUADODO_IN_SYSTEM', true);
require_once('includes/header2.php');
$qls->Security->check_auth_page('complaints.php');

echo "<h2>Complaints/Reports</h2>
<form name=\"action\" id=\"action\" method=\"post\" action=\"commentsdelete.php\">
";

include ('config.php');
$query=trim(mysql_real_escape_string($query));
$query = "SELECT * FROM vc_comments WHERE username='admin' ORDER BY `id` DESC LIMIT 0,9";
$result = mysql_query($query);

if(mysql_num_rows($result)>0){
echo "<table border=\"0\" width=\"100%\" cellpadding=\0\" cellspacing=\"0\" class=\"table\">
<tr>";

while($row = mysql_fetch_array($result)){
	$id =$row["id"];
	$from = $row["fname"];
	$date = $row["date"];
	$message = $row["message"];
	echo "<td width=\"20\"><input type=\"checkbox\" id=\"$id\" value=\"$id\" name=\"$id\"></td>
	<td width=\"30%\" align=\"center\">
	<a href=\"../profile/$from\">$from</a><br>$date<br>
	<a href=\"commentsadd.php?u=$from\">[ Reply ]</a>
	</td>
	<td width=\"70%\">
	$message
	</td></tr>";
                  echo "</table>";
}
}
echo "<p><input type=\"submit\" name=\"delete\" id=\"delete\" value=\"Delete Comments\"></form>";

include ('includes/footer.php');
?>

try

[kankaro]

when you code arrange it properly

[darkfreaks]

nope

[haku]

'Nope' what? Who are you saying that to? Whats it in reference to?

 

Did you check if $num is receiving anything from the database?

[darkfreaks]

its not empty no it queries  ???

[haku]

So what is it equal to when you output it?

[darkfreaks]

num is equal to 6

[phorcon3]

<?php
$strTitle = "Complaints/Reports";
define('QUADODO_IN_SYSTEM', true);
require_once('includes/header2.php');
$qls->Security->check_auth_page('complaints.php');

echo "<h2>Complaints/Reports</h2>
<form name=\"action\" id=\"action\" method=\"post\" action=\"commentsdelete.php\">
";

include ('config.php');
$query=trim(mysql_real_escape_string($query));
$query = "SELECT * FROM vc_comments WHERE username='admin' ORDER BY `id` DESC LIMIT 0,9";
$result = mysql_query($query);

$num=mysql_num_rows($result) or die(mysql_error());

mysql_close();

$i=0;
while ($i < $num) {

$id = mysql_result($result,$i,"id");
$from = mysql_result($result,$i,"fname");
$date = mysql_result($result,$i,"date");
$message = mysql_result($result,$i,"message");

echo "<table border=\"0\" width=\"100%\" cellpadding=\0\" cellspacing=\"0\" class=\"table\">
<tr>
<td width=\"20\"><input type=\"checkbox\" id=\"$id\" value=\"$id\" name=\"$id\"></td>
<td width=\"30%\" align=\"center\">
<a href=\"../profile/$from\">$from</a><br>$date<br>
<a href=\"commentsadd.php?u=$from\">[ Reply ]</a>
</td>
<td width=\"70%\">
$message
</td></tr></table>
<p>";

$i++;
}

echo "<input type=\"submit\" name=\"delete\" id=\"delete\" value=\"Delete Comments\">
</form>";

include ('includes/footer.php');
?>

 

that is NOT workin?

[darkfreaks]

nope

[phorcon3]

lol ok ..just checkin.. ^^

[haku]

I think your problem may be here:

 

echo '<h2>Complaints/Reports</h2><form name="action" id="action" method="post" action="/commentsdelete.php">';

 

you are missing backslashes before mosto f your quotes. It should read:

 

echo '<h2>Complaints/Reports</h2><form name=\"action\" id=\"action\" method=\"post\" action=\"/commentsdelete.php\">';

[Stooney]

Actually the double quotes don't need to be escaped if echo is using single quotes. 

 

This is fine

echo '<h2>Complaints/Reports</h2><form name="action" id="action" method="post" action="/commentsdelete.php">';

 

[haku]

Thats true. I don't use single quotes, so I wasn't thinking about that.

[darkfreaks]

wrong wrong and wrong it is still not working

[Stooney]

Tell us what's not working.  What's expected?  Give us some details.

 

wrong wrong and wrong it is still not working

 

What are we supposed to do with that?

[darkfreaks]

it didnt echo anything at ALL. regardless if i used single or double quotes

[hamza]

Dear ,

Some times mysql_num_rows getting error remove the mysql num and give some values to it

and try to show your button.

or

 

go to php.net for the further help

[haku]

I just realized there is an extra set of curly braces ({}) around the echo statement. I think it is being skipped as a result. Remove those curly braces and your script should (may?) work.

[darkfreaks]

those curly braces are needed because it is an else statement any oter ideas ??? ???