[Resolved] Do I really need to connect twice?

[flinginarrows]

I'm sure there is a way to code this so I dont have to connect twice. Any ideas?

//Connect for first query
$result = mysql_query("SELECT * FROM links WHERE state = '$state' ORDER BY link_name");
while($row = mysql_fetch_array($result))
{
echo "<a href=".$row['url'].">".$row['link_name']."</a><br>\n";
}

//Connect for second query
$result = mysql_query("SELECT * FROM links WHERE state = '$other' ORDER BY link_name");
while($row = mysql_fetch_array($result))
{

//Change "all_states" to Alabama
$row['state']="al";

echo "<a href=".$row['url'].$row['state'].">".$row['link_name']."</a><br>\n";
}

[planetsim]

When you have connected once during a webpage if you havent disconnected from the database you should be able to have as many queries as you like.

e.g.

mysql_connect('host','user','pass');
mysql_select_db('db');

$query1=mysql_query("SELECT * FROM users");

//query2 notice its not connecting again.
$query2=mysql_query("SELECT * FROM names");

[tekky]

if you read his code he isnt connecting twice, simply querying twice....

//Connect for first query 
$result = mysql_query("SELECT * FROM links WHERE state = '$state' ORDER BY link_name"); 
while($row = mysql_fetch_array($result)) 
{ 
    echo "<a href=".$row['url'].">".$row['link_name']."</a><br>\n"; 
$row['state'] = 'al';
$storedrow[] = $row
} 


//Connect for second query 
foreach($storedrow as $row)
{ 
    echo "<a href=".$row['url'].$row['state'].">".$row['link_name']."</a><br>\n"; 
}

that would do it...

[Moonglobe]

i think you're confusing connecting with querying.

[flinginarrows]

My bad. I was thinking that because I was going back to the database that I was reconnecting. Obviously I am only calling my connect function once. Is there a more efficient way to do this or is this way acceptable?

[Moonglobe]

there is a MUCH better way if you're using the same result set - [man]mysql_data_seek/man as in

mysql_data_seek($recordset, 0);

[Weedpacket]

Or run the query once, read all of the records into an array, and then loop through that array twice.