|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
03-16-2006, 03:29 AM
|
#1 |
|
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.. |
|
|
|
03-16-2006, 03:41 AM
|
#2 |
|
Confirmed User
Join Date: Feb 2005
Location: Haarlem and Amsterdam, capital of the porn world ;-)
Posts: 6,496
|
just escape the number
__________________
Need adult hosting? Contact us!  WARM Hosting Need an IT solution? or someone to check your site and security? Nossie - IT Professional |
|
|
|
