PHP - Php And Database, Too Much Query Issue

I'm having a problem with adding icon/avatar to my database..this is a submit form where I just submit the avatar url. I don't know how to change the submit link from avatar_add.php?mode=submit to index.php?mode=submit&x=avatar_add.
http://www.graphics.allmerk-noplay.com/index.php?x=avatar_add


Code: [Select]
<?php
$host =""; // host name
$user =""; // user
$pass =""; // password
$dbase =""; // database name

// connect to the server
mysql_connect("$host","$user","$pass");
// and select the database
mysql_select_db($dbase);

$mode=$_GET["mode"]; // get the mode
$QUERY_STRING = 'x=avatar_add';

if(!isset($mode) || empty($mode)) // if mode is empty, switch to case index
{
$mode='index';
}

switch($mode)
{

case 'index'; // displays the form
?>


<form method="post" action="avatar_add.php?mode=submit">
Avatar URL:<br>
<input type="text" name="avatar_url" size="30"><br><br>
<input type="submit" value="Submit">


<?php
break;

case 'submit'; // form processing mode

$avatar_url=$_POST["avatar_url"];

// check for empty fields
if(empty($avatar_url))

{
echo "Error! Please go back and fill in all the required fields!";
// if you have a footer include, insert it before the die statement
die; // stops the script from executing the rest of the code
}

// let's get the date in YYYY-MM-DD format
$date = date("Y-m-d");

$query="INSERT into icons_db (id,avatar_url) VALUES ('','$avatar_url')";
$result=mysql_query($query) or die ("Couldnot execute query: $query." . mysql_error());

if($result) // if mysql query successful
{ echo "Thank you! The avatar has been added to or database."; }

break;

}

?>

I have a test database set up that I am working on. Right now, just some names like so

firstName
lastName
companyName

I have used phpmyadmin to insert names in the database. Right now just three names are inserted. One first and last name, one first name and one company name

I am getting the results back in an associative array. How can I echo out the information with the break tag, or one field at a time? if I use a break tag, then the loop adds in extra blank lines when it gets to the first name and it's null. Can I test for null values and do it that way? I am a beginner so I have no idea what I am doing.

Code: [Select]
$result = $mysql->query("select * from names") or die($mysql->error);
if($result){
while($row = $result->fetch_assoc()){
$name = $row['firstName'];
$lastName = $row['lastName'];
$company = $row['companyName'];

echo $name . " ";
echo $lastName . " ";
echo $company . " ";
}

}

So I'm creating a website for bar deals... I've tried for hours trying to get the url to take in more than one parameter with no luck, I don't know if my database isn't setup correctly or something but the url would look like this

http://www.site.com/?id=1&day=Monday

and when those parameters are passed the deals for that id and day are then posted in the content area

I'm pretty much stumped. I feel like it's much easier than I am making it.

My database looks like:

ID   Name  Monday           Tuesday        Wednesday -> and so on

1    Bar1   MondayDeal TuesdayDeal WednesdayDeal
2    Bar2   MondayDeal -> and so on

Hi
I'm using a couple of queries to search a database.
This works well but is slow as I'm cascading/nesting the queries..

Below is an example of what I mean... (LDAP queries)
Code:

Code: [Select]
<?
   $dn = "cn=user";
     $filter="(objectclass=user)";
     $justthese = array('cn','telephone','guid','ID','email');
     $sr=ldap_search($ds, $dn, $filter, $justthese);
     $info = ldap_get_entries($ds, $sr);
        for ($n=0; $n<$info['count']; $n++) {
$cn = $info[$n]['cn'][0];
$email = $info[$n]['email'][0];
$id= $info[$n]['id'][0];

   $dn = "cn=Device";
     $filter="(objectclass=device)(userid=$id)";
     $justthese = array('cn','system','guid','ID','userid');
     $sr=ldap_search($ds, $dn, $filter, $justthese);
     $info = ldap_get_entries($ds, $sr);
        for ($n=0; $n<$info['count']; $n++) {
$system = $info[$n]['system'][0];
$userid = $info[$n]['userid'][0];

    }
      }
?>
I'm sure there's a better way of writing this... that will make it faster.

Thanks

