Em Andamento

php mySQL fails - but works in phpMyAdmin

I have a mysql problem that has me completely stuck:

If I run the following query in phpMyAdmin, I get 4 results:

SELECT * FROM b4ads WHERE instr(lower(comments),'erika')>0

But, if I insert the query into a .php file as the following line, I only get 3 results:

mysql_query("SELECT * FROM b4ads WHERE instr(lower(comments),'erika')>0",$dbq);

Even if I use the working phpMyAdmin results via the "create PHP" link, it does not work when I insert it into the php file (I still only get the 3 results):

$sql = 'SELECT * ';

$sql .= 'FROM `b4ads` ';

$sql .= 'WHERE instr( lower( comments ) , \'erika\' ) > 0 LIMIT 0, 30';

mysql_query($sql,$dbq);

IMPORTANT HINT:

If I Edit the excluded result in phpMyAdmin, and "Insert as a new row", the new (exact same) row DOES show in the php query.

ALSO:

The result that is not being found by the php query is one that was inserted into the table b4ads by importing from a text file via phpMyAdmin, if that makes any difference.

Any ideas?

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

php & mqsql

Habilidades: Engenharia, MySQL, Perl, PHP, Arquitetura de software, Teste de Software, Interface do usuário / AI

Ver mais: mysql gpl, line in problem, gpl mysql, i works, does it works work, Instr, erika, create php, mysql comments, php select insert sql, php insert select, mysql inserted, insert php code form, mysql select platform, php link, insert mysql table, mysql table text insert, row text php, edit table php, query text mysql, edit php executable, mysql form phpmyadmin, phpmyadmin mysql, mysql php create table form, ready php query form

Acerca do Empregador:
( 216 comentários ) San Francisco, United States

ID do Projeto: #3040410

Premiar a:

nonzerovw

See private message.

$2 USD em 14 dias
(20 Avaliações)
3.6

4 freelancers estão ofertando em média $4 para este trabalho

tyleroar

See private message.

$4.25 USD in 14 dias
(33 Comentários)
4.4
felenkavw

See private message.

$4.25 USD in 14 dias
(26 Comentários)
3.4
jagilbertvt

See private message.

$4.25 USD in 14 dias
(0 Comentários)
0.0