PHP Forum

**Sleeping Troll** · 07:24 PM

Code:

 
$SQL="SELECT * FROM PreviewText Where ProjectID = $ProjectID"; 
$result=mysql_query($SQL);
$row=mysql_fetch_array($result);
echo "$row[0], $row[1], $row[2],";

Returns: 127, 1, This is a test

Code:

 
$SQL="SELECT * FROM PreviewText Where ProjectID = $ProjectID"; 
$result=mysql_query($SQL);
while($row=mysql_fetch_array($result));
{
echo "$row[0], $row[1], $row[2],";
}

returns ,,

**NullPointer** · 09-17-2008, 10:52 PM

You have a semicolon on your while statement. Remove it:

PHP Code:


			
$query = "SELECT * FROM PreviewText Where ProjectID = $ProjectID"; 

$result = mysql_query($query);

while($row = mysql_fetch_array($result))

{

     echo "$row[0], $row[1], $row[2],";

}