sql syntax problem

Question

is there something wrong with this syntax?

 SELECT * FROM tblcustomer WHERE uName LIKE '%%' AND tMonth = '3' ORDER BY uName ASC

i got this error.. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given..

EDIT

include 'settings.php';

$con = connectDB();
$mo = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
for($mm=1;$mm<13;$mm++) {
    if(strtolower($mo[$mm-1])==strtolower(trim($_GET['uMonth']))) {
        $xyz = $mm;
        break;
    } else {
        $xyz = date("n");
    }
}
$q = "SELECT * FROM tblcustomer WHERE uName LIKE '%" . $_GET['uName'] . "%' AND tMonth = '" . $xyz . "' ORDER BY uName ASC";
//echo $q;
//exit;
$r = mysql_query($q,$con);

while($row=mysql_fetch_array($r)) {
   echo $row['uName'];
 }

Could the query be failing for some reason? Bad connection, missing table, etc. That could cause mysql_query to return FALSE instead of a handle to the results. — Tom H
– Tom H, Commented Oct 29, 2010 at 16:45

Klaus Byskov Pedersen · Accepted Answer · 2010-10-29 16:34:50Z

1

The problem is not with the sql, it's with the way you call mysql_fetch_array(). Try posting your php code too.

answered Oct 29, 2010 at 16:34

Klaus Byskov Pedersen

122k31 gold badges192 silver badges223 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Klaus Byskov Pedersen Over a year ago

@vrynxzent You should not pass your connection variable $r to the mysql_query call, according to the documentation: php.net/manual/en/function.mysql-query.php

danlefree · Accepted Answer · 2010-10-29 16:34:07Z

0

There's something wrong with your call to mysql_fetch_array(), not your query.

answered Oct 29, 2010 at 16:34

danlefree

4782 silver badges12 bronze badges

Collectives™ on Stack Overflow

sql syntax problem

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related