I have a select in a result page the WHERE LIKE isn't working? This is the query I have: CFM Code: <cfquery name="getProducts" datasource="#application.dsn"> SELECT p.product_id, p.artist, p.title, p.publisher, p.release_date, p.condition, p.price, p.category_id, c.category, p.genre_id, g.genre FROM products p LEFT JOIN categories c ON p.category_id = c.category_id LEFT JOIN genres g ON p.genre_id = g.genre_id WHERE (artist LIKE '%#Form.txtSearch#%' OR title LIKE '%#Form.txtSearch#%'
Articles similar to mySql & Coldfusion: WHERE LIKE not working:
CURDATE() date format
Hey,
I have the following SQL query but i am having trouble with it:
PHP Code:
public function selectAllPressInfoByArchiveDate(){
$sql = "SELECT *,i.ID as theID
FROM c2_raw.tbl_pressinfo i
LEFT JOIN c2_raw.tbl_press_archives c on c.ID = i.AID
WHERE i.deleted = 0 AND c.deleted = 0
mysql_num_rows() problem
PHP Code:
$result = mysqli_query($link,
'SELECT * FROM allbooks
WHERE booknumber = "' . $booknumber . '"');
if (!$result)
{
echo 'Error fetching selected title!' . mysqli_error($link);
exit();
}
$numrows = mysql_num_rows($result);
Whats wrong with this SQL query
Hi,
I have the following SQL query, which is selecting from 10 different tables..
PHP Code:
SELECT * FROM
ConfPaper c,
JournalArticle j,
EdBookChapter eb,
Thesis t,
A simple problem with my query!
Hey guys,
I am having issues pulling data from MySQL. A bit of background, I have written a small news ticker for a TV Network, which uses javascript to cycle through information in the db. Here is the code:
PHP Code:
<?php
$i = 0;
while($rs = mysql_fetch_array($rsd))
{
$title = $rs['title'];
$date = $rs['date'];
$notice = $rs['notice'];
Not sure how to write query
I have a problem, that i can't figure out, I fear I am making it more complicated than it needs to be, here it is:
I have a table
MySQL Code:
id cat_id myvalue object_id
--------------------------------
1 2 Tom 1000
2 3 Jill 1000
3 6 Sally 2000
4 2 hank 4000
else if empty
PHP Code:
<?php
$query = mysql_query("SELECT * FROM events WHERE day = '".date(N)."'");
while($array = mysql_fetch_array($query)){
?>
<table width="100%" cellpadding="3" cellspacing="1">
<tr style="background: #e9e9e9; font-weight: bold;">
<td width="40%">
Event Name
</td>
<td width="25%">
Host
SELECT Count not working as wanted
Hey everyone,
I have the following SQL query:
PHP Code:
public function selectAllProductsByCatID($catID){ $sql = "SELECT tbl_products.*, brands.brandCount FROM tbl_products INNER JOIN ( SELECT brand, count(brand) AS brandCount FROM tbl_products
Report
Email this page
Share
