Although the syntax is a little odd, let's go with it :
while ($result = sqlFetchObject(sqlCurrentTraces)) {
$SkyDateAss = $result ->DATEASSIGNED;
$SkyDateResult = $result ->DATEAOFRESULT;
$SkyAccNo = $result ->ACCNO;
print "<br>$SkyAccNo -- $SkyDateAss -- $SkyDateResult \n";
}
consider changing variable names $sqlCurrentTraces to $result and $result
to something like $row and it may make more sense. or at the very least,
be more "standard" also, SkyDateAss struck me as funny.
Philip
On Tue, 16 Jan 2001, Wade Halsey wrote:
> Hi
>
> Ive selected some details from a database and now want to loop through the result
>and populate a row in a table each time.
>
>
> $sqlCurrentTraces = sqlExecute( "Select * from Sky where No = '$Name'" );
> $result = sqlFetchObject( $sqlCurrentTraces );
>
> $SkyDateAss = $result ->DATEASSIGNED;
> $SkyDateResult = $result ->DATEAOFRESULT;
> $SkyAccNo = $result ->ACCNO;
>
> I want to do the stuff below:
> <tr><td> <? echo $SkyAccNo ?></td><td> <? echo $SkyDateAss ?></td><td> <? echo
>$SkyDateResult ?></td><td><input type="submit" name="UpdateDiary" value ="Update
>Diary"></td></tr>
>
> The sql qorks and the table is populated once.
>
> Help someone?
>
> Thanks
> Wade
> [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