Hi guys, i am currently working on a project that queries an inventory database through the use of radio buttons, for example; If the first button FOR THE Item(HAMMERS)is clicked, the output should be the name of the item, the number sold and the total profit(calculations) into a table. the way i have it now, when io click on the radio button my output comes back as the results for all the items in the table, i want it to display only the information about hammers, then only about each individual item when the corresponding radio button is clicked. any help would be greatly appreciated!!!

Working on a website directory that includes ratings for listed companies. Trying to obtain information from database that would put some companies in a higher category than others. Or at least, I believe that is the approach I should be taking.   There are a few tricky issues.   1. Ratings are their own custom posts but are attached to company pages (parents) 2. Rating values I need to obtain are meta keys (1. total number of ratings & 2. rating average of EACH) 3. Ratings are based on four criteria which are summed and averaged for each rating submitted. As a result, values are rarely single digits such as 4 or 5 but include decimals rounded to 1 place (e.g. 4.8 or 3.5)   Additional info: Ratings are based on 5-star system (out of 5) Higher category would be business that achieved at least 10 ratings of 4 or more   Any help appreciated.  

The title may not fit but only thing i could think of.

I am pulling data from MSSQL database table.... I need everything from that table but i need to do some basic math funcitons to the resulting data.

So the quesiton is should i do the math for this in the SQL query if so how do i pull all fields and do the math in an effcient way.

Or should i let php do the math for me after i get all the data i need. 

If it is better to use php how can i do this in a while loop and get the math result and not a printed equation.

Just looking for a few pointers never had to do math before with php

Hello!   I have a php page which shows a list of customers displayed in an html table format, The first column in the table contains a link for the user to select the row which then navigates to another php page, which is the customer order page. On this page, I want to get certain information based on the name of the customer to prepopulate the customer fields on this form, so I have some php code near the top of the page, as per attached document.   I have checked to ensure that the $_GET['business_name'] contains a value. The query runs fine in myssql and returns only one record when I provide a value for the business_name, however when I run the code in php, the $result variable shows 'Resource id ='7' type='mySQL result'.   I am a total newbie on PHP/MySQL and inherited this application. I have tried to find solutions on line through various forums, but no luck. Perhaps I am not asking/looking for the right question.   Anyway, any assistance would be greatly appreciated.           Attached Files  customer_order_php.php   648bytes   1 downloads

I'm very new to php and mysql so this might be a very stupid question and I'm apologizing ahead of time. Anyway I have a page titled Apparel.php that is supposed to show the most recent item uploaded from each of it's subpages. In other word Apparel is the $category and it has 4 $subcategories (Dresses.php, Skirts.php, Coats.php and Shorts.php). I was able to successfully have the right items show but my coding is pretty long, which I think may affect the speed of the page from loading. I'm sure there's a way to shorten it by perhaps using just one query but I can't figure out how. I'm actually using 4 queries but only posted 2 to keep it shorter. Thanks ahead of time!

Code: [Select]
<?php 
// Run a select query to get latest item from each subcategory
$dynamicList = "";
$query1 = mysql_query("SELECT * FROM products WHERE category='Apparel' AND subcategory='Dresses' ORDER BY date_added DESC LIMIT 1");
$query2 = mysql_query("SELECT * FROM products WHERE category='Apparel' AND subcategory='Skirts' ORDER BY date_added DESC LIMIT 1");
$productCount = mysql_num_rows($query1); // count the output amount
   while($row = mysql_fetch_array($query1)){ 
   $id = $row["id"];
   $product_name = $row["product_name"];
   $subcategory = $row["subcategory"];
   $dynamicList .= '
   <ul>
   <li><a href="Apparel/' . $subcategory . '.php"><img src="inventory_images/' . $id . '_1.jpg" alt="' . $product_name . '" width="140" height="210" border="0" /></a>
   <center><h3>' . $subcategory . '</h3></center>
   </li>
   </ul>';
}
$productCount = mysql_num_rows($query2); // count the output amount
   while($row = mysql_fetch_array($query2)){ 
   $id = $row["id"];
   $product_name = $row["product_name"];
   $subcategory = $row["subcategory"];
   $dynamicList .= '
   <ul>
   <li><a href="Apparel/' . $subcategory . '.php"><img src="inventory_images/' . $id . '_1.jpg" alt="' . $product_name . '" width="140" height="210" border="0" /></a>
   <center><h3>' . $subcategory . '</h3></center>
   </li>
   </ul>';
}
mysql_close();
?>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi everyone...

