mysql_fetch_array problem

[RobinTibbs]

the problem here is that the echo statements appear to echo twice, even though there is only (currently) one row in the table. any ideas? many thanks.

[code]$query = "SELECT name, version FROM browsers WHERE agentstring='$agentstring'";
    $result = mysql_query($query)
        or die ('Query failed: '.mysql_error());
       
    while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        foreach($row as $value) {
            if($bname = $value[1]) {
                echo "This string appears to be correct<br />";
            }
            else {
                echo "Something wrong here!";
            }
        }
    }[/code]

[mausie]

Why use a foreach loop within the while loop?

[paul2463]

a couple of things in your code, I agree with mausie why use two loops this may cause it to rpint out twice when you dont want it too, also when you are checking for equality you must use two == not just = as this is athe assignment character
try this for your code
[code]
<?php
$query = "SELECT name, version FROM browsers WHERE agentstring='$agentstring'";
$result = mysql_query($query) or die ('Query failed: '.mysql_error());
while($row = mysql_fetch_assoc($result))
{
    if($bname == $row['name'])
{
            echo "This string appears to be correct<br />";
        }
else
{
            echo "Something wrong here!";
        }
}
?>
[/code]