RE: [PHP-DB] SELECT statement problem

Assign the SELECT statement to a variable and then echo the variable. Does it contain values you expect? If the database is MySQL it can be very silent about errors in the SELECT and simply returns no results. Cheers - Miles At 02:58 PM 8/15/2002 -0400, Evan S. Weiner wrote:

It only outputs the first tech. It worked fine until I tried to add the end date ino it. Thanks for all teh help! // Get technician info $TECH_SQL = "SELECT * FROM employees"; $TECH = MYSQL_QUERY( $TECH_SQL, $CONNECTION) OR DIE ( mysql_error() ); while ( $row = mysql_fetch_array( $TECH ) ) {

        $tech_id = $row["id"];
        $tech_name_last = $row["name_last"];
        $tech_name_first = $row["name_first"];

        $tech_initials_first = substr( $tech_name_first, 0, 1 );
        $tech_initials_last = substr( $tech_name_last, 0, 1);
        $tech_initials = "$tech_initials_first$tech_initials_last";

        $tech_name = "$tech_name_first $tech_name_last";

        echo "                  <table width=\"100%\">\n";
        echo "                  <p align=\"center\" class=\"big\">$tech_name</p>\n";

        // Reset counters for this tech
        $tech_hour = 0;
        $tech_cost = 0;

        // Start pulling ticket work
        $TICKET_WORK_SQL = "SELECT * FROM tickets_work
                WHERE employee_id = '$tech_id'
                AND start > '$start'
                AND end < '$end'
                ORDER BY start";
        $TICKET_WORK_INFO = MYSQL_QUERY( $TICKET_WORK_SQL, $CONNECTION ) OR DIE ( mysql_error() );

        while ( $row = mysql_fetch_array( $TICKET_WORK_INFO ) )
        {
                $ticket_id = $row["ticket_id"];
                $start = $row["start"];
                $end = $row["end"];
                $total_hours = $row["total_hours"];
                $total_billable = $row["total_billable"];

-----Original Message----- From: Miles Thompson [mailto:milesthompson@ns.sympatico.ca] Sent: Thursday, August 15, 2002 2:26 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] SELECT statement problem SELECT * FROM tickets_work WHERE employee_id = '$tech_id' AND

         start > '$start' AND
         end < '$end'

ORDER BY start Which will select everything from tickets_work for a given employee between start and end. What is not working? Miles Thompson At 02:15 PM 8/15/2002 -0400, Evan S. Weiner wrote: Hello all, I have this SQL statement I am trying to use and no matter what combination I use, I cannot get it to work. The start and end if clauses need to be grouped together. SELECT * FROM tickets_work WHERE employee_id = '$tech_id' && ( start > '$start' && end < '$end' ) ORDER BY start Anyone able to help me? Thanks! Evan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php