PHP - Php Only Lets Me Edit 1st Line From Query

Hey Guys.....I would really appreciate all if you guys could help me on this..
i am developing a work order aka business ticketing system where i have to search the tickets based on the given criteria of: ticket no
or department name or project name or the status of the ticket or severity of the ticket...
i have written the query as



$qry = "SELECT * FROM tickets WHERE ((ticket_id='$var1') OR ('$var1' IS NULL))
       and ((dept_id='$var2') OR ('$var2' IS NULL)) and ((proj_id='$var3') OR ('$var3' IS NULL))
       and ((status='$var4') oR ('$var4' IS NULL)) and ((severity='$var5') oR ('$var5' IS NULL))";



1. if i have a value for var1==15 inserted and the values of var2 to var5 are null, the whole query gives zero rows
2 If I have values for var1 till var4 but one null for the var5 still query result is zeros

I need to make the condition work only where value is not null otherwise condition should be avoided

Is there any way - please write the query for me - EDIT - I am working in PHP

I'm working with a Wordpress plugin that uses that google maps api to map multiple markers depending on search terms and proximity. You can set an option so that, regardless of the default proximity when the page loads, ALL markers will first appear. In order to help with performance, the authors decided to limit that option to 250 markers. I need to lift that limit to 5,000 (though I currently only have about 500, I don't want to deal with limits as my markers grow). Based on a comment made in one of the php files it appears the authors enforce the limit in the query itself so I'm pasting the code for the php file that performs the query. Please let me know if there is something else I should do, if this forum is the wrong place or if I should be posting on pastebin and linking rather than dumping the entire file between code tags. Thanks in advance!

