PHP - Php/mysql Pains

So i have this php as shown below. It should make a list of comments with comment replies below their comment respectively.

The problem is that it only goes through and shows 1 comment and all the comment replies for that one comment. It should be showing all comments i have in the db for that article.

If i remove the second while then it shows all the comments correctly but no comment replies then...

How do i get this script to loop through the db for every comment but also loop through every comment reply for that $row[id]?

If anyone has a better / more efficient way of what I am trying to do, please explain or show example (i am open to anything)...

Code: [Select]
// what article are we showing?
$article_to_show_id = $_GET['article_id'];


$active_is_set_text = "1"; // Active Column text that makes it okay to show

// Finding the article
$search_for_article = mysql_query("SELECT * FROM articles WHERE id = '$article_to_show_id' AND active = '$active_is_set_text'");

while($row = mysql_fetch_array($search_for_article))
{
// format the last updated date right
$update_date_edit = $row[update_date];

$update_date_edit = date('F j, Y \a\t h:ia', $update_date_edit);

$row[update_date] = $update_date_edit;



// format the submit updat date right
$submit_date_edit = $row[submit_date];

$submit_date_edit = date('F j, Y \a\t h:ia', $submit_date_edit);

$row[submit_date] = $submit_date_edit;


echo '
<div>
', $row[title] ,'
</div>


<div>
by: ', $row[author] ,' on ', $row[submit_date] ,'
</div>



<div>
', $row[content] ,'
</div>


<div>
Last Updated: ', $row[update_date] ,'
</div>

<form action="article_reply.php" method="post">
<input type="hidden" name="article_id" value="', $row[id] ,'" />
<button name="article_reply" type="submit" value="submit">Reply</button>
</form>

';

}

$comment_count = 0;
$comment_reply_count = 0;

// Finding all of the comments
$search_for_article = mysql_query("SELECT * FROM article_comments WHERE article_id = '$article_to_show_id' AND reply_id = '0'");

while($row_comment = mysql_fetch_array($search_for_article))
{
// format the submit updat date right
$comment_date_edit = $row_comment[comment_date];

$comment_date_edit = date('F j, Y \a\t h:ia', $comment_date_edit);

$row_comment[comment_date] = $comment_date_edit;

echo '
<br>
<br>
COMMENT:<br>

<div>
By: ', $row_comment[username] ,' on ', $row_comment[comment_date] ,'
</div>

<div>
', $row_comment[comment] ,'
</div>
';
$comment_count++;

// Finding all of the comment replies if any
$search_for_article = mysql_query("SELECT * FROM article_comments WHERE article_id = '$article_to_show_id' AND reply_id = '$row_comment[id]'");

while($row_two = mysql_fetch_array($search_for_article))
{
// format the submit updat date right
$comment_date_edit = $row_two[comment_date];

$comment_date_edit = date('F j, Y \a\t h:ia', $comment_date_edit);

$row_two[comment_date] = $comment_date_edit;

echo '
<br>
<br>
COMMENT REPLY:<br>

<div>
By: ', $row_two[username] ,' on ', $row_two[comment_date] ,'
</div>

<div>
', $row_two[comment] ,'
</div>
';
$comment_reply_count++;
}
}

Need some help I have 2 tables in a database and I need to search the first table and use the results from that search, to search another table, can this be done? and if it can how would you recommend that I go about it?

Thanks For Your Help Guys! 

I am having issues in writing a program. The basic idea is a internet radio website. I have a page listing all shows on the station with a brief description. When you click on a specific show from that page, i need it to open a page showing more detail on just that show. The show list page is loading with no problem, but the show detail pages keep coming up with "Error in your sql syntax at line 1"

See what I have at http://www.eliteweboffers.com/lwrs/shows.php

Here is the code from config.php

Code: [Select]
<?php

mysql_connect($host,$user,$password);

mysql_select_db($db);

//Functions

function show_list()

