PHP - Simple Query Problem Involving Boolean Logic.

I am using this sql to filter records :

$query = "select * from mobileprices where range='5000'"()
 but i am getting this error message :
mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/dracra/public_html/a.com/range.php

range field contains product prices range and filled with 5000, 10000, 15000, 20000 etc.
I tried the following code to update the range values from numeric to text in phpmyadmin sql area :

Code: [Select]
UPDATE mobileprices
SET range='five'
WHERE range='5000'
but i am getting this error message :

#1064 - 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 'range='five' WHERE range='5000'' at line 2

I am confused as there are thousands of records and manually updating it one by one will take so much time.
Anyone could help me out as how i can change numeric with text in range.

or there is any way by that sql could accept this :

$query = "select * from mobileprices where range='5000'"()

I need a solution, so please help me !!

So the code works right, (I think)  but for some reason the way I built it the logic comes back null.

I can do All w a specific shift/s, and All with department/s but I can't do All shifts and All departments
it doesn't' error either, just brings back nothing, maybe timing out?


I'm very new at this so I apologize in advance.



Code below
############################################################
<form method="post" action="">
<br><br>
<table bordercolor="yellow" border="2">
 
<tr><td class="line"><b>Start Date:</b></td><td>
<input type="text" name="startdate" value="mm/dd/yyyy" /></td></tr>
</tr>
<tr><td class="line"><b>End Date:</b></td><td>
<input type="text" name="enddate" value="mm/dd/yyyy"  /></td></tr>
</tr>

<tr><td class="line"><b>Shift:</b></td><td>
         <SELECT NAME="shift" >
      <option selected>Select Shift</option>
     <option>First</option>
     <option>Second</option>
     <option>Third</option>
     <option>All</option>
      </SELECT> </td></tr>
     
<tr><td class="line"><b>Department:</b></td><td>
         <SELECT NAME="department" >
      <option selected>Select Department</option>
     <option>Advanced Hosting Support</option>
     <option>Server Support</option>
     <option>Managed Support</option>
     <option>All</option>
      </SELECT> </td></tr>
</tr>   
</tr>
</table>

<br><br>
<input type="submit" value="submit" />
</form>
<form action="" method="post">

</form>

</html>