<?php
if ( !class_exists( 'SM_XML_Search' ) ){
	class SM_XML_Search{
		// Register hook to perform the search
		function sm_xml_search() {
			add_action( 'template_redirect', array( &$this, 'init_search' ) );
		}

		// Inits the search process. Collects default options, search options, and queries DB
		function init_search() {
			if ( isset( $_GET['sm-xml-search'] ) ) {
				global $wpdb, $simple_map;
				remove_filter( 'the_title', 'at_title_check' );

				$defaults = array(
					'lat' => false,
					'lng' => false,
					'radius' => false,
					'namequery' => false,
					'query_type' => 'distance',
					'address' => false,
					'city' => false,
					'state' => false,
					'zip' => false,
					'onlyzip' => false,
					'country' => false,
					'limit' => false,
					'pid'	=> 0,
				);
				$input = array_filter( array_intersect_key( $_GET, $defaults ) ) + $defaults;

				$smtaxes = array();
				if ( $taxonomies = get_object_taxonomies( 'sm-location' ) ) {
					foreach ( $taxonomies as $key => $tax ) {
						$phpsafe = str_replace( '-', '_', $tax );
						$_GET += array( $phpsafe => '' );
						$smtaxes[$tax] = $_GET[$phpsafe];
					}
				}

				// Define my empty strings
				$distance_select = $distance_having = $distance_order = '';

				// We're going to do a hard limit to 500 for now.
				if ( !$input['limit'] || $input['limit'] > 500 )
					$limit = "LIMIT 500";
				else
					$limit = 'LIMIT ' . absint( $input['limit'] );

				$limit = apply_filters( 'sm-xml-search-limit', $limit );

				// Locations within specific distance or just get them all?
				$distance_select = $wpdb->prepare( "( 3959 * ACOS( COS( RADIANS(%s) ) * COS( RADIANS( lat_tbl.meta_value ) ) * COS( RADIANS( lng_tbl.meta_value ) - RADIANS(%s) ) + SIN( RADIANS(%s) ) * SIN( RADIANS( lat_tbl.meta_value ) ) ) ) AS distance", $input['lat'], $input['lng'], $input['lat'] ) . ', ';
				$distance_order = 'distance, ';

				if ( $input['radius'] ) {
					$input['radius'] = ( $input['radius'] < 1 ) ? 1 : $input['radius'];
					$distance_having = $wpdb->prepare( "HAVING distance < %d", $input['radius'] );
				}

				$i = 1;
				$taxonomy_join = '';
				foreach ( array_filter( $smtaxes ) as $taxonomy => $tax_value ) {
					$term_ids = explode( ',', $tax_value );
					if ( $term_ids[0] == 'OR' ) {
						unset( $term_ids[0] );
						if ( empty( $term_ids ) ) {
							continue;
						}
						$search_values = array( "IN (" . vsprintf( '%d' . str_repeat( ',%d', count( $term_ids ) - 1 ), $term_ids ) . ")" );
					} else {
						$search_values = array();
						foreach ( $term_ids as $term_id ) {
							$search_values[] = sprintf( '= %d', $term_id );
						}
					}
					foreach ( $search_values as $search_value ) {
						$taxonomy_join .= "
							INNER JOIN
								$wpdb->term_relationships AS term_rel_$i ON posts.ID = term_rel_$i.object_id
							INNER JOIN
								$wpdb->term_taxonomy AS tax_$i ON
									term_rel_$i.term_taxonomy_id = tax_$i.term_taxonomy_id
									AND tax_$i.taxonomy = '$taxonomy'
									AND tax_$i.term_id $search_value
						";
						$i++;
					}
				}

				$sql = "SELECT
						lat_tbl.meta_value AS lat,
						lng_tbl.meta_value AS lng,
						$distance_select
						posts.ID,
						posts.post_content,
						posts.post_title
					FROM
						$wpdb->posts AS posts
					INNER JOIN
						$wpdb->postmeta lat_tbl ON lat_tbl.post_id = posts.ID AND lat_tbl.meta_key = 'location_lat'
					INNER JOIN
						$wpdb->postmeta lng_tbl ON lng_tbl.post_id = posts.ID AND lng_tbl.meta_key = 'location_lng'
						$taxonomy_join
					WHERE
						posts.post_type = 'sm-location'
						AND posts.post_status = 'publish'
					GROUP BY
						posts.ID
						$distance_having
					ORDER BY " . apply_filters( 'sm-location-sort-order', $distance_order . ' posts.post_name ASC', $input ) . " " . $limit;

				$sql = apply_filters( 'sm-xml-search-locations-sql', $sql );

				// TODO: Consider using this to generate the marker node attributes in print_xml().
				$location_field_map = array(
					'location_address' => 'address',
					'location_address2' => 'address2',
					'location_city' => 'city',
					'location_state' => 'state',
					'location_zip' => 'zip',
					'location_country' => 'country',
					'location_phone' => 'phone',
					'location_fax' => 'fax',
					'location_email' => 'email',
					'location_url' => 'url',
					'location_special' => 'special',
				);

				$options = $simple_map->get_options();
				$show_permalink = !empty( $options['enable_permalinks'] );

				if ( $locations = $wpdb->get_results( $sql ) ) {
					// Start looping through all locations i found in the radius
					foreach ( $locations as $key => $value ) {
						// Add postmeta data to location
						$custom_fields = get_post_custom( $value->ID );
						foreach ( $location_field_map as $key => $field ) {
							if ( isset( $custom_fields[$key][0] ) ) {
								$value->$field = $custom_fields[$key][0];
							}
							else {
								$value->$field = '';
							}
						}

						$value->postid = $value->ID;
						$value->name = apply_filters( 'the_title', $value->post_title );

						$the_content = trim( $value->post_content );
						if ( !empty( $the_content ) ) {
							$the_content = apply_filters( 'the_content', $the_content );
						}
						$value->description = $the_content;

						$value->permalink = '';
						if ( $show_permalink ) {
							$value->permalink = get_permalink( $value->ID );
							$value->permalink = apply_filters( 'the_permalink', $value->permalink );
						}

						// List all terms for all taxonomies for this post
						$value->taxes = array();
						foreach ( $smtaxes as $taxonomy => $tax_value ) {
							$phpsafe_tax = str_replace( '-', '_', $taxonomy );
							$local_tax_names = '';

							// Get all taxes for this post
							if ( $local_taxes = wp_get_object_terms( $value->ID, $taxonomy, array( 'fields' => 'names' ) ) ) {
								$local_tax_names = implode( ', ', $local_taxes );
							}

							$value->taxes[$phpsafe_tax] = $local_tax_names;
						}
					}
				} else {
					// Print empty XML
					$locations = array();
				}

				$locations = apply_filters( 'sm-xml-search-locations', $locations );
				$this->print_json( $locations, $smtaxes );
			}
		}

		// Prints the JSON output
		function print_json( $dataset, $smtaxes ) {
			header( 'Status: 200 OK', false, 200 );
			header( 'Content-type: application/json' );
			do_action( 'sm-xml-search-headers' );

			do_action( 'sm-print-json', $dataset, $smtaxes );

			echo json_encode( $dataset );
			die();
		}
	}
}