{

$query = "SELECT * FROM shows"; 
 
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
 echo " <table border='0'>
         <tr>
          <td rowspan='2'>
           <a href='". $site ."show_page.php?". $row['id'] ."' name='show_id' value='". $row['id'] ."'>
           <img src='". $site,$row['picture'] ."' height='180' width='180'></img></a>
  </td>
          <td> "
           . $row['show'] .
" </td>
         </tr>
 <tr>
          <td> "
           . $row['description-short'] .
        " </td>
 </tr>
        </table> ";}
}

function show_page()

{

$show_id=$_POST[show_id];

$query = "SELECT * FROM shows WHERE id = $show_id"; 
 
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
 echo " <table border='0'>
         <tr>
          <td rowspan='2'>
           <img src='". $site,$row['picture'] ."' height='180' width='180'></img>
  </td>
          <td> "
           . $row['show'] .
" </td>
         </tr>
 <tr>
          <td> "
           . $row['description-short'] .
        " </td>
 </tr>
        </table> ";}

}

?>

If i change the line
Code: [Select]
$show_id=$_POST[show_id];to
Code: [Select]
$show_id=1;
It loads the show detail page properly for the first show. I don't want to have to use "if" statements for every single show id.

What am I doing wrong ? Can anyone help ???

Here is the code from shows.php

Code: [Select]
<?php

include ('/home/ansonb/lwr_config.php');

show_list();


?>

Here is the code from show_page.php

Code: [Select]
<?php

include ('/home/ansonb/lwr_config.php');

show_page();


?>


Any help would be greatly appreciated.

Thank you !

Hey guys, I've heard about MySQL being replaced with PDO some time in the future, but as a simple question, I'm coding a personal website for my use only, would I still be able to use MySQL rather than changing it to PDO and learning that?    Its not going to be anything big or nothing just to keep me active in my spare time.   Thanks for you help.

Not sure if this is the correct place to ask this question but here we go. I just wanted to know if I could insert into a MySQL database table a PHP conditional statement. I mean I am able to add this data to the table but when I grab that info from the table and echo it out to the browser it does not get displayed correctly. What I am trying to do is add a small login form into the table and render it out but I see the acutal code instead of the form. If I removed all PHP code the form will render correctly. So I was thinking either I cant add PHP or I am doing it wrong.

hello every one   I have some queries in mysql command..   I have a table schema like this   id | name | url | img1 | img2 | img3 | img4|   I want to randomly rotate the image by specific id....   suppose the select the id = 1, then the four images will be rotated randomly for with the tha id (i.e id = 1)   Any help wil greatly appreciated   Thank u.....

Hey guys I need some help for making some things work. This is my index.php and as you can see I have a table of my sql table and a drop list. Now when I press Add to chart on the table on my website, it goes to the cart. But when I select a item from the drop list and click on Add to chart, there only happens an increment of the quantity but the item does not go to the cart.

http://fhcs.be/cart-demo2/index.php  this is my website where you can check the problem out. Thanks Guys!!!!

Code: [Select]
<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
$sql = 'SELECT * FROM products ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['name'].': &euro;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
?>
<?


$Link = mysql_connect("fhcs.be.mysql","fhcs_be","xxxx");
$Query = "SELECT * FROM products";
$DBName = "fhcs_be";
$results = mysql_db_query($DBName, $Query, $Link);



?>
Select a name
<select name = "drop1" size="1">
<Option Value=" ">Select One:</option>
<? //Begins PHP

for($u=0;$u<mysql_num_rows($results); $u++) {
$ID=mysql_result($results,$u,'name');
?>



<option value="<? echo($ID); ?>"><? echo($ID); ?></option><? //Begins PHP
 //Begins PHP
}
?>
</select>

<? //Begins PHP
if (mysql_db_query ($DBName, $Query, $Link)) {

}

else {
print ("FAILURE<BR>\n");
}


mysql_close ($Link);




?>


</div>

</body>
</html>

is it true  ?  in paging 0,92,085,0,50,066,0,73 etc its  coming to mixing
Quote

