A very strange question: the same SQL statement, in MySQL can be found in the record, but in PHP is not found
Specific as follows:
data table structure in MySQL:
SQL statements:
SELECT ID from tradedetails WHERE userName = ' John Doe ' and goodsid = ' 1 '
PHP Code:
mysql_connect ("localhost", "root", "root");mysql_query ("Set names Utf-8");mysql_select
If you upgrade MacOS Sierra when you install OPENCV, you may encounter the following error:Xxx/cap_qtkit.mm:46:9: Fatal error:' qtkit/qtkit.h ' File not found#import^1 Error generated.MAKE[2]: * * * [MODULESIDEOIO/CMAKEFILES/OPENCV_VIDEOIO.DIR/SRC/CAP_QTKIT.MM.O] Error 1MAKE[1]: * * * [Modulesideoio/cmakefiles/opencv_videoio.dir/all] Error 2Make: * * * [ALL] Error 2I found a big circle on the Internet.Never
Since Baidu released a series of "algorithm upgrade to combat the low quality site" and "on the Chain Cheat algorithm Upgrade" announcement, the SEO industry into the winter, the author has been engaged in the optimization of medical site work, this feeling quite deep.
Baidu to combat the low quality site, the author on the correction of the quality of the station article, as far as possible to do the original, each article is carefully written, and then Baidu has to fight the hyperlink cheat,
Recently monitored online logs, the website was developed by ASP. NET MVC, and many error logs were found to record the same content:The view ' Error ' or its master is not found or no view engine supports the searched locations. The following locations were searched:~/views/search/error.aspx~/views/search/error.ascx~/views/shared/error.aspx~ /views/shared/error.
The mysql master is not synchronized, and the system prompts that the record cannot be found for the update. The mysql Master/Slave
View the status of a cluster: show slave status \ G
The original library prompt is: Last_Error: Coordinator stopped because there were error (s) in the worker (s ). the most recent failure being: Worker 1 failed executing transaction '864e6992-0a34-11e7-a98a-7cd30ac6c9ec: 14840
Baidu When configuring Java environment variables in Ubuntu, after using sudo gedit/etc/profile to prifle edit,Enter in terminalsudo source/etc/profile, command not found appears in order for the profile file to change successfully.is because the user permissions are not enough, although the ordinary user has been using sudo to get the permission (here is not very understanding why, is also Baidu out of the answer, such as wrong, please correct me!) )
Good memory is not as bad as writing, write too much trouble in here to record some of the scattered small knowledge points usually seenThe 1.c language function pointer array must have the same input and output values, and the function pointer array can be defined as follows:void (*fun[256]) (void); Fun[0] = Function0; ......;Call methods are: (*fun[0]) (), can also be used fun[0] (), or even (*****fun[0]) (), which is a bad method in ANSI C popular.
Today I encountered a problem with the error ORA-02292 reported when deleting the table: violation of the complete constraints (username. constraint name)-subrecord found.
The reason is: When you delete a table that has sub-table data dependent on the table, you need to delete the record or disable the constraint. If there are many records, it is inconvenient to search. So it is best to disable the constrai
The SQL statement is correct, but the record SQL PHP cannot be found
Php code:
Running result:
The database has qualified records:
Why?
Reply to discussion (solution)
Why not echo the SQL statement of result1
Remove the double quotation marks and dots of the email and password in the mysql statement.
No code is displayed for connecting to the database!
Paste all the code.
Enclose keys in S
Public number development avoids the need to use the Mobile client program. To tell you the truth, this tool is really useful. Where the mobile debugging is really able to debug the discovery of a small problem.Especially the iphone, the most problematic. Many JS scripts are normal on a PC or Android phone. Put to iOS will be inexplicable error.A small problem was discovered today. is about the time function date. The iOS browser does not support YYYY-MM-DD conversions. It only supports the YYYY
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.