PHP - Very Very Simple Problem

SOLVED, sorry.

... but i can't work it out.

all i want to do is;

if ( $this_item exists within the table )
{
do a
}
else
{
do b
}

for example, $this_item = 'john', and i want the script to do (a) if he's in the table, or (b) if he isn't.

thank you!

It shouldn't be that difficult I just don't know how to do it myself. I'm using the following code for a simple navigation, i has been placed in the content of my home page, it works fine however i don't know how to set the home page.

<div id="content">
<?php
$page = $_GET['page'];
$file = $page.".php";
if(file_exists($file)) {
include($file);
} else {
include "error.php";
}
?>
</div>

so I have an xml string
the following expression $xpath = $response->xpath('/atom:feed/atom:entry/atom:content');
returns the following array

SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [type] => application/vnd.google-earth.kml+xml
        )
    [Placemark] => SimpleXMLElement Object
        (
            [name] => M1
            [description] => SimpleXMLElement Object
                (
                )
            [Style] => SimpleXMLElement Object
                (
                    [IconStyle] => SimpleXMLElement Object
                        (
                            [Icon] => SimpleXMLElement Object
                                (
                                    [href] => http://maps.gstatic.com/intl/en_ALL/mapfiles/ms/micons/blue-dot.png
                                )
                        )
                )
            [Point] => SimpleXMLElement Object
                (
                    [coordinates] => -79.395018,43.645423,0.0
                )
        )
)


However what I'm trying to get are the coordinates, but neither
$xpath = $response->xpath('/atom:feed/atom:entry/atom:content/Placemark'); OR
$xpath = $response->xpath('/atom:feed/atom:entry/atom:content/Placemark/child::*');
work

I even tried just loading atom:content into an array and going from there no luck.
Any ideas.

Oh. BTW this might help http://code.google.com/apis/maps/documentation/mapsdata/developers_guide_protocol.html#RetrievingFeatures

Sorry this page is not available or has been accessed in error

An error occurred in script 'C:\xampp\htdocs\public_html\login\plugins\delete_product.php' on line 45: Undefined variable: id
Date/Time: 8-24-2010 00:50:10

Array
(
    [GLOBALS] => Array
 *RECURSION*
    [_POST] => Array
        (
        )

    [_GET] => Array
        (
            [id] => 2
        )


      <?php # Script 9.2 - delete_product.php

// This page is for deleting a album.

require_once ('../includes/config.inc.php');

// Check for a valid product ID, through GET or POST:
if ( (isset($id)) && (is_numeric($id)) ) { // From editproducts.php
$id = $_GET['id'];
} elseif ( (isset($_POST['id'])) && (is_numeric($_POST['id'])) ) { // Form submission.
$id = $_POST['id'];
} else { 
echo '<p class="error">Sorry this page is not available or has been accessed in error</p>';
}
echo $id;
require_once(MYSQL); 

// Check if the form has been submitted:
if (isset($_POST['submitted'])) {

if ($_POST['sure'] == 'Yes') { // Delete the record.

// Make the query:
$q = "DELETE FROM products WHERE product_id='$id' LIMIT 1";
$r = @mysqli_query ($dbc, $q);
if (mysqli_affected_rows($dbc) == 1) { // If it ran OK.

// Print a message:
echo '<p>The Product has been deleted.</p>';

} else { // If the query did not run OK.
echo '<p class="error">The Product could not be deleted due to a system error.</p>'; // Public message.
echo '<p>' . mysqli_error($dbc) . '<br />Query: ' . $q . '</p>'; // Debugging message.
}

 // Make the query:
$q = "DELETE FROM photos WHERE product_id='$id'";
$r = @mysqli_query ($dbc, $q); 

} else { // No confirmation of deletion.
echo '<p>The Product has NOT been deleted.</p>';
}

} else { // Show the form.

// Retrieve the albums information:
$q = "SELECT name FROM products WHERE product_id='$id' Limit 1";
$r = @mysqli_query ($dbc, $q);

if (mysqli_num_rows($r) == 1) { // Valid user ID, show the form.

// Get the user's information:
$row = mysqli_fetch_array ($r, MYSQLI_NUM);

$form = $_SERVER['PHP_SELF']; 

// Create the form:
echo '<form action="' . $form . '" method="post">
<h1>Delete ' . $row[0] . '?</h1>
<p>Are you sure you want to delete ' . $row[0] . '?<br />
<p><b>Warning if you delete this album all content inside of it will be losed!</b><br />
<input type="radio" name="sure" value="Yes" /> Yes 
<input type="radio" name="sure" value="No" checked="checked" /> No</p>
<p><input type="submit" name="submit" value="Submit" /></p>
<input type="hidden" name="submitted" value="TRUE" />
<input type="hidden" name="id" value="' . $id . '" />
</form>';

}
}


mysqli_close($dbc);

?>

Im simply having a problem with structuring a directory structure for mkdir

Code: [Select]
mkdir("saves/".$worldname."/".$playername, 0777);

The middle "/" is causing issues, if I take it out I have no problem in creating a folder name saves/worldnameplayername/ just want to add playername as a sub-dir.

I have tried every combination I can think of to get it to accept the divider 

Any help?