•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 429,817 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,383 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 482 | Replies: 2 | Solved
![]() |
•
•
Join Date: Oct 2007
Location: Penang Island, Malaysia
Posts: 176
Reputation:
Rep Power: 1
Solved Threads: 2
mysql Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'");
Above code is not working, pls help.
"I might not be the BEST but I'm not like the REST!"
•
•
Join Date: Nov 2007
Location: Las Vegas, Nevada
Posts: 83
Reputation:
Rep Power: 1
Solved Threads: 14
•
•
•
•
mysql Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'");
Above code is not working, pls help.
the syntax of your query is ok. Something else is going on here. Can you post more code or any MySQL errors you are getting?
The End
![]() |
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
age amd avatar blue gene business chips colour database development dos economy energy enterprise environment hardware highlighting ibm ibm. news intel ibm it linux medicine memory microsoft news open source openoffice pc ps3 recession red hat remote working russia sun supercomputer supercomputing syntax technology trends ubuntu working x86
- SQL/XML Query (XML, XSLT and XPATH)
- Query seems to be crashing phpmyadmin/mysql (MySQL)
- MySQL update not working (PHP)
- MySQL INSERT not working. Why? (MySQL)
- SQL Query Syntax (MySQL)
- SQL query problem with WHERE clause (ASP)
- MySQL syntax error check for the right syntax to use near 'A (A) )' at line 1 (PHP)
- mid problem in access 2003 (Windows NT / 2000 / XP / 2003)
Other Threads in the MySQL Forum
- Previous Thread: Coursework submission system
- Next Thread: Count number of searches with with database/flat file


Linear Mode