I thought to relax a bit and while i saw something and an idea came to my mind, lets play noobs, it will be fun... we ask noob questions here lolzzz   so my question is    Hello, I have seen that there are always 3 users /* I know these are bots */ Google, Yahoo and Bing always online and we cannot see their profiles. They must be very professional hackers who have known how to hide their identities.. right?? 

I have two scripts. One uses a drop down list to populate a forum while the other makes you enter in a value and populates the forum below with all the data in that table where the input matches the requested number.

So lets get down to it shall we?

1st up we have a movies list.

<?php
include('CheckLogin.php');
include ('databaseconfig.php');

$query = mysql_query("select title from movies");

if (isset($_POST['submitSearch']))
{
$query2 = mysql_query("select * from movies where title = ". $_POST['list']);
}
?>

<!DOCTYPE HTML>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Home
    </title>
<script type="text/javascript" src="javaScript/jquery-min.js"></script>
<script type="text/javascript" src="javaScript/corners.js"></script>
<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    <link href="style.css" rel="stylesheet" type="text/css">

  </head>

  <body>
    <div id="wrapper">
      <header>
        <div id="header">
          <h1 id="logo">RAY AND CARLS
          </h1>
          <p class="description"><?php echo check();?><br/>
        </p>
        </div>
      </header>
      <nav>
        <ul id="nav">
          <li>
            <a href="index.php">Home
            </a>
          </li>
          <li>
            <a href="#">Customer Registration
            </a>
          </li>
          <li>
            <a href="#">View Movies
            </a>
          </li>
          <li>
            <a href="#">View Games
            </a>
          </li>
          <li>
            <a href="#">Rent
            </a>
          </li>
          <li>
            <a href="#">Login
            </a>
          </li>
                    <li>
            <a href="#">Admin
            </a>
          </li>
        </ul>
      </nav>
      <article>

        <section>


          <div class="cornerBox cBox3">
            <div class="cornerBox-content">
<div class="List">
            <form class="cmxform" id="commentForm" action="action" method="post">
             <p>
               <select name="list">
                  <?php while ($row = mysql_fetch_array($query)) {
echo "<option>$row[title]</option>\n";
} ?>
               </select>
             </p>
             <p><input name="submitSearch" type="button" value="submit"></p>
             </form>
             <p>&nbsp; </p>
             <form class="cmxform" id="commentForm" action="action" method="post">
             <h2>The Movie Selected
                </h2>
                  <p>
                  <?php while ($row2 = mysql_fetch_array($query2)){?>
                    <label for="cname">Movie ID:
                    </label>
                    <em>*
                    </em>
                    <input id="cname" name="movieid" size="4" class="required" minlength="2" value="<?php echo $row2[0];?>">
                  </p>
                  <p>
                    <label for="cemail">Rented <em> 0 for n, 1 for y</em>
                    </label>
                    <em>*
                    </em>
                    <input id="cemail" name="rented" size="2" class="required email" value="<?php echo $row2[1];?>">
                  </p>
                  <p>
                    <label for="curl">Title
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="title" size="30" class="url" value="<?php echo $row2[2];?>">
                  </p>
                  <p>
                    <label for="curl">Category
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="category" size="15" class="url" value="<?php echo $row2[3];?>">
                  </p>
                  <p>
                    <label for="curl">Director
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="director" size="15" class="url" value="<?php echo $row2[4];?>">
                  </p>
                  <p>
                    <label for="curl">Leading Actors
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="leadingactors" size="50" class="url" value="<?php echo $row2[5];?>">
                  </p>
                                    <p>
                    <label for="curl">Supporting Actors
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="supportingactors" size="50" class="url" value="<?php echo $row2[6];?>">
                  </p>
                                    <p>
                    <label for="curl">Run Time <em>in minutes</em>
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="runtime" size="4" class="url" value=""><?php echo $row2[7];?></input>
                  </p>
                                    <p>
                    <label for="curl">Rating
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="rating" size="6" class="url" value="<?php echo $row2[8];?>">
                  </p>
                                    <p>
                    <label for="curl">Release Date
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="releasedate" size="10" class="url" value="<?php echo $row2[9];?>">
                  <?php } ?>
              </form>
            </div>

            </div>
          </div>
        </section>
      </article>
      <footer>
        <div id="footer">


          <div class="footer1">
            <h2> About
            </h2>
            <p>
              Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, 
              feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi 
              vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra. Vestibulum erat wisi, 
              condimentum sed, commodo vitae, ornare sit amet, wisi.
            </p>

          </div>

          <div class="footer2">
            <h2>Other places
            </h2>
            <p>
              <ul>
                <li>
                  <a href="#">Link 1
                  </a>
                </li>
                <li>
                  <a href="#">Link 2
                  </a>
                </li>
                <li>
                  <a href="#">Link 3
                  </a>
                </li>
                <li>
                  <a href="#">Link 4
                  </a>
                </li>
              </ul>
            </p>
          </div>

          <div class="footer3">
            <h2> Other information
            </h2>
            <p>
              Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, 
              feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi 
              vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra. Vestibulum erat wisi, 
              condimentum sed, commodo vitae, ornare sit amet, wisi.
            </p>
          </div>

          <p class="credits">&copy; 
            <a href="http://bwshome.byethost5.com/blogs">Adam Balan - BLACKANDWHITE
            </a> 
            <span>&bull;
            </span> Powered by 
            <a href="http://bwshome.byethost5.com/blogs">BLACKANDWHITE
            </a> 
            <span>&bull;
            </span> 

          </div>

        </footer>
      </div>
    </body>
  </html>]

