PHP - Check If Extension = True

I have been trying to write code that deletes a book from a database if the user provides a BookName, and the corresponding DeletionCode. I then want to provide the user with feedback, telling the user whether they have deleted a book, that is they have provided a deletion code and a book name, or whether they have not deleted a book, because they have entered the wrong bookname or book ID. I thought this code would work, but it seems that the $result variable is always set as TRUE, no matter whether the code has deleted a row or not. What have i done wrong?

$result = mysql_query("DELETE FROM books WHERE BookName = '$_POST[BookName]' && DeletionCode = '$_POST[Deletioncode]'");


if(!$result){
   die('Invalid query: ' . mysql_error());
}
else
   echo "delete book";

I have a web server which contains a public site and a private site. I want to be able to test for public or private using the page title and return the appropriate header which contains a different banner, css etc.

Firstly - the syntax below seems to be incorrect because it doesnt work correctly.
More importantly how do I add all the values to an array and than iterate through it to check for a matching page title?

Code: [Select]
public function publicSite() {
if ($this->getTitle()== 'Home' || 'About Us'||'Registration' || 'Sitemap' || 'Contact Us' || 'Useful Links' || 'Feedback') {
return true;
}
return false;
}
Then later on I would have:
Code: [Select]
if ($this->publicSite()) {
require($ROOT.'interface/pages/publicheader.php');
}
else {
require($ROOT.'interface/pages/privateheader.php');
}

Thanks heaps!

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=326567.0

$looponce = 1;
foreach ($this->info as $k => $v) {
if ( (($k == 'subject') && ($v['required'])) && (!$this->settings['customSubject'])) {
for ($i = 0; $i <= 0; $i++) {
$output[] = $this->display_errors('error_system_subject');
}
}
if ( (($k == 'name') && (!$v['required'])) || ((!array_key_exists("name", $this->info)) && ($looponce == 1)) ) {
$output[] = $this->display_errors('error_system_name');
$looponce++;
}
}

That is my loop that i check things in. What i'm more interested in is the name if statement.

If currently checks for a name key in an array(below) and makes sure that it is set to required. If it's not set to required, print out a system error and die()'s.

I'm looking for ways to remove the need for program errors and just change them to what is needed to run.

What i know how to do is, get into the inner array, what i don't know is how to edit the data and put it back exactly as it was given to me. The inner array data can be put back in any order, but the outer array must be in exact order as it was given.


above code $this->info = $formdata;

$formdata = array(
'name' => array('name'=>"Full Name", 'required'=>false, 'type'=>'text'), # This needs to be required=>true, but i can't trust the user, which is why i have the error.
'telephone' => array('name'=>"Telephone", 'required'=>false, 'type'=>'phone'),
);


Any help is greatly appreciated, also am i doing the foreach loop in the code above in an efficient manner or is there another way?

Is there any reason why I would want to use this...

Code: [Select]
$_SESSION['loggedIn'] = TRUE;
versus this...

Code: [Select]
$_SESSION['loggedIn'] = 1;
(The first one is easier to read...)


Debbie