My script register01.php isnt working as expected, it should take variables from register00.php and insert them into the db. It is currently re-loading itself and not inserting, could you take a look at this for me:

register00.php

Code: [Select]
<form enctype="multipart/form-data" method="post" action="register01.php">
 <table width="316" height="120" border="0">
 <tr><td colspan=2><h1>Register/Sign Up</h1></td></tr>
 <tr><td>Company Name:</td><td>
 <input name="company_name" type="text" id="company_name">
 </td></tr>
 <tr><td>Contact Name:</td><td>
 <input name="contact_name" type="text" id="contact_name">
 </td></tr>
 <tr><td>Contact Number:</td><td>
 <input name="phone" type="number" id="phone" value="incl. area code">
 </td></tr>
 <tr><td>Address line 1:</td><td>
 <input name="street1" type="text" id="street1">
 </td></tr>
 <tr><td>Address line 2:</td><td>
 <input name="street2" type="text" id="street1">
 </td></tr>
 <tr><td>Area:</td><td>
 <input name="location" type="text" id="location">
 </td></tr>
 <tr><td>City:</td><td>
 <input name="city" type="text" id="city">
 </td></tr>
 <tr><td>Postcode:</td><td>
 <input name="postcode" type="text" id="postcode">
 </td></tr>
 <tr><td>Username:</td><td>
 <input name="username" type="text" id="username">
 </td></tr>
 <tr><td>Password:</td><td>
 <input name="password" type="password" class="style7" id="password">
 </td></tr>
 <tr><td>Email:</td><td>
 <input name="email" type="text" class="style7" id="email">
 </td></tr>
 <tr><td>Company Logo:</td><td>
 <input name="upload" type="file" class="style7" id="upload">
 </td></tr>
 <tr><td>Company Description:</td><td>
 <textarea rows="20" cols="50" name="premiumuser_description" id="premiumuser_description"></textarea>
 </td></tr>
 <tr><td>
 <input name="Submit" type="submit" value="Register" />
 </td></tr>
 </table>

register01.php

Code: [Select]
<?PHP
session_start();
include('db.php');
/* set some validation variables */
$error_message = "";

/* DEFINE THE FUNCTION */
/* ============================================== */
/* ============================================== */
/* DO NOT MODIFY THIS FUNCTION */
function Resize_Image($save,$file,$t_w,$t_h,$s_path,$o_path) {
$s_path = trim($s_path);
$o_path = trim($o_path);
$save = $s_path . $save;
$file = $o_path . $file;
$ext = strtolower(end(explode('.',$save)));
list($width, $height) = getimagesize($file) ;
if(($width>$t_w) OR ($height>$t_h)) {
$r1 = $t_w/$width;
$r2 = $t_h/$height;
if($r1<$r2) {
  $size = $t_w/$width;
}else{
  $size = $t_h/$height;
}
}else{
$size=1;
}
$modwidth = $width * $size;
$modheight = $height * $size;
$tn = imagecreatetruecolor($modwidth, $modheight) ;
switch ($ext) {
case 'jpg':
case 'jpeg':
$image = imagecreatefromjpeg($file) ;
break;
case 'gif':
$image = imagecreatefromgif($file) ;
break;
case 'png':
$image = imagecreatefrompng($file) ;
break;
}
imagecopyresampled($tn, $image, 0, 0, 0, 0, $modwidth, $modheight, $width, $height) ;
imagejpeg($tn, $save, 100) ;
return;
}
/* END OF RESIZE FUNCTION */

//This is the directory where images will be saved
$target = "/home/users/web/b109/ipg.removalspacecom/images/COMPANIES/";
$target = $target . basename( $_FILES['upload']['name']);
 
 // Connects to your Database
 session_start();
 include ('db.php');

//This gets all the other information from the form
/* ============================================== */
/* ============================================== */
/* YOU NEED TO DO SOME VALIDATION AND SANITIZING OF YOUR FORM DATA */


