Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mywebsite/public_html/index.php on line 7

[Scott Mosman]

Barry, I FIXED IT! I hope this helps someone else.

Old way...
<?php
// Connect to database
include_once "scripts/connect_to_mysql.php";
// Gather all the members for temporary display
$sql = mysql_query("SELECT 'id', 'firstname', 'lastname' FROM myMembers WHERE email_activated='1' ORDER BY id DESC LIMIT 6");

$MemberDisplayList = '<table border="0" align="center" cellpadding="6">
<tr> ';

while($row = mysql_fetch_array($sql)){

New...

<?php
// Connect to database
include_once "scripts/connect_to_mysql.php";
// Gather all the members for temporary display
$sql = mysql_query("SELECT 'id', 'firstname', 'lastname' FROM myMembers WHERE email='1' ORDER BY id DESC LIMIT 6");

$MemberDisplayList = '<table border="0" align="center" cellpadding="6">
<tr> ';

while($row = mysql_fetch_array($sql)){

I had email_activated. I took out _activated because myMembers table says email.

Thanks, Scott