PHP - Moved: Bit Of Trouble With Join Mysql Query

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306058.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=323935.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308347.0

Hi All,

First time posting here. I've googled the problem, but can't seem to find a response that's the same.

All I want to do is have a list of id numbers and for each id number in the array, submit a MySQL query to retrieve information relating to the id number.

When I execute the code below however, I end up with only the last item in the array being printed in the echo statement.

Any clues?

Thanks,

Code: [Select]
// get array of ids
$ids = getIDs($ids);

// loop through input list
foreach ($ids as &$id) {
getVarDetails($id);
}

function getVarDetails($local)
{
$con = mysql_connect('localhost:3306', 'root', '********');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

// set database as Ensembl
mysql_select_db("Ensembl", $con);

$result = mysql_query("SELECT * FROM variations WHERE name = '$local' LIMIT 1");
$row = mysql_fetch_array($result)

while($row = mysql_fetch_array($result))
{
echo $row['name'] . " " . $row['id'];
echo "<br />";
}

// close connection
mysql_close($con);
}

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308855.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=325846.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=348309.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=315161.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=328677.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=358872.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308528.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=322237.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=328883.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=347585.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=312690.0