Problem with mysql_fetch_row() in PHP

Question

I am trying to get data from a database. I have the following code for that:

mysql_select_db($database_tony, $tony);
$query_rsTony = "SELECT `tony feature`.`text` 
                   FROM `tony feature`";

$rsTony = mysql_query($query_rsTony, $tony)) ;
if ($rsTony) echo 'set';
else echo 'not set'; 
$row_rsTony = mysql_fetch_row($rsTony)); 
if ($row_rsTony) echo 'set';
else echo 'not set';
$totalRows_rsTony = mysql_num_rows($rsTony);
$text = $row_rsTony['text'];

I am getting the output:

set not set

EDIT I added the changes said below and I have the above output. I don't know why the mysql_fetch_row($rsTony) is not working -- any ideas?

Is the query returning any rows? What does $totalRows_rsTony tell you? — timdev
– timdev, Commented Jul 15, 2011 at 16:36
As a side, I would strong suggest a better database naming convention (i.e. no spaces) and encourage the use of curly braces for all control structure blocks (i.e. if/else). — Jason McCreary
– Jason McCreary, Commented Jul 15, 2011 at 16:38
Thank you. I'll implement that. But is there anything wrong with the syntax or logic? — Brahadeesh
– Brahadeesh, Commented Jul 15, 2011 at 16:47

a1ex07 · Accepted Answer · 2011-07-15 17:00:45Z

3

You need to use result which returned by mysql_query as mysql_fetch_row parameter:

$rsTony = mysql_query($query_rsTony, $tony)) ;
if ($rsTony) echo 'set';
else echo 'not set';

UPDATE

$row_rsTony = mysql_fetch_row($rsTony)); 
if ($row_rsTony) echo 'set';
else echo 'not set';
//....

So, you final code should look like

$rsTony = mysql_query($query_rsTony, $tony)) ;
if ($rsTony) echo 'set';
else echo 'not set';
$row_rsTony = mysql_fetch_row($rsTony)); 
if ($row_rsTony) echo 'set';
else echo 'not set';

edited Jul 15, 2011 at 17:00

answered Jul 15, 2011 at 16:37

a1ex07

37.4k12 gold badges93 silver badges103 bronze badges

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

11 Comments

Brahadeesh Over a year ago

I am using the result from mysql_query as a parameter in mysql_fetch_row.

a1ex07 Over a year ago

But you set $rsTony on the top of your code. Then you execute a bunch of other queries, but don't change $rsTony, it is still a result of the very first query execution.

Brahadeesh Over a year ago

got it. thank you. but if I do if($row_rsTony) it returns false. Any idea what went wrong?

a1ex07 Over a year ago

It's still the same problem, you need to add $row_rsTony = mysql_fetch_row($rsTony); instead of (if(mysql_fetch_row($rsTony)) echo "set";).

Brahadeesh Over a year ago

Did I do what you asked me to? I am sorry. the $row_rsTony is returning false.

|

SeanCannon · Accepted Answer · 2011-07-15 16:37:06Z

0

Your query looks funny. Try this:

$query_rsTony = "SELECT text FROM feature";

answered Jul 15, 2011 at 16:37

SeanCannon

78.1k17 gold badges126 silver badges145 bronze badges

2 Comments

Álvaro González Over a year ago

His table name looks funny. The query is just fine.

Brahadeesh Over a year ago

the mysql_query works. I get the same result even if I make the change

Collectives™ on Stack Overflow

Problem with mysql_fetch_row() in PHP

2 Answers 2

11 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related