PHP - Counting Keywords Within Mysql Table's Field

I want to loop through a MySQL table, and perform a calculation based on the current row the loop is on and the previous loop.

Say my table has 2 columns - Film_id and FilmRelease, how would I loop through and echo out a calculation of the current FilmRelease and the previous row's column value?

Thanks guys

I have got to this stage, but for some reason it's not printing out anything

Code: [Select]
<?php
 mysql_connect("localhost", "****", "*****") or die(mysql_error()); 
 mysql_select_db("*****") or die(mysql_error()); 

 $sql = mysql_query("SELECT FilmRelease FROM Films_Info") 
 or die(mysql_error()); 

 $last_value = null;

while ($row = mysql_fetch_assoc($sql)) {

  if (!is_null($last_value)) {

    print date_diff($row['FilmRelease'], $last_value) . "<BR>";
  }

  $last_value = $row['FilmRelease'];
}

This topic has been moved to MySQL Help.

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

I have the following code. Basically I'm trying to count the amount of colours returned in the $colour variable. What I have is always returning 1, any ideas why?

Code: [Select]
$colour = $db->query("SELECT * FROM colours WHERE prod_id = ".$row['prod_id']." AND LENGTH(col_image_1) > 0 ORDER BY col_rank ASC LIMIT 1");
$colourcount = mysql_num_rows($colour);

if($db->numrows($colour)) {
$colour = $db->fetchrow($colour);
} else {
unset($colour);
}


Code: [Select]
echo $colourcount;

Hi everyone.
I need to display a list of departments and a total of occurrences of each department in mysql/php.
eg.
There are 3 Administration types.
There are 5 Government types.
etc.
there is no error when i run the code below, but nothing displays happens either. i'd appreciate anyone's help. Thanks.

Code: [Select]
<?php
$query = mysql_query("SELECT CompanyName, CompanyBranch, DateRecorded, DateClosed, Year(DateRecorded) AS Year, CaseOwner.UsersDepartment
FROM records LEFT JOIN CaseOwner ON CaseOwner = CaseOwner.ProperName
GROUP BY CompanyName, CompanyBranch, DateRecorded, DateClosed, CaseOwner.UsersDepartment
ORDER BY CaseOwner.UsersDepartment") or die("SELECT Error: ".mysql_error());
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(CaseOwner.UsersDepartment)'] ." ". $row['CaseOwner.UsersDepartment'] ." types.";
echo "<br />";
}
?>

Hi,   I am trying to make a list of all countries listed in a database and the number of times they appear. But I am clearly doing something wrong as I am not able to list out the number of times that they appear.   This is what I have got so far:

<h4>Countries</h4>
<table><col width='150px'><col width='150px'>
<tr>
	<th>
		Country
	</th>
	<th>
		Number of Occurences
	</th>
</tr>
<?php
$location = DB::getInstance()->query("SELECT country, COUNT(country) as countCountry FROM users GROUP BY country ORDER BY count DESC");
foreach ($location->results() as $locations)
{
	echo "<tr><td>";
	echo $locations->country;
	echo "</td><td>";
	echo $locations->countCountry;
	echo "</td></tr>";
}
?>
</table>

Can anyone point me in the right direction?

I know how much you guys hate people asking for help without any starting code but I'm not even sure how to start this..

I want a script to read this page and count all the admins and referees.

If anyone is willing to help, here's a sample of the html code:
Code: [Select]
<div class="boxInner"><h3>Arena Referees</h3><table class="list"><thead><tr><th style="width:16px;"></th><th style="width:150px;">Name</th><th style="width:300px;">Position</th><th style="width="150px;">Gamertag</th></tr></thead><tbody><tr><td><a href="http://gamebattles.com/profile/GottaHaveFaith78"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td class="alt1">Faith</td><td><b>Head Referee</B></td><td class="alt1">GB CombatBarbie</td></tr><tr><td class="alt2"><a href="http://gamebattles.com/profile/Jack.-"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td>Jack</td><td class="alt2"><b>Asst. Head Referee</b></td><td>Get Jacked x</td></tr><tr><td><a href="http://gamebattles.com/profile/amghawk"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td class="alt1">Mike</td><td><b>Asst. Head Referee (IS)</b></td><td class="alt1">GB amghawk</td></tr><tr><td class="alt2"><a href="http://gamebattles.com/profile/cory94bailly"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td>Cory</td><td class="alt2">Referee</td><td>Cory xz</td></tr><tr><td><a href="http://gamebattles.com/profile/crago"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td>