$en_cokk = mysql_query("select baslik,baslik_seo , liked/(liked+hate) avg from hikayeler order by  avg  DESC limit 10");


there are two row in database  liked and hate;
how can i take average and sort desc  to page  from database ?   

hey Guys I have a table in a db that stores attack details for my game below

Code: [Select]
id attacker win defender time deleted
1 17           1 84 1288576720 0
2 22           1     84 1288576989 0


i want to give a stat like,

 total attacks made : 20 (times there id is attacker)
 percent successful = 20% (if win =1 its a win =0 its a loss)

and the same with times attacked.

I was thinking along the lines of getting the info using
Code: [Select]
$stat = mysql_fetch_array(mysql_query("select * from attacklog where attacker='$userid' AND win='1'"));

would i just do that for every option in the database?

Hi Chaps,

I've got something of a mixed bag, in which I need some help with a MySQL query and PHP to display the results correctly.

I'm basically after the following:

Query to produce results of; invoice_item_price of all jobs that include a Typesetting task and all of those that don't.

The problem I'm having is that I can't figure out how to get the correct SUMtotal of the invoice_item_price, when searching through the tbl_task_item, to see if a Typesetting task has been completed. In trying to do this, it multiplies the invoice_item_price by the amount of tasks within a job.

Database:

Code: [Select]
-- MySQL dump 10.11
--
-- Host: localhost    Database: dbtemp
-- ------------------------------------------------------
-- Server version 5.0.83-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbl_analysis`
--

DROP TABLE IF EXISTS `tbl_analysis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_analysis` (
  `analysis_id` int(20) unsigned NOT NULL auto_increment,
  `FK_job_id` int(20) unsigned default NULL,
  `analysis_gross` int(10) default NULL,
  `analysis_net` int(10) default NULL,
  PRIMARY KEY  (`analysis_id`),
  KEY `FK_job_id` (`FK_job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_analysis`
--

LOCK TABLES `tbl_analysis` WRITE;
/*!40000 ALTER TABLE `tbl_analysis` DISABLE KEYS */;
INSERT INTO `tbl_analysis` VALUES (1,1,100,50),(2,2,500,250);
/*!40000 ALTER TABLE `tbl_analysis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_customer`
--

DROP TABLE IF EXISTS `tbl_customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_customer` (
  `cust_id` int(20) unsigned NOT NULL auto_increment,
  `cust_name` varchar(255) default NULL,
  PRIMARY KEY  (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_customer`
--

