mysql php where clause not working

Question

Any ideas why this wouldnt work!?

Just nothing displays..

$result1 = mysql_query("select * from `suppliers` where supp_short_code='WED'") or die(mysql_error());
                while($row1 = mysql_fetch_array($result1))
                    {       
                        echo "<p>" . $row1['supp_name'] . "</p>";
                    }

Could you please post the output from mysql_error() so that we can see the error that is being raised. — Neil Aitken
– Neil Aitken, Commented Nov 3, 2010 at 11:07
We need more information, please show us your connection, and also a sample from your database structure as well as a few rows that can validate the data required is there. — RobertPitt
– RobertPitt, Commented Nov 3, 2010 at 11:21

benhowdle89 · Accepted Answer · 2010-11-03 11:14:41Z

2

Resolved! turns out when i imported from Excel to my mysql in brought in spaces after and before the "supp_short_code" so the query wasnt working!

answered Nov 3, 2010 at 11:14

benhowdle89

37.6k74 gold badges208 silver badges342 bronze badges

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

1 Comment

cypher Over a year ago

You can use MySQL TRIM() function for this, for example INSERT INTO myTabe (number, string) VALUES (12, TRIM(" something ")) - it will store the string without whitespaces before and after first/last characters.

MatTheCat · Accepted Answer · 2010-11-03 11:06:57Z

1

Is 'supp_name' a column of your 'suppliers' table?

Does this query return any result under phpmyadmin eg?

Are the <p> tags displayed (no rules as display:none;)?

answered Nov 3, 2010 at 11:06

MatTheCat

18.8k6 gold badges59 silver badges70 bronze badges

2 Comments

benhowdle89 Over a year ago

Weirdly this works SELECT * FROM suppliers WHERE supp_short_code LIKE '%WED%' but not "=WED" i can see the supp_short_code is definitely WED, unless its counting spaces because there might be a space after "WED " in the db!?

dnagirl Over a year ago

@user478144: that means that the exact string 'WED' is not stored in your table. You likely have some space characters. Try the query with TRIM(supp_short_code)='WED' and see what happens.

dnagirl · Accepted Answer · 2010-11-03 11:10:28Z

0

Where is your connection? If there isn't one, mysql_query() tries to make one by calling mysql_connect() with no args. It also fails if your connection doesn't have permissions for the table you're trying to read. If it's not dying but only returning no result, then check mysql_num_rows()

answered Nov 3, 2010 at 11:10

dnagirl

20.5k13 gold badges86 silver badges127 bronze badges

Comments

Conex · Accepted Answer · 2010-11-03 13:20:59Z

0

correct quotes of this line :: $result1 = mysql_query("select * from suppliers where supp_short_code='WED'") or die(mysql_error());

answered Nov 3, 2010 at 13:20

Conex

8228 silver badges18 bronze badges

Collectives™ on Stack Overflow

mysql php where clause not working

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related