I'm just wondering how I could even count them.

Any help will be appreciated, thanks.

Hi,

I have a problem regarding counting rows in a mysql table. Here is the code:

Code: [Select]
<?php
require_once('includes/connection.inc.php');
$conn = dbConnect('read');
$check = 'SELECT COUNT(*) FROM images';
$checkRes = $conn->query($check) or die(mysqli_error());
if($checkRes <= 0) { header('Location: empty_blog.php'); // redirect to another page
} else { // do something else... }
?>

The error I'm getting: "Notice: Object of class mysqli_result could not be converted to int in C:\xampp\htdocs\photoblog\index.php on line 6"

Any help is greatly appreciated!

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

I am in need of suggestions on how too achive this:

I have a surf exchange and whenever a member has viewv a site, it ads this members Id and time to a table called vtp_tracking.

I have now created a team script, so I can count the total of surf for members within this team from the vtp_table.

What I am in need of is this:
I would like to add a bonus for the teams, so my idea was this: every hour run a cronjob to get the results for the last hour by team id lik so:

Code: [Select]
WHERE vtp_members.team_id="teamid" AND vtp_tracking.credit_members_id=vtp_members.id AND vtp_tracking.action_date>date_sub(NOW(),interval 60 minute
I believe the above code will work fine and get me the results for team members for the last hour.

Problem: how can I get this result, multiple it with the value from another field and divide by 100  and add this to a third field?

eg: (result from above * value from other field / 100) then add to a third field.

Anyone willing to try and answer this one?

I wish to have a page that will display a form if there aren't already enough registrations in the database. The following it an outline of how it will be:

<?php
require_once "../scripts/connect_to_mysql.php";                        //this works fine


// Count how many records in the database
(1) $sqlCommand = "SELECT * FROM teams"; 
(2) $sqlCommand = "SELECT COUNT (*) FROM teams";
(3) $sqlCommand = "SELECT COUNT (id) FROM teams";
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());
(1) $numRegistrations = mysql_num_rows($query); //Count how many rows are returned from the query above
(2) $numRegistrations = $query
(3) $numRegistrations = mysql_num_rows($query);

mysqli_free_result($query);
?>
(Some HTML code, like DOCTYPE, head, start of body tags)
<?php
if($numRegistrations > 35){
echo "Sorry, registrations for this event is at it's maximum.";
}else{
?>

<form blah blah blah>

</form>

<?php
}
?>

(end of body and html tag)



You'll see above there is (1), (2), (3). These are the main 3 that I've been trying, and they match up the $sqlCommand to the $numRegistrations.

What would be the problem with this code? I use wamp server to test, have been using it for ages. Chrome browser to test in.
If I remove the database query, the rest of the page will load.
With the query in there, only the HTML code up until the database query is parsed, so therefore nothing is display on the page.

Please help.

Thanks
Denno

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

In my mysql database i have a field that records peoples details one part of the details is their county/region they live in. It records the county in a normal varchar field however i need a simple php script that searching the database and finds the most common county so i can then return to the screen where the most popular region for my members.

Thank you for reading.

I have this script running:


<?php
$query = mysql_query("SELECT * FROM jobs WHERE event = 'Yes' ORDER BY title");
while ($row = mysql_fetch_array($query)) {
?>


How do I check if a field is empty and NOT display it...?

For instance it has a 'applied' field, if that is empty I dont want it to display, however I still  need the event = 'Yes' part.

Hi i have the following code

Code: [Select]
$orderFetch->order="3";
mysql_query("UPDATE `categories` SET order=order-1 WHERE `order` > $orderFetch->order");

i wish to minus -1 from all the "order" fields in categories that are over a certain value i.e 3. But however this code is not working can anyone tell me where i'm going wrong?

thank you