[PHP] RE: SOLVED! [PHP] Echoing a value

[Ed Curtis]

On Mon, 12 Jul 2004, Pablo Gosse wrote:

> Try changing:
>
> fputs($ap, $row['users.name']);
> fputs($ap, $row['users.company']);
>
> To:
>
> fputs($ap, $row['name']);
> fputs($ap, $row['company']);
>
> That should do the trick.
>
> Cheers,
> Pablo
>

That did the trick! I knew it was something simple I was overlooking.

Thanks,

Ed

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Echoing a value

[Jason Wong]

On Monday 12 July 2004 22:58, Ed Curtis wrote:
> I'm having some trouble echoing a value to a file that is being pulled
> from a MySQL database. I've included my code below I'm sure it's something
> really simple but I'm not seeing it. $row['users.name'] and
> $row['users.company'] echo nothing while $row['cnt'] echoes it's expected
> values. If anyone can tell me what I'm doing wrong I'd appreciate it.

  print_r($row)

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
Marriage is the waste-paper basket of the emotions.
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Echoing a value

[Pablo Gosse]

Ed Curtis wrote:
> I'm having some trouble echoing a value to a file that is being
> pulled from a MySQL database. I've included my code below I'm sure
> it's something really simple but I'm not seeing it.
> $row['users.name'] and $row['users.company'] echo nothing while
> $row['cnt'] echoes it's expected values. If anyone can tell me what
> I'm doing wrong I'd appreciate it. 
> 
> Thanks,
> 
> Ed
> 
> $ap = fopen("$ad_path/AdCount$issue.txt", "w");
> 
> mysql_connect ($local_host, $local_user, $local_pass);
> 
> mysql_select_db ($local_db);
> 
> $result = mysql_query ("SELECT *, COUNT(*) as cnt FROM users,
> listings WHERE listings.user_id = users.id AND listings.active = '1'
> GROUP BY users.company, users.name");  
> 
> if ($row = mysql_fetch_array($result)) {
> 
>   do {
> 
>   fputs($ap, $row['users.name']);
>   fputs($ap, $sp);
>   fputs($ap, $sp);
>   fputs($ap, $row['users.company']);
>   fputs($ap, $sp);
>   fputs($ap, $sp);
>   fputs($ap, $row['cnt']);
>   fputs($ap, $nl);
> 
>   }
> 
> while($row = mysql_fetch_array($result));
> 
> mysql_close(); }
> 
> fclose($ap);

I'm not sure about MySQL, but I know for PostgreSQL when I prefix a
field name with a table name in a query I don't need to specify the
table name when accessing that fieldname in the query result.

Try changing:

fputs($ap, $row['users.name']);
fputs($ap, $row['users.company']);

To:

fputs($ap, $row['name']);
fputs($ap, $row['company']);

That should do the trick.

Cheers,
Pablo

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Echoing a value

[Ed Curtis]

I'm having some trouble echoing a value to a file that is being pulled
from a MySQL database. I've included my code below I'm sure it's something
really simple but I'm not seeing it. $row['users.name'] and
$row['users.company'] echo nothing while $row['cnt'] echoes it's expected
values. If anyone can tell me what I'm doing wrong I'd appreciate it.

Thanks,

Ed

$ap = fopen("$ad_path/AdCount$issue.txt", "w");

mysql_connect ($local_host, $local_user, $local_pass);

mysql_select_db ($local_db);

$result = mysql_query ("SELECT *, COUNT(*) as cnt FROM users, listings
WHERE listings.user_id = users.id AND listings.active = '1' GROUP BY
users.company, users.name");

if ($row = mysql_fetch_array($result)) {

do {

fputs($ap, $row['users.name']);
fputs($ap, $sp);
fputs($ap, $sp);
fputs($ap, $row['users.company']);
fputs($ap, $sp);
fputs($ap, $sp);
fputs($ap, $row['cnt']);
fputs($ap, $nl);

}

while($row = mysql_fetch_array($result));

mysql_close(); }

fclose($ap);


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php