GoFuckYourself.com - Adult Webmaster Forum - View Single Post

mrthumbs · 03-16-2006, 03:29 AM

Php 4 / mysql 5..

We had an application running on one machine and moved it to another server.

Now this problem occurs:
if, from php, i do a select for the name "john":

$data = mysql_query("Select * From database WHERE name='john'");

it works..

But when i use a NUMBER (lets say john5boy):

$data = mysql_query("Select * From database WHERE name='john5john'");
i get 0 results. (and yes the record IS available when i do a select with navicat or browse it with phpmyadmin).

The record is varchar.. also tried a ".x." etc..

Above select from navicat or the mysql command line tool DOES work..
it seems to be something within php..

03-16-2006, 03:29 AM
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	bizar mysql/php problem.. Php 4 / mysql 5.. We had an application running on one machine and moved it to another server. Now this problem occurs: if, from php, i do a select for the name "john": $data = mysql_query("Select * From database WHERE name='john'"); it works.. But when i use a NUMBER (lets say john5boy): $data = mysql_query("Select * From database WHERE name='john5john'"); i get 0 results. (and yes the record IS available when i do a select with navicat or browse it with phpmyadmin). The record is varchar.. also tried a ".x." etc.. Above select from navicat or the mysql command line tool DOES work.. it seems to be something within php..