if((!isset($_POST['company_name'])) || (strlen(trim($_POST['company_name'])) <5) || (trim($_POST['company_name']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['company_name'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid company name<br>";
$error_message = $error_message . "Valid names  are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['company_name'] . "</font><hr>";
}
/* END validating company_name */
/* =============================================== */

if((!isset($_POST['contact_name'])) || (strlen(trim($_POST['contact_name'])) <5) || (trim($_POST['contact_name']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['contact_name'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid contact name<br>";
$error_message = $error_message . "Valid names  are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['contact_name'] . "</font><hr>";
}
/* END validating contact_name */
/* =============================================== */

 

if((!isset($_POST['phone'])) || (strlen(trim($_POST['phone'])) <5) || (trim($_POST['phone']) != preg_replace("/[^0-9\s\-\_]/", "", trim($_POST['phone'])))) {
/* if it is NOT set, then set the error variable and start building the error message */
$error_message = $error_message . "You must enter a valid phone<br>";
$error_message = $error_message . "Valid phones are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid phone was: <font color="red">' . $_POST['phone'] . "</font><hr>";
}else{
$phone = trim($_POST['phone']);
}

/* END validating phone */
/* =============================================== */

/* =============================================== */
/* validating the email */
/* create a function */
function validateEmailAddress($email) {
return filter_var($email, FILTER_VALIDATE_EMAIL) && preg_match('/@.+\./', $email);
}
if(!isset($_POST['email']) || validateEmailAddress($_POST['email']) !=1) {
$error_message = $error_message . "You must enter a valid email address<br>";
$error_message = $error_message . 'The invalid email was: <font color="red">' . $_POST['email'] . "</font><hr>";
}
/* END validating email */
/* =============================================== */

if((!isset($_POST['street1'])) || (strlen(trim($_POST['street1'])) <5) || (trim($_POST['street1']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['street1'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid address<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['street1'] . "</font><hr>";
}
/* END validating street1 */
/* =============================================== */

if((!isset($_POST['street2'])) || (strlen(trim($_POST['street2'])) <5) || (trim($_POST['street2']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['street2'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid address<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['street2'] . "</font><hr>";
}
/* END validating street2 */
/* =============================================== */

if((!isset($_POST['premiumuser_description'])) || (strlen(trim($_POST['premiumuser_description'])) <5) || (trim($_POST['premiumuser_description']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['premiumuser_description'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid address<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['premiumuser_description'] . "</font><hr>";
}
/* END validating premiumuser_description */
/* =============================================== *


/* =============================================== */
/*
this section of code will set up an error message for the
username if ANY of the conditions occur
1) checks to see if $_POST['username'] is NOT set
2) if length of username is less than 5
3) if username has anything other than letter, numbers or underscores
*/
if((!isset($_POST['username'])) || (strlen(trim($_POST['username'])) <5) || (trim($_POST['username']) != preg_replace("/[^a-zA-Z0-9\_]/", "", trim($_POST['username'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid username<br>";
$error_message = $error_message . "Valid names  are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['username'] . "</font><hr>";
}
/* END validating username */
/* =============================================== */


/* =============================================== */
/*
this section of code will set up an error message for the
password if ANY of the conditions occur
1) checks to see if $_POST['upassword'] is NOT set
2) if length of upassword is less than 5
3) if upassword has anything other than letter, numbers or underscores
*/
if((!isset($_POST['password'])) || (strlen(trim($_POST['password'])) <5) || (trim($_POST['password']) != preg_replace("/[^a-zA-Z0-9\_]/", "", trim($_POST['password'])))) {
/* if it is NOT set, then set the error variable and start building the error message */
$error_message = $error_message . "You must enter a valid password<br>";
$error_message = $error_message . "Valid passwords are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid password was: <font color="red">' . $_POST['password'] . "</font><hr>";
}else{
$password = trim($_POST['password']);
}
/* END validating password */
/* =============================================== */

/* =============================================== */
/* check to see if username is already taken */
$username = mysql_real_escape_string(trim($_POST['username']));
$query1 = "SELECT username from companies WHERE username = '$username'";
$result1 = mysql_query($query1)  or die(mysql_error());
$count = mysql_num_rows($result1);
if($count>0) {
$error_message = $error_message . 'The username: <font color="red">' . $_POST['username'] . "</font> is taken.<hr>";
}

/* =============================================== */
/* if any of the post variables are invalid */
/* set the session variable and send back to the form page */
if(strlen(trim($error_message))>0) {
$_SESSION['error_message'] =$error_message;
header("Location: register00.php");
exit();
}
/* =============================================== */

$uploadDir = 'images/COMPANIES'; /* main picture folder */
$max_height = 450; /* largest height you allowed; 0 means any */
$max_width = 450; /*  largest width you allowed; 0 means any */
$max_file = 2000000;  /*  set the max file size in bytes */
$image_overwrite = 1; /* 0 means overwite; 1 means new name */
/* add or delete allowed image types */
$allowed_type01 = array( "image/gif", "image/pjpeg", "image/jpeg", "image/png", "image/x-png", "image/jpg");
$do_thumb = 1; /*  1 make thumbnails; 0 means do NOT make */
$thumbDir = "/images/thumbs";  /*  thumbnail folder */
$thumb_prefix = "";  /*  prefix for thumbnails */
$thumb_width = 90; /*  max thumb width */
$thumb_height = 70; // max thumb height
 
 //Writes the photo to the server
if(move_uploaded_file($_FILES['upload']['tmp_name'], $target)) {
/* HERE IS WHERE WE WILL DO THE ACTUAL RESIZING */
/* ============================================== */
/* ============================================== */
/* THESE SIX PARAMETERS MAY BE CHANGED TO SUIT YOUR NEEDS */
$o_path ="images/COMPANIES/";
$s_path = "images/thumbs/";
$file = $upload;
$save = $file;
$t_w = 200;
$t_h = 150;
/* ============================================== */
/* ============================================== */
/* DO NOT CHANGE THIS NEXT LINE */
Resize_Image($save,$file,$t_w,$t_h,$s_path,$o_path);

//Tells you if its all ok
/* ============================================== */
/* ============================================== */
/* PROVIDE A WAY FOR THEM TO GO SOMWHERE */
echo "The file ". $file . " has been uploaded, and your information has been added to the directory";

}else {
//Gives and error if its not
/* ============================================== */
/* ============================================== */
/* PROVIDE A WAY FOR THEM TO GO SOMWHERE */
echo "Sorry, there was a problem uploading your file.";
}




/* =============================================== */
/* PREPARE DATA FOR INSERTION INTO TABLE */
/* FUNCTION TO CREATE SALT */
function createSalt() {
$string = md5(uniqid(rand(), true));
return substr($string, 0, 3);
}
 
 
 //Writes the information to the database
/* ============================================== */
/* ============================================== */
/*
ALWAYS WRITE YOUR QUERIES AS STRINGS
THAT WAY WHEN TESTING, YOU CAN MAKE
SURE THAT THE VALUES CONTAIN WHAT YOU EXPECT
*/

 
$salt = createsalt();
$passwod = trim($_POST['password']);
$hash = hash('sha256', $salt, $password);
$approved = 0;
$username = mysql_real_escape_string(trim($_POST['username']));
$email = mysql_real_escape_string(trim($_POST['email']));
$query ="INSERT INTO `companies` (company_name, contact_name, location, postcode, street1, street2, city, phone, email, basicpackage_description, premiumuser_description, password, salt, approved, upload) VALUES ('$company_name', '$contact_name', '$location', '$postcode', '$street1', '$street2', '$city', '$phone', '$email', '$basicpackage_description', '$premiumuser_description', '$password', '$salt', '$approved', '$upload')";
$result = mysql_query($query) or die(mysql_error());
/* =============================================== */

/*
at this point we can send an email to the admin as well
as the user.
DO NOT send the user's password to ANYONE!!!!
*/
?>
Thank you for registering.<br>;
Your account will be approved and activated within 24 hours.<br><br>
Click here to return to the <a href="index.php">main page</a>.

This topic has been moved to MySQL Help.

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

I'm trying to get a nickname system working for a little project, but I've run into a problem.

This code that I wrote here gets the users nickname from their username:

Code: (php) [Select]
$user = $_GET['user'];
@mysql_select_db("db") or die( "Unable to select database");

$query = mysql_query("SELECT `nickname` FROM `info` WHERE `username`='$user'");

       WHILE($rows = mysql_fetch_array($query)):
           $nickname = $rows['nickname'];
           echo $nickname;
        endwhile;
?>

But the problem is, if the user doesn't have a nickname then it just turns up blank. How can I check if the output of $nickname is blank and if it is then just return their normal name ($user)

Thanks

Oh, and how to you format php code to look like php code on these forums?

Last Christmas my wife bought me a book on html and css because I said that I have always wanted to write a website. Over the last 10 months I have really enjoyed learning web design and have progressed to try and learn php and using myPHPadmin databases.   I am now trying to write a private message function.

I've got a members database and a conversation database. I am trying to filter out whether a private message is 'read' or 'unread', but whatever I try it is still listing all messages under both options. I've spent 48 hours staring at this bit of code. Can anyone see what I have done wrong?

The relevant (and self-explanatory) fields from my members database a
id
username
member_first_name
member_last_name

The relevant fields from my conversation database a
id
id2 (always set as '1' to count messages in a conversation)
member1 (the initial sender of the first message)
member2 (the initial recipient of the first message)
read1 (member1 has read this message default to yes when message sent and to no when message received)
read2 (member2 has read this message default to yes when message sent and to no when message received)
removed1 (member1 has deleted this message from their record)
removed2 (member2 has deleted this message from their record)
time (timestamp)
 

<?php
$query1 = DB::getInstance()->query("SELECT c1.id, c1.title, c1.time, c1.removed1, c1.removed2, count(c2.id) AS reps, 
                    m.id as memberid, m.username m.member_first_name, m.member_last_name
                    FROM conversation as c1, conversation as c2, members as m
                    WHERE ((c1.member1='{$logid}' AND c1.read1='No' AND c1.removed1='No'
                    AND m.id=c1.member2)
                    OR (c1.member2='{$logid}' AND c1.read2='No' AND c1.removed2='No'
                    AND m.id=c1.member1))
                    AND c1.id2='1' AND c2.id=c1.id
                    GROUP BY c1.id
                    ORDER BY c1.id DESC");
$query2 = DB::getInstance()->query("SELECT c1.id, c1.title, c1.time, c1.removed1, c1.removed2, count(c2.id) as reps, 
                    m.id as memberid, m.username, m.member_first_name, m.member_last_name
                    FROM conversation as c1, conversation as c2, members as m
                    WHERE ((c1.member1='{$logid}' AND c1.read1='Yes' AND c1.removed1='No'
                    AND m.id=c1.member2)
                    OR (c1.member2='{$logid}' AND c1.read2='Yes' AND c1.removed2='No' AND
                    m.id=c1.member1))
                    AND c1.id2='1' AND c2.id=c1.id
                    GROUP BY c1.id
                    ORDER BY c1.id DESC");
?>

UNREAD MESSAGES (<?php echo intval($query1->count()); ?>)
<br>
READ MESSAGES (<?php echo intval($query2->count()); ?>)

I've tried running through things in a logical path:   UNREAD MESSAGES member1 = logged in user read1 = No removed1 = No members.id = member2       OR member2 = logged in user read2 = No removed2 = No members.id = member1   READ MESSAGES member1 = logged in user read1 = Yes removed1 = No members.id = member2       OR member2 = logged in user read2 = Yes removed2 = No members.id = member1   I can't understand how if 'read1 = yes and the logged in user is member1, why they are being counted in the unread list.   Can anyone see what I have done wrong?
Edited by MartynLearnsPHP, 15 November 2014 - 08:05 AM.

Hello every body....   I'm creating a simple php project where the user will be able to choose option from dropdown menu and the query will be executed accordingly..   The html form is shown below....

<select name='movie_name'>
<option value='ALL'>All</option>
<option value='blah'>Blah blah </option>
<option value='blah'>Blah blah </option>
...
</select>

<select name='movie_genre'>
<option value='ALL'>All</option>
<option value='Horror'>Horror</option>
<option value='Anime'>Anime</option>
...
</select>

<select name='movie_cast'>
<option value='ALL'>All</option>
<option value='john'>john</option>
<option value='Katrina'>Blah blah Katrina</option>
...
</select>

If the user select "ALL" then, all the resuls will be displayed according to the selected options   AND again   If the user select "different" options then, all the resuls matcing from the database will be shown...   Tha database schema is shown below   | id | movie_name| movie_genre | movie_cast   | 1 | Hello Brother | Comedy        |  Salman Khan   | 2 | Blah blah       | ALL               | Blah blah   | 3 | ALL              |   ALL               | ALL   | 4 | Blah Blah      | Blah Blah       | ALL     * here "ALL" is a specific text which may or may not be present in the rows....   Thank u in advance....