mysql_fetch_array problem

[MilchstrabeStern]

? Im getting this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mplionhe/public_html/phptesting/memberbands.php on line 26

However it doesnt seem to be affecting anything, besides displaying the error. Its happening on line 26 and line 26 starts at "while"

$query="SELECT * FROM symphonic LIMIT 0, 5";
$result=mysql_query($query);
 $i = 1;
while($my_info = mysql_fetch_array($result))
{
   $var = "sdate_" . $i;
   $$var = $my_info['date'];
   $var = "supdate_" . $i;
   $$var = $my_info['update'];
   $var = "slink_" . $i;
   $$var = $my_info['link'];
    $var = "sfull_" . $i;
   $$var = $my_info['full'];
   $i++;
} 

[dklynn]

Hi Milch!

I'm sure you know to

$dbcnx = @mysql_connect('host', 'user', 'pass');
and
@mysql_select_db('db')

Other than that, your code looks fine! On second thought, "LIMIT 0"? Try changing that to "LIMIT 1,5".

Regards,

DK

[vinyl-junkie]

I think it might also be fussing at some of your variable names. Change $$var to $var everywhere that occurs and see if it helps.

BTW, David, "LIMIT 0, 5" is fine like it is. PHP is one of those languages that actually starts the result set at record 0, not record 1. Weird, ain't it?

[phpster]

Try just doing this:

$result=mysql_query($query) or die(mysql_error()); 

and see what that gets ya. Better error reporting may help in debuggin this.

vinyl-junkie
The resultset is an array and arrays in PHP are 0 based unless explicitly made to start at another index. 0 is always the first row of an array

[arunkumar]

hai,
I think the problem is with you argument,
while($my_info = mysql_fetch_array($result))
{
}
i think here you are wrong
try

while($my_info = mysql_fetch_array($result,MYSQL_BOTH))
{
}
or
while($my_info = mysql_fetch_array($result,MYSQL_NUM))
{
}
refer php tutorial also
ArunKumar

[Mike]

PHP defaults to MYSQL_BOTH though, unless he's using a very old version I've never developed on

Milch, try phpster's suggestion. It sounds like the query is failing to me.

[drzoid]

hai,
I think the problem is with you argument,
while($my_info = mysql_fetch_array($result))
{
}
i think here you are wrong
try

while($my_info = mysql_fetch_array($result,MYSQL_BOTH))
{
}
or
while($my_info = mysql_fetch_array($result,MYSQL_NUM))
{
}
refer php tutorial also
ArunKumar

No, the call is okay.

[arunkumar]

Hai drzoid,

i have come across the same problem and i tried with argument i got the result,
Is there is not neccessary to give argument.
ArunKumar

[drzoid]

Hai drzoid,

i have come across the same problem and i tried with argument i got the result,
Is there is not neccessary to give argument.
ArunKumar

http://www.php.net/manual/en/functio...etch-array.php

The optional second argument result_type in mysql_fetch_array() is a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. This feature was added in PHP 3.0.7. MYSQL_BOTH is the default for this argument.

[arunkumar]

Hai drzoid,
i am using 4.2.2 is it require to give the argument compulsary,if not why got error in my program,Please tell me,Sine iam new to php.
ArunKumar

[drzoid]

Off Topic:

No, it is not

[arunkumar]

u r right drzoid,Thanks for u now i tried and learn a new thing.
ArunKumar

[dklynn]

vinyl,

Thanks, Pat, I'll go brush up on MySQL (and rethink my "afterthoughts" before posting).

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must be integer constants.

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1)

Regards,

DK

[MilchstrabeStern]

Stupidity has knocked me on my butt for the 3rd time in a row lol. I figured out after adding that piece of code that I had not created a table for the 2nd query. The code uses two queries from two different tables however i wasnt using the variables from the 2nd one yet, so I hadnt made the table. Thats what was going on. RETARDED lol.