Jump to content

get this error code


Huongle08
 Share

Recommended Posts

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();

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • 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.