[RESOLVED] Sorry but this is driving me crazy

[Vbabiy]

<?php 
mysql_connect('localhost','root','');
mysql_select_db('rsc');
$name = 'rsc';

$results = mysql_query("SELECT * FROM rsc") or die(mysql_error());

echo '<table  border="1">';
echo '<tr><td>Delete</td><td>Username</td><td>Password</td>
		<td>Frist Name</td><td>Last Name</td><td>Email</td></tr>
		<form action="printuser.php" method="post">';

while($rowarray = mysql_fetch_array($results)) {

echo '<tr>';
echo '<td>';
//Check Box for Delete
echo '<input name='.$rowarray[username].' type="checkbox" value="del">';
echo '</td>';
echo '<td>';
echo $rowarray['username'];
echo '</td>';
echo '<td>';
echo $rowarray['password'];
echo '</td>';
echo '<td>';
echo $rowarray['first_name'];
echo '</td>';
echo '<td>';
echo $rowarray['last_name'];
echo '</td>';
echo '<td>';
echo $rowarray['email'];
echo '</td>';
echo '</tr>';
}
echo '</table>';
echo '<input name="Submit" type="submit" value="submit">';
echo '</form>';


$row = mysql_num_rows($results);
$i = 0;

while ($i < $row) {
	echo $row['username'];
	$i++;
	echo $i;
	}

?>

Why is this not echoing any thing?

$row = mysql_num_rows($results);
$i = 0;

while ($i < $row) {
	echo $row['username'];
	$i++;
	echo $i;
	}

[devinemke]

in this line...

echo $row['username'];

...you are treating $row like an array. it isn't. it's an interger. read up on [man]mysql_num_rows[/man], it returns the number of rows from the supplied result resource (as an integer).

[Vbabiy]

$rowuser = mysql_fetch_array($results);
$row = mysql_num_rows($results);
$i = 0;

while ($i < $row) {
	echo $rowuser['username'];
	$i++;
	echo $i;
	}

[devinemke]

what exactly are are trying to do with this? if you just want to output all of the usernames then simply use the same method that you did in the top part of your orginal code snippet.

[Vbabiy]

Ok well this what i need to happen i want to display all the user name and passwor etc... to a table and then i want to be able to chose which to delete from the db. not sure if i have it started right but that is my goal. Thanks for your help. 🙂

[dnast]

The table part looks fine (except that <form> should come before <table>). The problem is that we don't understand what you're trying to do with the second loop. 😉

P.S. All of the rows in $result will have been fetched in the first loop. To fetch from $result again, you'll have to set the row pointer back to the first row (see [man]mysql_data_seek[/man]).

mysql_data_seek($result,0);

[leatherback]

while $rowuser = mysql_fetch_array($results)
{
echo $rowuser['username'];
}

[Vbabiy]

Ok let me try to explain this again...

Well what I need to do is this:
1. Print MYSQL to a Table. (Got this part)
2. Put a check box in the first column of each row, to be check if you want to delete user.
3. Then when click submit for it to remove that row from the DB.

What I am not user how to do I setup up the checkbox so it will delete the user when form is submitted.

I Hope this helps explain it a little more.
All help is appreciated

[devinemke]

the basic idea:

<?php
mysql_connect('localhost', 'root', '') or exit(mysql_error());
mysql_select_db('rsc') or exit(mysql_error());

if (!isset($_POST['submit']))
{
	$result = mysql_query('SELECT * FROM rsc') or exit(mysql_error());

echo '
<form action="" method="POST">
check users that you wish to delete:<br><br>
';

while ($row = mysql_fetch_assoc($result))
{
	echo '<input type="checkbox" name="delete[]" value="' . $row['username'] . '"> ' . $row['username'] . '<br>';
}

echo '
<br>
<input type="submit" name="submit" value="submit">
</form>
';
}
else 
{ 
    if (isset($_POST['delete'])) 
    { 
        foreach ($_POST['delete'] as $key => $value) {$delete[$key] = "'" . $value . "'";}
			$result = mysql_query('DELETE FROM rsc WHERE username IN(' . implode(',', $delete) . ')') or exit(mysql_error()); 
        echo 'usernames deleted'; 
    } 
    else 
    { 
        echo 'you did not check any users'; 
    } 
} 
?>

[Vbabiy]

Wow that made it much easier then i though 🙂
Thanks alot

[Vbabiy]

I took this line:

$result = mysql_query('DELETE FROM rsc WHERE username IN(' . implode(',', $_POST['delete']) . ')') or exit(mysql_error()); 
        echo 'usernames deleted'; 

and Replaced with this:

$result = mysql_query("DELETE FROM rsc WHERE username = '".(implode(',',$_POST['delete'])."'"));

Works Great Now thanks alot.