Ad:

PHP Discussion Thread
Marked Solved
Views: 2578

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jul 13th, 2009

mysql_fetch_array Not working at all

Expand Post »

Hi,
I have this strange problem, I select some data from the database, there is no problem in the query and even when I use mysql_num_rows on the query it gives me the right number of entries in the table I'm selecting from, but when I try to echo every row it echos empty values... what is the problem??

PHP Syntax (Toggle Plain Text)
$sql = "SELECT * FROM table";
		$query = mysql_query($sql) or die(mysql_error());
		$row_number = mysql_num_rows($query);
		while ($row = mysql_fetch_array($query))
		{
			echo "row= ".$row["id"];
                         }
$sql = "SELECT * FROM table";
		$query = mysql_query($sql) or die(mysql_error());
		$row_number = mysql_num_rows($query);
		while ($row = mysql_fetch_array($query))
		{
			echo "row= ".$row["id"];
                         }

Last edited by theighost; Jul 13th, 2009 at 11:36 am.

Similar Threads

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP
MySQL update not working in PHP
Dynamic drop down list not working in JavaScript / DHTML / AJAX
Ajax script not working on firefox in JavaScript / DHTML / AJAX
Update sql not working in PHP

theighost

Reputation Points: 8

Solved Threads: 15

Junior Poster

Offline

103 posts
since Jan 2009

Permalink

Jul 13th, 2009

Re: mysql_fetch_array Not working at all

is it Giving any Erro?
what if u try this

php Syntax (Toggle Plain Text)
while ($row = mysql_fetch_array($query))
{
$id=$row['id'];
echo "row=  $id ";
 
}
while ($row = mysql_fetch_array($query))
{
$id=$row['id'];
echo "row=  $id ";

}

mrcniceguy

Reputation Points: 17

Solved Threads: 8

Posting Whiz in Training

Offline

278 posts
since Mar 2008

Permalink

Jul 13th, 2009

Re: mysql_fetch_array Not working at all

it is the same result, it writes "row=" as if the value is empty!

theighost

Reputation Points: 8

Solved Threads: 15

Junior Poster

Offline

103 posts
since Jan 2009

Permalink

Jul 13th, 2009

Re: mysql_fetch_array Not working at all

what is ur table structure,i mean the fields?

mrcniceguy

Reputation Points: 17

Solved Threads: 8

Posting Whiz in Training

Offline

278 posts
since Mar 2008

Permalink

Jul 13th, 2009

Re: mysql_fetch_array Not working at all

theighost,
Post complete source code.

Last edited by adatapost; Jul 13th, 2009 at 12:21 pm. Reason: Typo

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jul 13th, 2009

Re: mysql_fetch_array Not working at all

PHP Syntax (Toggle Plain Text)
mysql_connect('server','user','pass');
        	mysql_select_db('database');
$sql = "select * from table";
        	$query = mysql_query($sql) or die(mysql_error());
        	while($row = mysql_fetch_array($query))
        	{
        		$search_row = $row['id'];
                        echo $search_row;
             }
mysql_connect('server','user','pass');
        	mysql_select_db('database');
$sql = "select * from table";
        	$query = mysql_query($sql) or die(mysql_error());
        	while($row = mysql_fetch_array($query))
        	{
        		$search_row = $row['id'];
                        echo $search_row;
             }

theighost

Reputation Points: 8

Solved Threads: 15

Junior Poster

Offline

103 posts
since Jan 2009

Permalink

Jul 14th, 2009

Re: mysql_fetch_array Not working at all

Try changing "$row['id']" to "$row[0]" and see if you still get nothing.

Menster

Reputation Points: 49

Solved Threads: 22

Junior Poster

Offline

175 posts
since Jun 2009

Permalink

Jul 14th, 2009

Re: mysql_fetch_array Not working at all

I solved it in a really strange way guys.. wtf is this version of PHP that i'm using, that obliges me to declare the variables before using.

I just put $row=0; $search_row=0; before making the query and it worked, really strange!!!!

thanks anyway

theighost

Reputation Points: 8

Solved Threads: 15

Junior Poster

Offline

103 posts
since Jan 2009

Permalink

Jul 14th, 2009

Re: mysql_fetch_array Not working at all

Thats good you solved it. But this $row is an array. So making it 0 is a bit strange. What other thing you can do is, you can declare it as an empty array:

php Syntax (Toggle Plain Text)
$row = array();
 
$row = mysql_fetch_array();
// Proceed with rest of the code
$row = array();

$row = mysql_fetch_array();
// Proceed with rest of the code

sikka_varun

Reputation Points: 11

Solved Threads: 12

Junior Poster in Training

Offline

94 posts
since Dec 2008

Permalink

Jul 14th, 2009

Re: mysql_fetch_array Not working at all

Yes I used some arrays in my script and had to declare some of the variable as $variable = array();

theighost

Reputation Points: 8

Solved Threads: 15

Junior Poster

Offline

103 posts
since Jan 2009

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: isert the value of javascript function to database

Next Thread in PHP Forum Timeline: PHP Installation on Shared Server

DaniWeb Message

Cancel Changes

User Name
Password