Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WwWXxX, udp high ports, d-link extract firmware dsl-2750u, wwwwxxxxx.2G, yxxxcom, WWWXXX, ftp://192.168.100.100, wwwxxx 100, www.xxxcon, wwwxxx

Links

XODOX
Impressum

#1: JOIN Command Runs Fine in phpMyAdmin, but Hangs when Run in PHP?

Posted on 2007-08-18 03:08:53 by Vik Rubenfeld

I have the following join command:

> select * from metal_desc join abbrev on metal_des.ndb_no =
> abbrev.ndb_no where long_desc like 'copper' order by long_desc

I ran it in the phpMyAdmin Query window, and it ran perfectly, and came
back with the correct results.

But when I run it in PHP:

> return @mysql_query($sql, $this->conn_id);

....it seems to halt PHP execution. The next line of PHP code never runs.
It's like PHP or MySQL is hanging.

Checking the server error logs for PHP, MySQL, and Apache, shows no
errors.

When I run a Query without the join command, like this:

> select * from metal_desc where long_desc like 'copper' order by
> long_desc

....everything runs perfectly.

Does anyone have any notion what could be causing this?

Thanks very much in advance to all for any info.

Report this message

#2: Re: JOIN Command Runs Fine in phpMyAdmin, but Hangs when Run in PHP?

Posted on 2007-08-18 20:04:09 by Vik Rubenfeld

It was because the fields weren't indexed. I indexed them and it works
now.

It's odd that the exact same Join query ran immediately in phpMyAdmin
before the fields were indexed. Hmmmm......

Report this message