mysql_fetch_assoc query

[Paul75]

Hi there,

Can anyone help?

Why is the following code displaying "P1P2P3..." etc, instead of "P1 , P2, P3 ,.." etc. ?

Thanks

Paul

<!--Conect to database-->
<?php include "connects/patientconn.php"; ?>
 
<?php
 
$query = "SELECT `Patient I.D.` FROM `patient`";
 
$result = mysql_query($query);
 
while($patient = mysql_fetch_assoc($result))
{
$pt = implode(" , ", $patient);
echo $pt;
}
?>

[Rabbit]

Please use code tags when posting code.

The reason is that mysql_fetch_assoc only returns one row. Not all of them.

[Sushant29]

you have to use and looping method in it........

Since mysql_fetch_assoc is an array function of php...
it will return u a no of rows in ur tables.

using 'for loop' will be a better option for u.

[hemaldazzle]

use it:
foreach($pt as $val)
{
echo $val
}

[johny10151981]

if you dont know what would be the index of arrays then I would suggest you to use mysql_fetch_row.
here is an example of what could happen.

$Query="SELECT SUM(Price+Tax), CustomerName FROM tblsometable Group By CustomerName"

in this case it is bit confusing for SUM(Price+Tax)

but on array you would get like this:

$array['SUM(Price+Tax)'];
 

you can also fix this issue with naming the column like below:

$Query="SELECT SUM(Price+Tax) as Price, CustomerName FROM tblsometable Group By CustomerName"
 

and all in all you can use integer base indexing by calling the function mysql_fetch_row