Comments by Member 10496298 (Top 6 by date)

Thanx alot... :)

I tried putting your query in my code but as I am new to this all things I dnt understand where exactly I am heading. Thanks for Help

Hey thanks a lot. Actually I am new to coding and more to add I have never ever worked with database. I am glad you helped. With this query I am trying to program in PHP as I dnt know how to test this query :(
I am pasting my code below; can you please help me with this.

ini_set('max_execution_time', 300);
require_once('connection.php');

$sql1 = "SELECT DISTINCT `start_date` FROM `urlwise_analysis_record` ORDER BY `start_date`";
$sql2 = "SELECT `prof_id` FROM `url_record` ORDER BY `url_name`";


$result1 = mysql_query($sql1);
while($row1 = mysql_fetch_array($result1))
{
$week_data[] = $row1['start_date'];
}
var_dump($week_data);

$result2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($result2))
{
$url_data[] = $row2['prof_id'];
}
var_dump($url_data);

foreach($url_data as $urls)
{
for ($j=0; $j";
for ($row=0; $row<td>".$url_data[$row]."</td>";
for ($col=0; $col".$records[$urls[$row]][$week_data[$col]]."</td>";
}
echo "</tr>";
}
echo "</table>";
?>

Sorry for the inconvenience I am creating for you.

Actually I wanted to use multidimensional array; but I dnt have much knowlege of it. I have written following code which is not giving me proper output and I dnt understand the problem.

";
for ($row=0; $row<count($url_data); $row++)
="" {
="" echo="" "&lt;tr=""><td>".$url_data[$row]."</td>";
for ($col=0; $col<count($records[$url_data[$row]]); $col++)
="" {
="" echo="" "&lt;td="">".$records[$urls[$row]][$week_data[$col]]."</td>";
}
echo "</tr>";
}
echo "</table>";
?>