<?php
require_once('global.inc.php');

   
class DataLogic
{
//function to obtain Employee names from RealID array to pass to MSSQL for call count

function GetEmpNames ($RealID)
{
   global $ems_db_connect;
   
   
foreach ($RealID as $emplist){

$query1 = mysql_query ("SELECT FirstName, LastName
                     FROM ems_employee_list
                  WHERE RealID=$emplist", $ems_db_connect) or die(mysql_error());;

while($row = mysql_fetch_array($query1))
                  {
                     $FirstName[] = $row['FirstName'];
                     $LastName[] = $row['LastName'];
                  }
                  
}
$friendlyname = array('first_name' => $FirstName, 'last_name' =>$LastName);
return $friendlyname;            
}
                  
//function to display Employee names from RealID array obtained from department and shift

function DisplayEmpNames ($RealID)
{
   global $ems_db_connect;
   
   
foreach ($RealID as $emplist){

$query1 = mysql_query ("SELECT FirstName, LastName
                     FROM ems_employee_list
                  WHERE RealID=$emplist", $ems_db_connect) or die(mysql_error());;

while($row = mysql_fetch_array($query1))
                  {
                     $FirstName = $row['FirstName'];
                     $LastName = $row['LastName'];
                     $fullname[] = "$LastName, $FirstName";
                  }
                  
}
return $fullname;
}

//function to pull the RealID's of Employees based on shift
//Returns a list of RealID's for use with GetIris and RepSort functions
function SelectEmpShift ($key)
{
global $ems_db_connect;


switch($key)
      {
         case "First":
            $shift = 1;
            break;
            
         case "Second":
            $shift = 2;
            break;
         
         case "Third":
            $shift = 3;
            break;
            
         default:
            $shift = 4;
         
      }   
if ($shift == 4){

   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND Department='AHS'", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
            }

else {
      $query1 = mysql_query ("SELECT RealID
                           FROM ems_employee_list
                           LEFT JOIN ems_employee_schedules
                           USING (EmployeeID)
                           WHERE RealID > 0 AND Shift = $shift AND Department ='AHS'", $ems_db_connect);
                  
                  

      while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
   }

return $x;
}

//Function to Select Employees based on Department
function SelectEmpDep ($key)
{
global $ems_db_connect;


switch($key)
      {
         case "Managed Support":
            $deptcode = 6;
            break;
            
         case "Server Support":
            $deptcode = 5;
            break;
         
         case "Advanced Hosting Support":
            $deptcode = 2;
            break;
            
         default:
            $deptcode = 7;
         
      }   
if ($deptcode == 7){
   
   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND Department='AHS'", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
               }

elseif ($deptcode == 5){


   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND AccessID=5 OR AccessID=3 AND Department='AHS' AND RealID >0", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
                  }

else {

      $query1 = mysql_query ("SELECT RealID
                           FROM ems_employee_list
                           LEFT JOIN ems_employee_schedules
                           USING (EmployeeID)
                           WHERE RealID > 0 AND AccessID=$deptcode AND Department ='AHS' ", $ems_db_connect);
                  
                  
      
      while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }

   }

return $x;
}


//function to sort Shift by multiple Deparments
function RepSortShiftDept ($RealIDShift, $RealIDDepartment='', $RealIDDepartment2='')

{
   $deptnumber = func_num_args();
   
      if ($deptnumber == 1)
         {
         
            $result = $RealIDShift;
         }
   
      elseif ($deptnumber == 2)
         {

            $result = array_intersect($RealIDShift, $RealIDDepartment);
         }
   
      else {
            $result = array_intersect($RealIDShift, array_merge($RealIDDepartment, $RealIDDepartment2));
         }

   return $result;
}

//function to sort Department by multiple Shifts
function RepSortDeptShift ($RealIDDepartment, $RealIDShift='', $RealIDShift2='')

{
      $shiftnumber = func_num_args();
   
      if ($shiftnumber == 1)
         {
         
            $result = $RealIDDepartment;
         }
   
      elseif ($shiftnumber == 2)
         {

            $result = array_intersect($RealIDDepartment, $RealIDShift);
         }
   
      else {
            $result = array_intersect($RealIDDepartment, array_merge($RealIDShift, $RealIDShift2));
         }

   return $result;

}


//Function to get and display count of Iris tickets from a date rage.
//$RealID needs to be an array of EmployeeIDs obtained from SelectEmpShift, SelectEmpDepart, and RepSort functions
function GetIris($RealID, $startdate, $enddate)
{
global $hocstat_db_connect;

foreach ($RealID as $emplist){

$mssqlquery = "SELECT COUNT (IncidentID) AS mycount
            FROM hocstats.dbo.DailyStatsEmployee
            WHERE hocstats.dbo.DailyStatsEmployee.EmployeeID=$emplist      
            AND(hocstats.dbo.DailyStatsEmployee.DateModified
            BETWEEN '$startdate 00:00:00.000' AND '$enddate 23:59:59.000')";
                                       
                  $query_3 = mssql_query ($mssqlquery,                              $hocstat_db_connect);                   
                     $row =(mssql_fetch_array($query_3)) ;
                     $iriscount[] = $row['mycount'];
}
return $iriscount;
}


//Function to get and display call counts from a date range. For use with GetEmpName ONLY
function GetCalls ($friendlyname, $startdate, $enddate)
{
global $hocstat_db_connect;

for ($x = 0; $x < count ($friendlyname['last_name']); $x++)
   {

$query1 ="SELECT ISNULL(SUM(CallsHandledToHalf), 0) AS calls
                  FROM Agent_Skill_Group_Half_Hour ASGHH WITH (NOLOCK)
                  INNER JOIN dbo.agent ON ASGHH.skilltargetid = dbo.agent.skilltargetid
      WHERE(dbo.agent.enterprisename = 'HOC_{$friendlyname['last_name'][$x]}_{$friendlyname['first_name'][$x]}'
      OR dbo.agent.enterprisename = '{$friendlyname['last_name'][$x]}_{$friendlyname['first_name'][$x]}')
                  AND (ASGHH.datetime BETWEEN '$startdate 00:00:00' AND '$enddate 23:59:00')";
                  
                  $mssqlquery = mssql_query ($query1, $hocstat_db_connect);
                  
while ($row =(mssql_fetch_array($mssqlquery)))
                     {                                                                                                                                                                                                                                                                                                                  
   $callcount[] = $row['calls'];   
}               
   
   }
return $callcount;   
}

}//class close


if($_POST)
//setting varibles from form input
{   
   
   $shift_id= isset($_POST['shift']) ? trim($_POST['shift']) : die('Missing entry: Shift Selection');
   $start_date= isset($_POST['startdate']) ? trim($_POST['startdate']) : die('Missing enty: Start Date');
   $end_date= isset($_POST['enddate']) ? trim($_POST['enddate']) : die('Missing enty: End Date');
   $depart_id= isset($_POST['department']) ? trim($_POST['department']) : die('Missing entry: Shift Selection');
   
}


echo "You have selected stats for $shift_id shift(s) and $depart_id department(s) from $start_date to $end_date. </br>" ;

$test=new DataLogic();

$calls = $test->GetCalls($test->GetEmpNames($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id"))), $start_date, $end_date);


$iris= $test->GetIris ($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id")), $start_date, $end_date);

$name= $test-> DisplayEmpNames($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id")));

$table = array ( 'calls' => $calls, 'iris' => $iris, 'name' => $name);

for ($x = 0; $x < count ($table['calls']); $x++)
   {    
      echo $table["name"][$x];
      echo "</br> Calls Taken :";
      echo $table["calls"][$x];
      echo "</br> Iris Tickets Resolved:";
      echo $table["iris"][$x];
      echo "</br>";
   
   }

?>

This topic has been moved to MySQL Help.

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

i have a cell in my database like

Code: [Select]

Stats

100-10-3


and i want to update that with my code

Code: [Select]

   $details = 100 . '-' . 10 . '-' . 3;
   $sql = "UPDATE usertable SET uSkillsMax=$details";


but my database updates instead of 100-10-3 it says 87? which is doing the math?

any way to fix this?

SELECT * FROM Sold WHERE substr(sold_date, 0, 4) = 2010 



What I am trying to do is select all rows from the database from 2010, from the "sold_date" field.
How is this accomplished with date values? (ex: "2010-08-11", "2009-01-15")

problem showing date posted from a form into MYSQL using the php code. Date shows as 0000-00-00 and not the value submitted from the form. Thank you for any help

Code: [Select]

$sql="INSERT INTO Results (RunnerID, EventID, Date, FinishTime, Position, CategoryID, AgeGrade, PB)
 VALUES
 ('$_POST[RunnerID]','$_POST[EventID]','$_POST[Date]','$_POST[FinishTime]','$_POST[Position]','$_POST[CategoryID]','$_POST[AgeGrade]','$_POST[PB]')";
 
if (!mysql_query($sql,$connection))
   {
   die('Error: ' . mysql_error());
   }
 echo "<h1> Success! Saving data: </h1>";
 
mysql_close($connection);
 ?>

<html>
<head>
<title>Submitted</title>
</head>
 <body>
 <br />
 <?php echo "RunnerID=" . $_POST["RunnerID"]; ?><br />
 <?php echo "EventID=" . $_POST["EventID"]; ?><br />
 <?php echo "Date=" . $_POST["Date"]; ?><br />
 <?php echo "FinishTime=" . $_POST["FinishTime"]; ?><br />
 <?php echo "Position=" . $_POST["Position"]; ?><br />
 <?php echo "CategoryID=" . $_POST["CategoryID"]; ?><br />
 <?php echo "AgeGrade=" . $_POST["AgeGrade"]; ?><br />
 <?php echo "Personal best=" . $_POST["PB"]; ?><br />
 
 
</body>
 </html>

The following mysql query is not returning rows like I expect it to. '$update_field' is a variable,  matching an actual field name in table 'users'. 'user_task[1]' is an integer value. What am I missing here?
Code: [Select]
$query_update_user = "UPDATE users SET ".$update_field." = 'Y' WHERE user_no = '".$user_task[1]."'";

I have a database called "postvoting", It's basically to store when somebody votes on a particular posts. I store the post_id that the user votes on, the users id that voted on it, and the date.
What I want to do is find the most popular posts in a given time.

So if 4 people voted on the post with the id of 1, and 2 people voted on the post with the id of 2, I want to count the number of rows with post_id='1'

A non working example what I want would look something like:
$count_votes = mysql_query("SELECT * FROM postvoting WHILE post_id=post_id");
print mysql_num_rows($count_votes);
result: 4

or
$count_votes = mysql_query("SELECT * FROM postvoting GROUP BY post_id");
print mysql_num_rows($count_votes);
result: 4

(counting the number of results in a group)

Hope this isn't too confusing. (I've confused myself with this).

Code: [Select]
$ids = implode (",", $ibforums->input['checkbox']);
$time = time();
$ids2 = implode (",", $ibforums->input['pendingusers']);


$DB->query("UPDATE friends_pending SET pending='0',date=$time WHERE id IN ($ids) AND toid IN ($ids2)");
weird thing is, it's not bring up any error's or nothing

$ids2 spits out
2,30

and $ids spits out

9,7

for this particular project

doesn't give me mysql error or nothing, script runs fine.  I have mysql error enabling under $dbquery class so nn to  worry, how to get this to work? 

Can i even use 2 IN's in 1 query or???

I've got to be missing something pretty basic here.. considering the query is pretty basic.

I'm trying to figure out how to pull a query as an array so I can compare it against another array (array_diff)

I'm doing a mysql_fetch_array, and I'm getting an error ( mysql_fetch_array(): supplied argument is not a valid MySQL result resource):
Quote

$checker = "SELECT ID FROM edible_uses";

$result2 = mysql_fetch_array($checker) or die(mysql_error());
//echoing to see if I'm getting what I need.
echo $row['ID'];


I've done a mysql_query and I get results. The table name and all that is correct. I'm stumped. This seems like a pretty simple query? I tried mysql_fetch_assoc as well. Same result? I tried it with an extra set of parenthesis around it. nope.

This topic has been moved to MySQL Help.

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

The following query or while loop is only increasing the ArticleID variable every 3rd time the script is run, I've narrowed it down to the following code snippet. Can you spot a problem with this, I'm in my first week of PHP and MySQL and I can't see any problem with it.

Any help would be mighty appreciated by this idiot 

Code snippet:
---
$result = mysql_query("SELECT ArticleID FROM test_top ORDER BY ArticleID ASC LIMIT 1") or die(mysql_error()); 
   while($row = mysql_fetch_array($result))
   {
   $ArticleID=$row['ArticleID'];
   }
$ArticleID=intval($ArticleID);
$ArticleID++;
---

Im sure this is simple, but I cannot see what my problem is!

I am hitting an error on my insert query

Code: [Select]
Error: 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 '1' at line 1
I know the output of $user_id is 1, so my error is on $mysavepath

Code: [Select]
$mysavepath = $folder.'/'.$worldname.'_'.date("dMjY");
echo $mysavepath;
$savepath = mysql_query("INSERT INTO saves (user_id,savepath) VALUES ('$user_id','$mysavepath')");
echo '<br>'.$savepath;
if(!mysql_query($savepath))
{
die('<br>Error: ' . mysql_error());
}

however it all echos out ok?

Code: [Select]
188ea678f0dcdc8252aeb15e3c910408/world_15Jan152012
1
Error: 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 '1' at line 1

Can anyone see the problem?

Cheers
Dave

OK, here it is.  I have been trying to do this myself, but it has been driving me insane and I turn to professionals here for help.   I am a basic web developer for a company that I work for in other capacities. I have a reasonable understanding of HTML and that is about where my expertise ends. I am not typically a programmer, just a simple (extremely) part time designer that uses Muse and Dreamweaver when necessary.   However, recently my company has asked me to accomplish a task for their website. In plain English, they want a large database that exists currently as a CVS file made into a searchable web page.  It is 21 columns by approximately 6,700 rows.   To explain what I need a little more technically, here are my ideas and where I have gotten to so far:   1. The company uses godaddy, into which I *believe* I have successfully imported the spreadsheet. I believe it is successful because through godaddy's SQL Control Panel (phpMyAdmin console), I can do the EXACT searches that the company needs, and it spits out the EXACT results that I need.   2. The end result needs to be a .php that I can upload to the website's root folder that can be then inserted into premade pages using:

<iframe src="SMQ.php" scrolling="yes" width="950" height="800"></iframe>

3. On the .php page, I need to have a way to log in to the SQL server and a simple search box built in that will allow the user to input a very simple search string consisting of no more than 4 numbers and 3 letters at a time. No buttons, no check boxes, just a search box.   3. This query then needs to be output as a nice data table, similar to this: This in fact is a screenshot of a search I performed out of my SQL database, in phpMyAdmin using the column "Scott" for the search, and the number 226 as the search term. All column names are visible with the exception of the first column, entitled LINEID, made to be the key, and the output should not include the key but have everything else as above.   4. I can see what the simple line of php is that performed this task:

SELECT * FROM `SMQSQL` WHERE `Scott` = '226' ORDER BY `LINEID` ASC 

but I can't figure out how the hell to get this incorporated to a .php search.   To sum it up, I need a .php page written that can connect to a SQL database, perform a data based search, and spit out a clean table when it is done.   I had accomplished this in the past using an import into google docs and using it to perform a search and result display via the following code built into a php called SMQ.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Example of Google Spreadsheet Data Visualisation</title>
</head>

<body>

<form id="form1" method="post" action ="<?php echo $_SERVER['PHP_SELF']; ?>"> <label>
<input id="search" name="search" type="text" />
</label>
<label>
<input id="Scott #" name="Scott #" type="submit" value="Scott #" />
</label>

<img src="loading.gif" width="16" height="11" />
</form>
<p>
<?php
$search= $_REQUEST['search'];
if ($search > ''){ $search = $search;} else { $search = '';}
?>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['table']});
</script>
<script type="text/javascript">
var visualization;
function drawVisualization() {

var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=0AronCwm9QPefdGpIUllscGgtLUJod2pOazc0bjU0cUE&usp=sharing');

query.setQuery('SELECT A, B, C, D, E, F, G, H, I, J, K, L, M, N, O ,P ,Q ,R ,S ,T WHERE (A) LIKE ("<?php echo $search; ?>") order by A asc label A "Scott #", B "Den", C "Color", D "Cond", E "40", F "60", G "70", H "70J", I "75", J "75J", K "80", L "80J", M "85", N "85J", O "90", P "90J", Q "95", R "95J", S "98", T "98J"');
query.send(handleQueryResponse);
}

function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + '' + response.getDetailedMessage());
return;
}

var data = response.getDataTable();

    visualization = new google.visualization.Table(document.getElementById('table'));
    visualization.draw(data, { page: 'enable', page: 16, pageSize: 16, legend: 'bottom'});
}
google.setOnLoadCallback(drawVisualization);
</script>

 <div id="table"></div>

</div>

</body>
</html>

But as you can see, this may not be the most secure thing in the world, plus we want to be able to expand it in the future and not be so simplistic, hence the need to switch to SQL.   Please let me know right away by contacting me at disead@gmail.com if this is something YOU might be able to help with. I'm sure for an experienced programmer, once you have the details from me that you need, it would take maybe 10 minutes to write. I don't have much, but I can pay a little bit for this one time job. If it ends up working out, I may be able to pay more down the line for more advanced options such as being able to do drop-down searches based on the column titled "ISSUE", as well as more things down the line as it grows.   Thank you so much, I hope to hear from someone soon!!!

This topic has been moved to MySQL Help.

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