Pulling data out of MySQL

[jennides]

Hi All,

Can anybody help me with this? I continually get a "mysql_fetch_array(): supplied argument is not a valid MySQL result resource" error

$selstr = "select date_format(lastupdate, '%W %M %e, %Y %h:%i') FROM stats WHERE id='$id'";
$result = mysql_query("selstr");
$lastupdate = mysql_fetch_array($result);

echo $lastupdate['lastupdate'];

Now I do these kinds of queries all the time, except this is the first time I have used a MySQL function in the query... and I suspect that is where the problem in.

When I query MySQL directly the query works fine, I just can't get PHP to pull the variable (or should I say, give me the variable).

What am I doing wrong?

Or if you know an easier way to do what I'm trying to do with PHP (without the MySQL function) please let me know.

Thanks

[TTT]

should there be some connection variable 🙂

[jennides]

Yes, sure. I just didn't include it in the code I posted. The query IS connecting to the dbase.

[psy]

// change this:
$result = mysql_query("selstr"); 
$lastupdate = mysql_fetch_array($result); 

// to this:
$result = mysql_query($selstr); 
$lastupdate = mysql_fetch_array($result); 

if it still errors, run tests on $result, to see if it actually gets something

[jennides]

Wow, I can't believe I missed the $ in mysql_query($selstr);

but it didn't solve the problem.

[jennides]

Wow, I can't believe I missed the $ in mysql_query($selstr);

but it didn't solve the problem.

I don't know if this helps at all, but when I do this:

$selstr = "select date_format(lastupdate, '%W %M %e, %Y %h:%i') FROM stats WHERE id='$id'";
$result = mysql_query($selstr);

echo $result;

I get a "Resource ID#3" error.

And if I do this:

$selstr = "select date_format(lastupdate, '%W %M %e, %Y %h:%i') FROM stats WHERE id='$id'";
$result = mysql_query($selstr);

$lastupdate = mysql_fetch_row($result);

echo $lastupdate;

I get an "Array" error.

Any ideas what I'm doing wrong??

JeNNiDeS

[Hank]

You are trying to display an array with echo $lastupdate. If you want to display it you have to do it in a loop:

$selstr = "select date_format(lastupdate, '%W %M %e, %Y %h:%i') FROM stats WHERE id='$id'"; 
$result = mysql_query($selstr); 

while($lastupdate = mysql_fetch_array($result)){
    echo $lastupdate[0];
    //or echo $lastupdate['lastupdate'];
}