Mysql query not working properly : SELECT * FROM 'table' WHERE 'column' = 'some_string'

Question

I have problem making this to work. I wannt to select row from database and render it to list. This is my code:

<ul class = "list">
  <li>
  <?php
    $x = 'some_string';
    $title = 'title';

    $dbc = mysqli_connect('localhost', 'root', '', 'database') or die('Error connecting');
    $query = "SELECT * FROM table WHERE column ==$x ORDER BY procenat DESC LIMIT 5";
    $data = mysqli_query($dbc, $query);
  ?>
   <div id = "listdiv">
  <?php
    while ($row = mysqli_fetch_array($data)) {
  ?>
    <h4><?php echo $row[$title]; ?> </h4>
  <?php 
    }
    mysqli_close($dbc);
  ?>
   </div> </li> </ul>

I tried with LIKE '%$x%' and that didn't work as well. And i tried ... column = $x

why double equal? this is wrong, please remove `==` and try again with `=` — Sharky, May 12 '14 at 04:47
You can also just do `"SELECT * FROM table WHERE column = "+$x+"ORDER BY..."` — user2200321, May 12 '14 at 04:48
Frist, define /explain "didn't work". Second, have you tried to run the SQL directly in your console? does it work? — Jacky Cheng, May 12 '14 at 04:50
i tried with one = and that didnt work you can see that i wrote it to the end. #sharky — user3477366, May 12 '14 at 04:50
check whether your query executes correctly or not, by prinitng `mysqli_error($dbc)` — krishna, May 12 '14 at 04:54
I'm using 'table' in this question but my table name is different. But it match with table name in database if u think that is the problem. — user3477366, May 12 '14 at 04:55
@user3477366 try this `"SELECT * FROM table WHERE column ='".$x."' ORDER BY procenat DESC LIMIT 5"` use equals to for exact match and like for matching substring — Voonic, May 12 '14 at 04:58
try `LIKE $x` and wrap your string in `%%` inside variable `$x` — user2009750, May 12 '14 at 04:59
@shadow It doesnt work in both cases. I triple triple check all strings for mistake and there isn't one. I relly dont know what can it be. — user3477366, May 12 '14 at 04:59
@user3477366 Then it seems that your column does not contain that value which is contained in $x — Voonic, May 12 '14 at 05:00
Can you try to echo $query; copy the query and execute in phpmyadmin? — Marco Acierno, May 12 '14 at 05:02
try this `data = mysqli_query($dbc, $query) or die(mysqli_error($dbc));` — krishna, May 12 '14 at 05:03
You can see here that there is no problem in the solutions provided in the answer section http://sqlfiddle.com/#!2/5d62e/3 It definitely looks like either there is a syntax error which is not being shown probably because `error_reporting` might be turned off or there are no rows returned at all — asprin, May 12 '14 at 05:17
when i try it on "writecodeonline" it says Fatal error: Call to undefined function mysqli_connect() .. What that means? — user3477366, May 12 '14 at 05:26
but why is it not showing me any error? this is so frustrating — user3477366, May 12 '14 at 05:36

score 0 · Answer 1 · answered May 12 '14 at 04:47

0

You need to use single equal sign along with quotes.

    $query = "SELECT * FROM table WHERE column = '$x' ORDER BY procenat DESC LIMIT 5";

answered May 12 '14 at 04:47

Achshar

5,153
8
40
70

again not working. I dont think the problem is with query since i tried almost anything. – user3477366 May 12 '14 at 04:53
1

Then load up phpmyadmin and make sure your query executes. Once we are done with that we will know for sure that the problem is on php's side. – Achshar May 12 '14 at 04:55

score 0 · Answer 2 · answered May 12 '14 at 04:57

0

You should use LIKE operator like this

$query = "SELECT * FROM table WHERE column_name LIKE '%$x%' ORDER BY procenat DESC LIMIT 5

answered May 12 '14 at 04:57

Ramki

519
2
9

The % should be inside the query... %".$x."% – Marco Acierno May 12 '14 at 05:01
try with single quotes LIKE '%$x%' – Ramki May 12 '14 at 05:12

score 0 · Answer 3 · edited May 12 '14 at 05:22

0

Change the query line as shown below

$query = "SELECT * FROM table WHERE column = '".$x."' ORDER BY procenat DESC LIMIT 5";

edited May 12 '14 at 05:22

Mohit Jain

30,259
8
73
100

answered May 12 '14 at 05:00

Ramki

519
2
9

score 0 · Answer 4 · edited May 12 '14 at 05:45

0

There are two mistake in your query just try this one.

replace $x with '$x'
replace == with =
run your query

$x = 'some_string';

$query = "SELECT * FROM table WHERE column ='$x' ORDER BY procenat DESC LIMIT 5";

edited May 12 '14 at 05:45

slavoo

5,798
64
37
39

answered May 12 '14 at 05:25

dev4092

2,820
1
16
15

it's not that. I think problem isn't in query. – user3477366 May 12 '14 at 05:30
i see that code and run that query so i found a prob in query. – dev4092 May 12 '14 at 05:36

Mysql query not working properly : SELECT * FROM 'table' WHERE 'column' = 'some_string'

4 Answers4