This script populates a list with movie names with the select statement of select * from movies;

What I want to do is select a movie from this list and have the page refresh with a forum full of the details based on the movie title, hence the select * from movies where title = title statement.

What it currently does is populates a drop down list with titles of movies in the data base but not the forum....

2nd up we have the customer details


The second script is similar but now we want to populate a forum based on user input of a customer id.

So lets say we have an ID of 10, we enter 10 hit enter and the forum bellow should populate with all the customer info based on that id allowing me to edit and update (I haven't got to the update part yet, still trying to populate a forum)

<?php 
session_start(); 
include('CheckLogin.php'); 
include('databaseconfig.php');

if (isset($_POST['searchSubmit']))
{ 
$query = mysql_query("select * from customer where customer_id =".$_POST['cust_id']);
}
?>

  <!DOCTYPE HTML>
  <html>
    <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <title>Home
      </title>


<script type="text/javascript" src="javaScript/jquery-min.js"></script>
<script type="text/javascript" src="javaScript/corners.js"></script>
<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>

</script>

    <link href="style.css" rel="stylesheet" type="text/css">
  </head>

  <body>
    <div id="wrapper">
      <header>
        <div id="header">
          <h1 id="logo">RAY AND CARLS
          </h1>
          <p class="description">
            <?php echo checkAdmin();?>
              <br/>
          </p>
        </div>
      </header>
      <nav>
        <ul id="nav">
          <li>
            <a href="index.php">Home
            </a>
          </li>
          <li>
            <a href="#">Customer Registration
            </a>
          </li>
          <li>
            <a href="#">View Movies
            </a>
          </li>
          <li>
            <a href="#">View Games
            </a>
          </li>
          <li>
            <a href="#">Rent
            </a>
          </li>
          <li>
            <a href="#">Login
            </a>
          </li>
          <li>
            <a href="#">Admin
            </a>
          </li>
        </ul>
      </nav>
      <article>

        <section>


          <div class="cornerBox cBox3">
            <div class="cornerBox-content">
              <p>All updates to the Data base can be done here. Keeping in mind specific relationships with
                The back end data bases.
              </p>

              <p>Some common tasks are below. This page allows you to add, edit and delete customers/movies and games.
              </p>
              <div class="cornerBox2 cBox3">
                <div class="cornerBox-content">
                  <h1>Menu
                  </h1>
                  <ul>
                    <h2>Customers
                    </h2>
                    <li>
                      <a href="#">edit
                      </a>
                    </li>
                    <li>
                      <a href="#">Add New
                      </a>
                    </li>
                    <h2>Movies
                    </h2>
                    <li>
                      <a href="#">edit
                      </a>
                    </li>
                    <li>
                      <a href="#">Add New
                      </a>
                    </li>
                    <h2>Games
                    </h2>
                    <li>
                      <a href="#">edit
                      </a>
                    </li>
                    <li>
                      <a href="#">Add New
                      </a>
                    </li>
                  </ul>
                </div>
              </div>
              <div class="Forum"> 
              <h2>Search</h2>

              <form class="cmxform" id="commentForm" method="post" action="">
                                <p>
                    <label for="cname">Customer ID:
                    </label>
                    <em>* id's must be > 0
                    </em>
                    <input id="cname" name="cust_id" size="25" class="required" minlength="2" />
                  </p>
                                    <p>
                    <input class="submit" type="submit" value="Submit" name="searchSubmit"/>
                  </p>
                  </form>
                <h2>Edit Customer
                </h2>
                              <?php 
  
  $resualt = mysql_query($query);
  
  while($row = mysql_fetch_array($resualt))
  {
  
  ?>
                <form class="cmxform" id="commentForm" method="post" action="">

                  <p>
                    <label for="cname">Customer ID:
                    </label>
                    <em>*
                    </em>
                    <input id="cname" name="cust_id" size="25" class="required" minlength="2" value="<?php $row[0]?>"/>
                  </p>
                  <p>
                    <label for="cemail">First Name
                    </label>
                    <em>*
                    </em>
                    <input id="cemail" name="fname" size="25" class="required email" value="<?php $row[1]?>"/>
                  </p>
                  <p>
                    <label for="curl">Last Name
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="lastname" size="25" class="url" value="<?php $row[2]?>"/>
                  </p>
                  <p>
                    <label for="curl">Address
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="address" size="25" class="url" value="<?php $row[3]?>"/>
                  </p>
                  <p>
                    <label for="curl">Postal Code
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="postalcode" size="7" class="url" value="<?php $row[4]?>"/>
                  </p>
                  <p>
                    <label for="curl">Phone Number
                    </label>
                    <em>*
                    </em>
                    <input id="curl" name="phonenumber" size="11" class="url" value="<?php $row[5]?>""/>
                  </p>

                  <p>
                    <input class="submit" type="submit" value="Submit" name="submit"/>
                  </p>
                </form>
                <?php } ?>

                <?php 
if (!mysql_query($query)) 
{ 
echo("<h1>Possible Errors
                </h1>");
                //Echo errors
                echo mysql_error();
                echo ("<p>");
                }
                else
                {
                 echo("<h2>Customer was added</h1>");
}

                  ?>
                </div>


              </div>
            </div>
          </section>
        </article>
        <footer>
          <div id="footer">


            <div class="footer1">
              <h2> About
              </h2>
                <p>
                  Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, 
                  feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi 
                  vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra. Vestibulum erat wisi, 
                  condimentum sed, commodo vitae, ornare sit amet, wisi.
                </p>

              </div>

              <div class="footer2">
                <h2>Other places
                </h2>
                <p>
                  <ul>
                    <li>
                      <a href="#">Link 1
                      </a>
                    </li>
                    <li>
                      <a href="#">Link 2
                      </a>
                    </li>
                    <li>
                      <a href="#">Link 3
                      </a>
                    </li>
                    <li>
                      <a href="#">Link 4
                      </a>
                    </li>
                  </ul>
                </p>
              </div>

              <div class="footer3">
                <h2> Other information
                </h2>
                <p>
                  Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, 
                  feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi 
                  vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra. Vestibulum erat wisi, 
                  condimentum sed, commodo vitae, ornare sit amet, wisi.
                </p>
              </div>

              <p class="credits">&copy; 
                <a href="http://bwshome.byethost5.com/blogs">Adam Balan - BLACKANDWHITE
                </a> 
                <span>&bull;

                </span> Powered by 
                <a href="http://bwshome.byethost5.com/blogs">BLACKANDWHITE
                </a> 
                <span>&bull;

                </span> 
              </div>

            </footer>
          </div>
        </body>
      </html>

Now when I enter 10 into the search I get an error of:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #5' at line 1"

I was told to make another thread for my question(s) and since these are in relation to each other (populating a forum and all) I thought it best to combine two into one.

what im trying to do is take a youtube embed code find the URL code for that video and remove all other parts of the code keeping only the URL of the video
after i get the URL by it self then replace the http://www.youtube.com/ part of the URL with http://i2.ytimg.com/vi/

to do this i know that i need something like this to get the URL of the video
http://www.youtube.com/((?:v|cp)/[A-Za-z0-9\-_=]+)
but how to only return just the URL is something idk how to do

then use str_replace http://www.youtube.com/(?:v|cp)/" with  http://i2.ytimg.com/vi/

so in the end im asking if anyone know how to remove all other codes i dont want  and only keep the URL


this may have to be done using "regex" im not sure as i dont know to much about regex and what it can do but does sound like it would help lol