What Is The Proper Way?

ChompGator

Hey

Alls Im trying to do is get my script to list all the email addresses from my database - but I keep getting this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\hosting\member\aiim\affiliates\email.php on line 6

The code is below, any tips on how to fix it - I see no problems with line 6 🙁

<?php
$con = mysql_connect("","","****") or die('Could not connect: ' . mysql_error());
mysql_select_db("subscribe", $con);

$result = mysql_query("SELECT * FROM subscribe");
while($row = mysql_fetch_assoc($result)){
$row['email'];
}
?>

Wales

ChompGator wrote:
Hey

Alls Im trying to do is get my script to list all the email addresses from my database - but I keep getting this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\hosting\member\aiim\affiliates\email.php on line 6

The code is below, any tips on how to fix it - I see no problems with line 6 🙁

<?php
$con = mysql_connect("","","****") or die('Could not connect: ' . mysql_error());
mysql_select_db("subscribe", $con);

$result = mysql_query("SELECT * FROM subscribe");
while($row = mysql_fetch_assoc($result)){
$row['email'];
}
?>

Try this

if ($r = mysql_query ($result)) {
while ($row = mysql_fetch_array ($r)) {
echo $row['email'];
}
}

Replace the above with your

while($row = mysql_fetch_assoc($result)){
$row['email'];
}

ChompGator

So make it look like this?

<?php
$con = mysql_connect("","","***") or die('Could not connect: ' . mysql_error());
mysql_select_db("subscribe", $con);

if ($r = mysql_query ($result)) {
while ($row = mysql_fetch_array ($r)) {
echo $row['email'];
}
$result = mysql_query("SELECT * FROM subscribe");
while($row = mysql_fetch_assoc($result)){
$row['email'];
}
?>

Wales

<?php
$con = mysql_connect("**","**","***") or die('Could not connect: ' . mysql_error());
mysql_select_db("subscribe", $con);

$result = mysql_query("SELECT * FROM subscribe");

if ($r = mysql_query ($result)) {
while ($row = mysql_fetch_array ($r)) {
echo $row['email'];
}
}
?>

ChompGator

Ok, no errors now, but now its just displaying a blank white page - Do you know why that is?

Weedpacket

$result = mysql_query("SELECT * FROM subscribe");

if ($r = mysql_query ($result)) {

Because mysql_query() expects a string, and in the second one you're passing it a MySQL result set (apparently an invalid one because it errors when you try to get any records out of it).

Let's add a little more debugging to your original code:

$con = mysql_connect("***","***","****") or die('Could not connect: ' . mysql_error());
mysql_select_db("subscribe", $con) or die('Could not select the database: '.mysql_error());

$result = mysql_query("SELECT * FROM subscribe") or die('Could run that query: '.mysql_error());
while($row = mysql_fetch_assoc($result)){
$row['email'];
}

Just checking something: you have a database named "subscribe" that contains a table named "subscribe"?