Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

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


Liquid Web Cloud VPS Hosting

8,357 questions

11,608 answers

573 users

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

informit.com | the trusted technology learning source - 6,633 eBook | InformIT eBook Store


184 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
...