Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. I check, compile and run every program. Contact me at: aviboots(AT)netvision.net.il
Hostgator 1 Penny

BlueHost Web Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

getflywheel wordpress hosting


Distribute your Resume to 500+ Job Boards & Recruiters


6,849 questions

9,751 answers

573 users

How to go through mysql result twice, read records again from the beginning in PHP

Anker Quick Charge 3.0 63W 5-Port USB Wall Charger, PowerPort Speed 5 for Galaxy S7/S6/Edge/Plus, Note 5/4 and PowerIQ for iPhone X / 8 / 7 / 6s / Plus, iPad Pro/Air 2/mini, LG, Nexus, HTC


181 views
asked Nov 1, 2014 by avibootz
retagged Jun 7, 2015 by avibootz

2 Answers

0 votes
$sql = "SELECT * FROM your_table"
$result = mysql_query($sql, $con);
if ( ! $result ) die("Line: " . __LINE__  . " Error: ". mysql_error());

while($row = mysql_fetch_assoc($result))
{
    // write your code here
}

mysql_data_seek($result, 0); // start again from the beginning
                
while($row = mysql_fetch_assoc($result))
{
    // write your code here
}

mysql_free_result($result);  
mysql_close($con);



answered Nov 1, 2014 by avibootz
edited Feb 22, 2015 by avibootz
0 votes
$db_host = 'localhost';
$db_user = 'user';
$db_password = 'password';
$db_name = 'database_name';
 
try
{
    $con = new PDO("mysql:host=".$db_host.";dbname=".$db_name, $db_user, $db_password);
}
catch(PDOException $e)
{
    echo "Connection failed: " . $e->getMessage();
}

$sql = "SELECT *
        FROM topics
        WHERE user_id = :userid";
try 
{
    $result = $con->prepare($sql);
    $result->bindParam(':userid', $_SESSION['user-id'], PDO::PARAM_INT);
    $result->execute();
    
    $rows = $result->fetchAll();

    foreach ($rows as $r) 
          echo $r['topic'] . "<br />";
                                    
	echo "<br />"    ;
    
	foreach ($rows as $r) 
          echo $r['topic'] . "<br />";
}
catch (PDOException $e) 
{
    echo "SQL failed: " . $e->getMessage();
}

/*
run:

C Programming
PHP Programming

C Programming
PHP Programming

*/

 




answered Jun 7, 2015 by avibootz
edited Jun 7, 2015 by avibootz
...