[sudhakararaog]

hi

i have an enquiry table which collects information about users
making an online travel enquiry

the fields in the table are = StoryTitle, EndCity, mode, PricedFrom,
numAdults, numChildren, numInfants

presently the select query is

<?php

$sql = SELECT Count(*) as Counts, StoryTitle, EndCity, mode,
PricedFrom, numAdults, numChildren, numInfants, ReturnLocation FROM
`enquiry` WHERE date_format(en_date,'%Y-%m-%d') BETWEEN '" .
$startDate . "' AND '" . $endDate . "' " . $enquiryText . "
Group By StoryTitle, EndCity, mode, PricedFrom, numAdults,
numChildren, numInfants, ReturnLocation
Order By Counts Desc, StoryTitle Desc, mode, PricedFrom, numAdults,
numChildren, numInfants, ReturnLocation";

while ($row_rs_newEnquiries
= mysql_fetch_assoc($rs_newEnquiries))
{
$echoStr .= "
<tr bgcolor='#ebebeb'
class='default'><td>".$row_rs_newEnquiries['Counts']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['StoryTitle']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['EndCity']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['mode']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['PricedFrom']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['numAdults']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['numChildren']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['numInfants']."</td>
<td class='default'>&nbsp; <a href=".$row_rs_newEnquiries
['ReturnLocation'].">".$row_rs_newEnquiries
['ReturnLocation']."</a></td>
</tr>";
$total = $total +
$row_rs_newEnquiries['Counts'];
}

$totalamount=$row_rs_newEnquiries['totalvalue'];

echo "value of total enquiry is $ ". $totalamount;

?>

i have used $totalamount=$row_rs_newEnquiries['totalvalue']; both
inside the while loop and outside the while loop however this is not
working.

here Counts is the column which collects the number of times an
enquiry was made to a particular city example Sydney however Counts
DOES NOT exist as a field in the table and PricedFrom collects the
value of the $ amount to a city and this field exists in the table,
so multiplying Counts and PricedFrom should give the result

is the syntax of the select query correct as there is a comma before
Count(*) & am i reading the value of this multiplied value correctly

please advice.

thanks.

[MMJ]

lol, I really don't follow.

[cristobal03]

For one, your fetch is probably failing because you're using an undeclared variable (which I think in PHP initializes to an empty string). In other words, your SELECT query string is assigned to $sql, but you're fetching $rs_newEnquiries. I'm not going to even bother trying to figure out your database structure, but if you replace all instances of $rs_newEnquiries with $sql in the above code, at least your fetch should execute properly.

I imagine the technical answer to your question is that your fetch is returning an empty array, so when you try to assign $totalamount you're pointing to a null index. Also, if you cut and pasted that code, you're missing a double-quote at the beginning of your query string. I didn't really look for other mistakes.

chris.

[Anthony:-P]

<?php

$sql = SELECT Count(*) as Counts, StoryTitle, EndCity, mode,
PricedFrom, numAdults, numChildren, numInfants, ReturnLocation FROM
`enquiry` WHERE date_format(en_date,'%Y-%m-%d') BETWEEN '" .
$startDate . "' AND '" . $endDate . "' " . $enquiryText . "
Group By StoryTitle, EndCity, mode, PricedFrom, numAdults,
numChildren, numInfants, ReturnLocation
Order By Counts Desc, StoryTitle Desc, mode, PricedFrom, numAdults,
numChildren, numInfants, ReturnLocation";

while ($row_rs_newEnquiries
= mysql_fetch_assoc($rs_newEnquiries))
{
$echoStr .= "
<tr bgcolor='#ebebeb'
class='default'><td>".$row_rs_newEnquiries['Counts']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['StoryTitle']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['EndCity']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['mode']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['PricedFrom']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['numAdults']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['numChildren']."</td>
<td
class='default'>&nbsp; ".$row_rs_newEnquiries['numInfants']."</td>
<td class='default'>&nbsp; <a href=".$row_rs_newEnquiries
['ReturnLocation'].">".$row_rs_newEnquiries
['ReturnLocation']."</a></td>
</tr>";
$total = $total +
$row_rs_newEnquiries['Counts'];
}

$totalamount=$row_rs_newEnquiries['totalvalue'];

echo "value of total enquiry is $ ". $totalamount;

?>

Hi,

You've also go $sql = SELECT, you've missed the " before SELECT.

I would be more inclined to do:

PHP Code:

$sql = mysql_query("SELECT * FROM table_name WHERE column = 'value'");
while($row = mysql_fetch_assoc($sql))
{
echo "then here you echo the rows ".$row['like_this'].", good luck!";
} 


Also, as stated by cristobal above, you're not using your actual select query, you're using an empty string.

I'd also be inclined to initialise $totalamount before the loop, just to make sure.


Kind Regards,
Anthony