In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> The following query displays 0 e-mails. Why?
>
> Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37
> records with 37 equivalent usernames of which 14 show date_done=0.
>
> <?php
>
> $connection=mysql_connect("localhost","wagner","xxx") or die ("No
> connection!");
>
> $db=mysql_select_db("sbwresearch",$connection) or die ("No database!");
>
> $qry_1="select con_inf.e_mail from con_inf, scr_149 where
> scr_149.date_done=\"0\" AND con_inf.username=scr_149.username";
This looks suspicious. What type of field is date_done? If it is integer,
the value you are testing for should not be in quotes. If it is char, it
should be in single quotes. Same for username.
>
> $result_1=mysql_query($qry_1,$connection) or die ("No query # 1!");
If you still have problems, try adding before while:
if(mysql_errno()) {
echo 'Error: ' . mysql_error() . '<BR>';
}
> while ($row_1=mysql_fetch_array($result_1, MYSQL_ASSOC))
> {
> $e_mail=$row_1["e_mail"];
> echo "$e_mail\n";
> };
>
> mysql_free_result($result_1);
> mysql_close($connection);
> exit;
> ?>
>
> Thanks!
>
> Anthony F. Rodriguez
> ([EMAIL PROTECTED])
>
>
--
David Robley
Temporary Kiwi!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