LOCK TABLES `tbl_customer` WRITE;
/*!40000 ALTER TABLE `tbl_customer` DISABLE KEYS */;
INSERT INTO `tbl_customer` VALUES (1,'Customer A');
/*!40000 ALTER TABLE `tbl_customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_invoice`
--

DROP TABLE IF EXISTS `tbl_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_invoice` (
  `invoice_id` int(20) unsigned NOT NULL auto_increment,
  `FK_cust_id` int(20) unsigned default NULL,
  `FK_proj_id` int(20) unsigned default NULL,
  `invoice_date` date default NULL,
  `invoice_total` varchar(30) default NULL,
  `invoice_status` enum('Pending','Sent') default NULL,
  PRIMARY KEY  (`invoice_id`),
  KEY `FK_cust_id` (`FK_cust_id`),
  KEY `FK_proj_id` (`FK_proj_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_invoice`
--

LOCK TABLES `tbl_invoice` WRITE;
/*!40000 ALTER TABLE `tbl_invoice` DISABLE KEYS */;
INSERT INTO `tbl_invoice` VALUES (1,1,1,'2010-01-30','500','Sent');
/*!40000 ALTER TABLE `tbl_invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_invoice_item`
--

DROP TABLE IF EXISTS `tbl_invoice_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_invoice_item` (
  `invoice_item_id` int(20) unsigned NOT NULL auto_increment,
  `FK_job_id` int(20) unsigned default NULL,
  `FK_invoice_id` int(20) unsigned default NULL,
  `invoice_item_price` varchar(30) default NULL,
  `invoice_status` enum('Pending','Sent') default 'Pending',
  PRIMARY KEY  (`invoice_item_id`),
  KEY `FK_job_id` (`FK_job_id`),
  KEY `FK_invoice_id` (`FK_invoice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_invoice_item`
--

LOCK TABLES `tbl_invoice_item` WRITE;
/*!40000 ALTER TABLE `tbl_invoice_item` DISABLE KEYS */;
INSERT INTO `tbl_invoice_item` VALUES (1,1,1,'250','Sent'),(2,2,1,'250','Sent');
/*!40000 ALTER TABLE `tbl_invoice_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_job`
--

DROP TABLE IF EXISTS `tbl_job`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_job` (
  `job_id` int(20) unsigned NOT NULL auto_increment,
  `FK_proj_id` int(20) unsigned default NULL,
  `FK_langt_id` int(20) unsigned default NULL,
  `job_title` varchar(255) default NULL,
  `job_pages` int(10) default '1',
  `job_complete` enum('Yes','No') default 'No',
  `job_complete_date` timestamp NULL default NULL,
  PRIMARY KEY  (`job_id`),
  KEY `FK_proj_id` (`FK_proj_id`),
  KEY `FK_langt_id` (`FK_langt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_job`
--

LOCK TABLES `tbl_job` WRITE;
/*!40000 ALTER TABLE `tbl_job` DISABLE KEYS */;
INSERT INTO `tbl_job` VALUES (1,1,1,'Job 1',1,'Yes','2012-30-01 17:30:00'), (2,1,3,'Job 2',2,'Yes','2012-30-01 17:30:00');
/*!40000 ALTER TABLE `tbl_job` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_language`
--

DROP TABLE IF EXISTS `tbl_language`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_language` (
  `lang_id` int(20) unsigned NOT NULL auto_increment,
  `langname` varchar(255) default NULL,
  PRIMARY KEY  (`lang_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_language`
--

LOCK TABLES `tbl_language` WRITE;
/*!40000 ALTER TABLE `tbl_language` DISABLE KEYS */;
INSERT INTO `tbl_language` VALUES (1,'EN'),(2,'DE'),(3,'FR');
/*!40000 ALTER TABLE `tbl_language` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_project`
--

DROP TABLE IF EXISTS `tbl_project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_project` (
  `proj_id` int(20) unsigned NOT NULL auto_increment,
  `proj_title` varchar(255) default NULL,
  `FK_cust_id` int(20) unsigned default NULL,
  `FK_langsid` int(20) unsigned default NULL,
  `proj_start_date` timestamp NULL default NULL,
  `proj_end_date` timestamp NULL default NULL,
  `proj_status` enum('Open','Hold','Enquiry','Redundant','Complete') default NULL,
  PRIMARY KEY  (`proj_id`),
  KEY `FK_cust_id` (`FK_cust_id`),
  KEY `FK_langsid` (`FK_langsid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_project`
--

LOCK TABLES `tbl_project` WRITE;
/*!40000 ALTER TABLE `tbl_project` DISABLE KEYS */;
INSERT INTO `tbl_project` VALUES (1,'Project A', 1,2,'2012-01-30 09:00:00','2012-01-30 17:30:00','Complete');
/*!40000 ALTER TABLE `tbl_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_task`
--

DROP TABLE IF EXISTS `tbl_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_task` (
  `task_id` int(20) unsigned NOT NULL auto_increment,
  `task_title` varchar(50) default NULL,
  PRIMARY KEY  (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_task`
--

LOCK TABLES `tbl_task` WRITE;
/*!40000 ALTER TABLE `tbl_task` DISABLE KEYS */;
INSERT INTO `tbl_task` VALUES (1,'Preparation'),(2,'Typesetting'),(3,'Correction'),(4,'Evaluate');
/*!40000 ALTER TABLE `tbl_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_task_item`
--

DROP TABLE IF EXISTS `tbl_task_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_task_item` (
  `task_item_id` int(20) unsigned NOT NULL auto_increment,
  `FK_job_id` int(20) unsigned default NULL,
  `FK_task_id` int(20) unsigned default NULL,
  `status` enum('Pending','Ready','Sent','Active','Complete') default 'Pending',
  `task_complete_date` timestamp NULL default NULL,
  `task_order` int(20) unsigned default NULL,
  PRIMARY KEY  (`task_item_id`),
  KEY `FK_task_id` (`FK_task_id`),
  KEY `FK_job_id` (`FK_job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_task_item`
--

LOCK TABLES `tbl_task_item` WRITE;
/*!40000 ALTER TABLE `tbl_task_item` DISABLE KEYS */;
INSERT INTO `tbl_task_item` VALUES (1,1,1,'Complete','2012-01-30 10:00:00',1),(2,1,2,'Complete','2012-01-30 11:00:00',2),(3,1,3,'Complete','2012-01-30 12:00:00',3),(4,1,4,'Complete','2012-01-30 17:30:00',4),(5,2,1,'Complete','2012-01-30 10:00:00',1),(6,2,3,'Complete','2012-01-30 12:00:00',3),(7,2,4,'Complete','2012-01-30 17:30:00',4);
/*!40000 ALTER TABLE `tbl_task_item` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-01-30 18:59:47

QUERY:
Code: [Select]
SELECT DATE_FORMAT(proj_end_date, '%m') as month_number,
  MONTHNAME(proj_end_date) AS the_month,
YEAR(proj_end_date) AS the_year,
SUM(analysis_net) as analysis_net,
SUM(analysis_gross) as analysis_gross,
SUM(job_pages) as job_pages,
SUM(invoice_item_price) as total,
CASE         WHEN task_title='Typesetting'
AND ti1.status='Complete'
THEN 'Typeset'
ELSE 'Non-Typeset'
END AS 'JobType',
langname
FROM tbl_job as j
INNER JOIN tbl_task_item as ti1
ON ti1.FK_job_id = j.job_id
INNER JOIN tbl_task as t
ON t.task_id = ti1.FK_task_id
INNER JOIN tbl_invoice_item as ii
ON ii.FK_job_id = j.job_id
INNER JOIN tbl_invoice as i
ON i.invoice_id=ii.FK_invoice_id
INNER JOIN tbl_analysis as a
ON a.FK_job_id = j.job_id
INNER JOIN tbl_language as l
ON l.lang_id = j.FK_langt_id
INNER JOIN tbl_project as p
ON p.proj_id = j.FK_proj_id 
WHERE p.FK_cust_id = 1
AND proj_status='Complete'
GROUP BY the_year,
month_number,
JobType,
langname
ORDER BY the_year DESC,
month_number DESC,
JobType DESC,
langname ASC

The second problem I'm having is in presenting the results in the correct way. From my example below, you can see what I'm trying to achieve. The 'commented-out' PHP code, should 'GROUP' the JobType results, just like how the 'the_month' is working. But again, becoming a bit stuck in getting this to work too.


<table border="3" cellpadding="3" cellspacing="3">
  <tr>
    <td>Month</td>
    <td>Year</td>
    <td>JobType</td>
    <td>Analysis Net</td>
    <td>Analysis Gross</td>
    <td>Pages</td>
    <td>Invoice Total</td>
    <td>Language</td>
  </tr>
  <?php  
  $previousMonth = '';
  $previousType = '';
  do {   
  if ($previousMonth != $row_rsProjType['the_month']) {
  //if ($previousType != $row_rsProjType['JobType']) {?>
    <tr>
      <td><?php echo $row_rsProjType['the_month']; ?></td>
      <td><?php echo $row_rsProjType['the_year']; ?></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
    </tr>
    <?php $previousMonth = $row_rsProjType['the_month'];} ?>
    <tr>
      <td></td>
      <td></td>
      <td><?php echo $row_rsProjType['JobType']; ?></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
    </tr>
    <?php //$previousType = $row_rsProjType['JobType'];} ?>
    <tr>
      <td></td>
      <td></td>
      <td></td>
      <td><?php echo $row_rsProjType['analysis_net']; ?></td>
      <td><?php echo $row_rsProjType['analysis_gross']; ?></td>
      <td><?php echo $row_rsProjType['job_pages']; ?></td>
      <td><?php echo $row_rsProjType['total']; ?></td>
      <td><?php echo $row_rsProjType['langname']; ?></td>
    </tr>
    <?php } while ($row_rsProjType = mysql_fetch_assoc($rsProjType)); ?>
</table>


If anyone can help me out in getting this to display correctly, it'll be highly appreciated.

I have been trying very hard to get this script to work but I am no good at arrays...

Anyhow, the basic idea is that the script will read an RSS feed and post all that content to the database which will be used to display content on the site.

<?php

$doc = new DOMDocument();
$doc->load('http://newsrss.bbc.co.uk/rss/sportonline_uk_edition/football/rss.xml');
$arrFeeds = array();
foreach ($doc->getElementsByTagName('item') as $node) {
$itemRSS = array ( 
'title' => $node->getElementsByTagName('title')->item(0)->nodeValue,
'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue,
'link' => $node->getElementsByTagName('link')->item(0)->nodeValue,
'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue
);
array_push($arrFeeds, $itemRSS);
}

include 'dbconnect.php';

foreach ($arrFeeds as $item) {
$sql="INSERT INTO tb_rss (title, desc, link, date) VALUES ($item => title), $item => desc, $item => link, $item => date)";
if (!mysql_query($sql)){ 
die('Error: ' . mysql_error()); 
}
}
?>

Current error messege is:
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 'desc, link, date) VALUES (Array => title), Array => desc, Array => link, Array =' at line 1
Help please?

I am having a problem with my PHP/MySQL coding and I can not figure out what I am doing wrong.

I have two tables in a database. One called EmployeeInfo and another called Absence. In the Employee Info table, I have two employees, Derek and Adrian. In the Absence table, I have two records, One for Derek and Adrian.

Goal: Using PHP/MySQL, I want to call upon an employee using a form and display that person's absence. The form pulls up correctly.

If I do NOT put a WHERE clause into my SQL statement, it pulls up all the absences perfectly fine. Once I put in the WHERE = EmployeeInfo.Name = 'NameSelect' then it fails every time. Here is my SQL Coding:
$result = mysql_query("SELECT * FROM Absence LEFT JOIN EmployeeInfo ON(Absence.Account = EmployeeInfo.Account) WHERE EmployeeInfo.Name='NameSelect'");

Any help is greatly appreciated.

Umm.. Yeah, this MySQL line needs some reviewing

list($total_banned_servers) = mysql_fetch_row(mysql_query("SELECT COUNT(id) FROM `toplist` WHERE banned='1' && serverowner=". $_SESSION['user'] .""));

Hi im trying to make it get the server from the toplist data by the server owner, after that i want it to check if theres more then 1 server if there is i want it to add all the votes together and if there isnt more then 1 i want it to show the votes

<?php
$votes = mysql_query("SELECT * FROM toplist WHERE serverowner='{$_SESSION['user']}'") or die(mysql_error());
    while($vote = mysql_fetch_array($votes)) 
    {
    if(mysql_num_rows($vote) > 1 {
    //gets the server votes and adds them
    } else {
    $servervotes = $vote['votes'];
    }
echo $servervotes; ?>
    }

I want to do a mysql query that takes the last two records from two tables and combines them into one row.

So for example if I have a table called "table1" and the latest records are

id - name
35 - chris
36 - chris2
37 - chris3

and a table called "table2" where the latest records are

id - fruit
16 - banana
17 - apple
18 - pear

How can I do a query that will merge the last two rows into one so the result set would be,

id - name    /     id - fruit
37 - chris3   /     18 - pear
36 - chris2   /     17 - apple

Thanks for any help.