Re: Re: NULL and empty space

I've tried that and thanks. Bad news is I still can't get it to work. Its always the simple things that causes problems. Any other suggestions? On Aug 22, 2004, at 10:41 AM, Daniel Schierbeck wrote:

Craig Hoffman wrote:

I have an form where someone can choose to upload a photo. If the person does not upload a photo, an emtpy string is inserted in the DB. How can I have it insert 'NULL' in the DB instead of an empty string when they choose NOT to upload a photo but complete the form anyway? Any help is appreciated! Much Thanks -- CH Here is my code and query if it helps: if($_POST["postback_upload"])

    {
        include "include/db.php";
    //image uploader
    $uploadpath = 'images/climbs/';
        $source = $_FILES['photo']['tmp_name'];
    $route_photo = $_FILES['photo']['name'];
    $dest == '';
    if (($source != 'none') && ($source != '')) {
        $dest = $uploadpath.$route_photo;
        if ($dest != '') {
            if (move_uploaded_file($source, $dest)) {
                echo ("<h2>Image and Climbing log has been successfully stored.</h2> ");
            } else {
                echo ("<h2>Image could not be stored.<h2>");
            }
        }
    } else {
            echo ("<h2>No new image supplied. Climbing long has been successfully stored.<h2>");
            }
        //photo uploader - make "route_photo" a varible for MySQL to work -- need to find out why.
                              $query = "INSERT INTO routes(user_id , date_climbed , route , pitchs , rating, area, outcrop, type, style, private_comments, public_comments, stars, route_photo)
        VALUES('NULL', '$_POST[date_climbed]', '$_POST[route]', '$_POST[pitchs]', '$_POST[rating]',
        '$_POST[area]', '$_POST[outcrop]', '$_POST[type]', '$_POST[style]',         '$_POST[private_comments]','$_POST[public_comments]','$_POST[stars]', '$route_photo')";
        echo $query;
        $msg = "<span style='color:red'>Could not insert record</span>";
        $result = mysql_query($query,$db) or die(mysql_error());

Why not just check if it's an empty string, and replace it with NULL if so? if ($route_photo = '') { $route_photo = NULL; } I'm not completely sure though. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php