PHP MySQL Select Statement Error

Question

I'm new to MySQL and PHP and am having trouble with this code. Please do tell me where I am going wrong:

Here's the code:

<?php

include('connection.php');

$num1  = '1';
$num2  = '2';

// Get all the data from the  table

$sql = mysql_query("SELECT * FROM table1 WHERE num1 = '$num1' AND num2 = '$num2'");

$row = mysql_fetch_assoc($sql) or die("No rows returned by query");

while ($row = mysql_fetch_assoc($sql)) {
echo $row["num1"];
echo '</br>';
echo $row["num2"];
echo '</br>';
}

?>

If I change

$sql = mysql_query("SELECT * FROM table1 WHERE num1 = '$num1' AND num2 = '$num2'");

to

$sql = mysql_query("SELECT * FROM table1 WHERE num1 > '$num1' AND num2 > '$num2'");

it works. It doesn't work with the equal sign although there are records that should be printed out.

Thank you for your time.

Please show the schema and (relevant) content of your table1 table. — eggyal
– eggyal, Commented May 11, 2012 at 6:24
Is there an error or just no result? If there is an error, show us the error message please — Tobias
– Tobias, Commented May 11, 2012 at 6:25
What are the values of the returned rows if you change the query? — DKSan
– DKSan, Commented May 11, 2012 at 6:25
I don't believe the quotes are your problem, unless I'm missing something? For instance I can run SELECT * FROM orders WHERE order_id = '81837' AND customer_id = '13'; in a database where both those fields are INTs and it works fine. Can you provide you SCHEMA and any error messages/returned values? — LeonardChallis
– LeonardChallis, Commented May 11, 2012 at 6:29
@DKSan If I change the equal sign to greater than I get the results. There are only 5 records now, just numbers between 1 and 10 in all fields. — Theron
– Theron, Commented May 11, 2012 at 7:04

shivgre · Accepted Answer · 2012-05-11 07:07:13Z

1

your problem is you are fetching the results twice, so remove the fetch statement outside the while loop**($row = mysql_fetch_assoc($sql) or die("No rows returned by query");)** and it should work. Please update if this works.

answered May 11, 2012 at 7:07

shivgre

1,1732 gold badges13 silver badges29 bronze badges

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

Comments

rjv · Accepted Answer · 2012-05-11 06:33:23Z

1

Since you are comparing numbers,try using them without quotes.

SELECT * FROM table1 WHERE num1=$num1 AND num2=$num2

edited May 11, 2012 at 6:33

answered May 11, 2012 at 6:26

rjv

6,9365 gold badges31 silver badges53 bronze badges

1 Comment

Theron Over a year ago

Wouter Dorgelo · Accepted Answer · 2012-07-16 01:55:41Z

1

Try again

SELECT * FROM table1 WHERE num1 = $num1 AND num2 = $num2

edited Jul 16, 2012 at 1:55

Wouter Dorgelo

12.1k12 gold badges67 silver badges80 bronze badges

answered May 11, 2012 at 6:24

Tiago Peczenyj

4,6712 gold badges24 silver badges36 bronze badges

1 Comment

Tiago Peczenyj Over a year ago

in any database? or I need to turn on some option?

Collectives™ on Stack Overflow

PHP MySQL Select Statement Error

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related