[lordmerlin]

Hi my fellow developers & coders

I run the following command, and the first row doesn't show up. The $num_domain_rows shows 4, yet the while loop only displays 3, why would this be?

PHP Code:

[color=#ffffff]$domain_result = mysql_query ("SELECT * FROM domain_accounts WHERE activated='0'") or die (print mysql_error()); 
$num_domain_rows=mysql_num_rows($domain_result);
$domain_row = mysql_fetch_array($domain_result);[/color]
[color=#ffffff]if ($num_domain_rows > 0) {  
 while($row = mysql_fetch_array($domain_result)){ 
    print 'Domain id '.$row[id].'<br>';
 }
}
[/color] 

[NeverMind]

first of all you needn't to call the results twice !!
like you fetched them here :

PHP Code:

$domain_row = mysql_fetch_array($domain_result);

$row = mysql_fetch_array($domain_result); 

it's only showing 3 results becasue you fetched the info twice !!
in first time it wasn't printed and that when you used :
$domain_row = mysql_fetch_array($domain_result);
then it's calling the next result in the loop using $row .. that's why!!
just remove the var $domain_row and it will work fine , your code after changes should look like this :

PHP Code:

$domain_result = mysql_query ("SELECT * FROM domain_accounts WHERE activated='0'") or die (print mysql_error()); 



$num_domain_rows=mysql_num_rows($domain_result);



if ($num_domain_rows > 0) {  

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

    print 'Domain id '.$row[id].'<br>';

}

} 

btw why are you using the white color ? it's not clear to read ..

[lordmerlin]

Thanx, I didn't think of that, you were a great help.

The white is only the table bacground color

Originally Posted by NeverMind

first of all you needn't to call the results twice !!

[NeverMind]

btw I figured that you have another error
you shouldn't use print inside die() !! because die will print the parameter passed to it automaticly !
so this how the first line should look :

PHP Code:

 $domain_result = mysql_query ("SELECT * FROM domain_accounts WHERE activated='0'")or die(mysql_error()); 

[lordmerlin]

Thanx for this tip as well. Now I need to update quite a few files, but this would be a breeze with dreamweaver, since I can do batch find / replaces

[dihan]

I didn't know you can do that. You can change a whole batch?

[lordmerlin]

Yup


Use the search and replace fucntion with ctrl+F, add the text to search, and the text to replace, and under "Find in", choose which files / folders to use, you can even tell it to use the whole current site, as well as wether is should look in the source or the document text, if it's in normail HTML