Why doesn't it generate the array error?

[Maria Sohas]

There is a query made to the table Books which tries to find a similar username id the column book. If the username doesn't exist the script just proceeds to the next step.

IF the username exists, it generates an error in the ERROR ARRAY and then redirects to my error page. Or at least it should!

Here lies the root of the problem. It just proceeds regardless if there is a username match or not. I'm not getting any errors of any sort besides this inability to work!

any idea what I'm missing?

<?php 
// start the session 
session_start(); 
header("Cache-control: private"); //IE 6 Fix 
include "scripts/dbconnect.php";
$result = mysql_query("SELECT book FROM books",$db);
while ($row = mysql_fetch_array($result)) { 

$_SESSION['form_errors'] = array(); 

if (($_POST['client_username']) == $row['book'] ) { 

    $_SESSION['form_errors']['client_username'] = '<br /><table width=220 height=24 border=0 cellpadding=0 cellspacing=0><tr><td><span class=text-error-validation >ERROR</span></td></tr></table>'; 
} else { 
    $_SESSION['form_errors']['client_username'] = null; 
} 
}


if (!empty($_SESSION['form_errors']['client_username'])) 
{ 
    header("Location: myerrorpage.php" ); 
} 
?>

[Mittineague]

Maybe if you tried this instead?

if ($_SESSION['form_errors']['client_username']) 

[clamcrusher]

move this out of the loop

$_SESSION['form_errors'] = array();

[Maria Sohas]

Neither of the solutions actually worked. Clamcrusher, do you mean this?

$result = mysql_query("SELECT name FROM clients",$db);
$_SESSION['form_errors'] = array(); 

while ($row = mysql_fetch_array($result)) { 

[clamcrusher]

i had a closer look at your code, you shouldnt be looping through your entire database result set to do this. although you could do it like that, its not efficient.

<?php
// start the session
session_start();
header("Cache-control: private"); //IE 6 Fix
include "scripts/dbconnect.php";

$_SESSION['form_errors'] = array();

$result = mysql_query("SELECT book FROM books WHERE book = '".$_POST['client_username']."'",$db);

if (mysql_num_rows($result) > 0) {
    // we found a match
    $_SESSION['form_errors']['client_username'] = '<br /><table width=220 height=24 border=0 cellpadding=0 cellspacing=0><tr><td><span class=text-error-validation >ERROR</span></td></tr></table>';
    header("Location: myerrorpage.php" );
    exit;
}


?>