Jump to content

Huongle08

New Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Huongle08

  • Rank
    Newbie
  1. Fairly new to PHP and have the following code which should simply output into 3 columns - I have checked the query which does work - so I dont understand why I get this error mysql_fetch_array() expects parameter 1 to be resource, // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = “SELECT * FROM duration_matched WHERE groupm = '”.$coincidence ."’"; $result = $conn->query($sql); // set up loop counter $col_count = 0; // start table and first tr echo ‘ ’; while ($row=mysql_fetch_array($result)) { // if you have output 3 cols then end tr and start a new one if ($col_count == 3) { echo ‘ ’; // and reset the col count $col_count = 0; } // always output the td echo ‘ ’; // and count the column $col_count++; } // then close off the last row and the table echo ‘ ’ . $row[‘image’] . ‘ ’; $conn->close();
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.