Problem in Serach query

[praveenkrg]

Hi,
my sql query does not work

SELECT * FROM representative where PinCode_Covered=110065
 

In PinCode_Covered column i have more than one values like
110065, 110061, 110033
and in other rows i have
110065


But it fetch only one record where 110065 exist; why other value not come in search. Any one plz help me out.

[ajos]

Hi,
my sql query does not work

SELECT * FROM representative where PinCode_Covered=110065

In PinCode_Covered column i have more than one values like
110065, 110061, 110033
and in other rows i have
110065


But it fetch only one record where 110065 exist; why other value not come in search. Any one plz help me out.

hi,
im not sure wat u mean exactly.....
r u trying to say that the result that is displayed is only for 110065
and not the rest of the values???
regards,
ajos

[praveenkrg]

hi,
im not sure wat u mean exactly.....
r u trying to say that the result that is displayed is only for 110065
and not the rest of the values???
regards,
ajos

hi ajos,

yes!
I want all the rows where PinCode_covered = 110065

[ajos]

hi ajos,

yes!
I want all the rows where PinCode_covered = 110065

firstly check how many rows are there with the above pincode u mentioned....im not exactly sure abt this....check ur query

[r035198x]

Hi,
my sql query does not work

SELECT * FROM representative where PinCode_Covered=110065

In PinCode_Covered column i have more than one values like
110065, 110061, 110033
and in other rows i have
110065


But it fetch only one record where 110065 exist; why other value not come in search. Any one plz help me out.

You have filtered your results by your where clause. Perhaps you should go through a tutorial about what where does.

Edit: Are you sure the other tables have the same value? Perhaps there are some leading or trailing spaces. What type is the PinCode_Covered column?

[praveenkrg]

You have filtered your results by your where clause. Perhaps you should go through a tutorial about what where does.

Edit: Are you sure the other tables have the same value? Perhaps there are some leading or trailing spaces. What type is the PinCode_Covered column?

I don't have too much time to search in toturial. There is no spaces. i have taken varchar datatype for PinCode_Covered column.

[r035198x]

I don't have too much time to search in toturial. There is no spaces. i have taken varchar datatype for PinCode_Covered column.

How do you know that there are no spaces, did you try the query using the TRIM function?

[praveenkrg]

How do you know that there are no spaces, did you try the query using the TRIM function?

I have not checked by TRIM function but i am describing how i stored values

----------------------------
PinCode_Covered
--------------------------
201001
-------------------------
110065, 110061, 110066
-------------------------
110065
-------------------------
110065, 110033, 110001
-------------------------

It is showing only 110065 but it has to display other column also where PinCode is 110065.

Now i think u can understand my problem better.

[r035198x]

I have not checked by TRIM function but i am describing how i stored values

----------------------------
PinCode_Covered
--------------------------
201001
-------------------------
110065, 110061, 110066
-------------------------
110065
-------------------------
110065, 110033, 110001
-------------------------

It is showing only 110065 but it has to display other column also where PinCode is 110065.

Now i think u can understand my problem better.

So you have multiple values?
Use like with %
as in

where  PinCode_Covered like '%110065%'

[praveenkrg]

So you have multiple values?
Use like with %
as in

where  PinCode_Covered like '%110065%'

Thanks buddy
It works, but when i attach the query in my php application it displays the single one again.

[r035198x]

Thanks buddy
It works, but when i attach the query in my php application it displays the single one again.

Post the code that you have changed for it.
Also make sure you saved the changes.

[praveenkrg]

Post the code that you have changed for it.
Also make sure you saved the changes.

------
The code in which i used the query as follows
-----

<?
$Pin_Code = '110065';
$result=mysql_query("SELECT * FROM tablename where PinCode_Covered LIKE '$Pin_Code'");
$num=mysql_num_rows($result);
 
while($row = mysql_fetch_array($resultbb, MYSQL_ASSOC))
{
$PinCode_Covered=$row['PinCode_Covered'];
echo "{$row['PinCode_Covered']}"; } ?>

[praveenkrg]

------
The code in which i used the query as follows
-----
<?
$Pin_Code = '110065';
$result=mysql_query("SELECT * FROM tablename where PinCode_Covered LIKE '$Pin_Code'");
$num=mysql_num_rows($result);

while($row = mysql_fetch_array($resultbb, MYSQL_ASSOC))
{
$PinCode_Covered=$row['PinCode_Covered'];
echo "{$row['PinCode_Covered']}"; } ?>

hey can u tell me why its happening and how to solve this problem?

[r035198x]

------
The code in which i used the query as follows
-----
<?
$Pin_Code = '110065';
$result=mysql_query("SELECT * FROM tablename where PinCode_Covered LIKE '$Pin_Code'");
$num=mysql_num_rows($result);

while($row = mysql_fetch_array($resultbb, MYSQL_ASSOC))
{
$PinCode_Covered=$row['PinCode_Covered'];
echo "{$row['PinCode_Covered']}"; } ?>

You forgot the two % signs.

[amitpatel66]

------
The code in which i used the query as follows
-----
<?
$Pin_Code = '110065';
$result=mysql_query("SELECT * FROM tablename where PinCode_Covered LIKE '$Pin_Code'");
$num=mysql_num_rows($result);

while($row = mysql_fetch_array($resultbb, MYSQL_ASSOC))
{
$PinCode_Covered=$row['PinCode_Covered'];
echo "{$row['PinCode_Covered']}"; } ?>

You have not given '%' for the variable $Pin_Code

Try the below code:

<?
$Pin_Code = '%110065%';
$result=mysql_query("SELECT * FROM tablename where PinCode_Covered LIKE '$Pin_Code'");
$num=mysql_num_rows($result);
 
while($row = mysql_fetch_array($resultbb, MYSQL_ASSOC))
{
$PinCode_Covered=$row['PinCode_Covered'];
echo "{$row['PinCode_Covered']}"; } ?>

[pbmods]

Amit and Praveen:
Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

Amit, this is *not* the first time you've been asked. Don't make me issue a formal warning.