[Resolved] i get "Resource id #4" when i try to echo something from a mysql db

[Fking]

this url
http://mydomain.com/test2.php?id=9999

is executing this code

<?php
 include 'partners/db.php';
 $query_r = "SELECT url FROM refs WHERE id='$id' ";
       $urls = mysql_query($query_r) or die("SQL error: ".mysql_error());
   echo "$urls";

?> 

as output i get, "Resource id #4"

when under column "url" in table "refs", on the row with id 9999, i have http://anotherurl.com/untitled.htm

why is that?

[Cambora]

You're trying to echo the array, thus giving you that message.
Just change the echo to:
echo "$urls[0]";
and it will work just fine

[dnast]

It's not even an array at that point. You have to do mysql_fetch_array or something similar to be able to echo the results.

[Cambora]

It was so obvious I missed it lol

[TheDefender]

To add to what dnast and Cambora are getting at, make this change...

<?php 
 include 'partners/db.php'; 
 $query_r = "SELECT url FROM refs WHERE id='$id' "; 
 $geturls = mysql_query($query_r) or die("SQL error: ".mysql_error()); 


// Add the following to be able to echo the results:

while($urls = mysql_fetch_array($geturls)){
  echo $urls['url']."<br />";
}
?> 

[Fking]

thank you very much

but i have one little probelm

<?php
 include 'partners/db.php';
$query_r = "select url, count(*) AS Number
from refs
WHERE id='$id'
GROUP BY url
ORDER BY Number DESC";


 $geturls = mysql_query($query_r) or die("SQL error: ".mysql_error());


// Add the following to be able to echo the results:
$a=-1;
while($urls = mysql_fetch_array($geturls, MYSQL_NUM)){
 $a++;
 echo $urls[$a];
 $a++;
 echo $urls[$a]; echo "<br>" ;

}
?>

i'm using this code to output two columns of the table,
but while, outputs only one url and one number

i tried with adding,
$b=count($urls);
for ($a=0; $a<=$b; $a++) {
echo $urls[$a];
$a++;
echo "$urls[$a] <br>";
}

but it does not output anything.......

[dcav]

I didn't test this, but i assume you don't have a table.

Direct Translation:

echo "<table>";
while($urls = mysql_fetch_array($geturls, MYSQL_NUM)){ 
 $a++;
 echo "<tr><td>$urls[$a]</td>";
 $a++;
 echo "<td>$urls[$a]</td><tr />";
}
echo "</table>";

I have no idea why you are incrementing $a
I think that you want to do this instead...

echo "<table>";
while($urls = mysql_fetch_array($geturls, MYSQL_NUM)){ 
$colA = $urls["columnA"];
$colB = $urls["columnB"];
 echo "<tr><td>$colA</td><td>$colB</td></tr>";
}
echo "</table>";

Good luck

[Fking]

Originally posted by dcav
I didn't test this, but i assume you don't have a table.

Direct Translation:

echo "<table>";
while($urls = mysql_fetch_array($geturls, MYSQL_NUM)){ 
 $a++;
 echo "<tr><td>$urls[$a]</td>";
 $a++;
 echo "<td>$urls[$a]</td><tr />";
}
echo "</table>";

I have no idea why you are incrementing $a
I think that you want to do this instead...

echo "<table>";
while($urls = mysql_fetch_array($geturls, MYSQL_NUM)){ 
$colA = $urls["columnA"];
$colB = $urls["columnB"];
 echo "<tr><td>$colA</td><td>$colB</td></tr>";
}
echo "</table>";

Good luck [/B]

works, just perfect! thanks.

[TheDefender]

FKing, You don't need the $a manipulation at all... Why not refer to the indexes by name? It makes it easier to decipher your code a year from now...

while($urls = mysql_fetch_array($geturls, MYSQL_NUM)){ 
 echo $urls['url'].$urls['Number']."<br />"; 

}

[Fking]

ops, i have one more question

now i need to select and output a row

i use this,

<?
include 'partners/db.php';
$day =  ;
 $query="SELECT u_monday, u_tuesday, u_wednesday, u_thursday, u_friday, u_saturday, u_sunday FROM hits WHERE id='$id'";
 $getuniques = mysql_query($query) or die("SQL error: ".mysql_error());

        $a=0;
 while($uniques = mysql_fetch_array($getuniques)){
 $u_monday=$uniques["u_monday"] ;
 $u_tuesday=$uniques["u_tuesday"] ;
 $u_wednesday=$uniques["u_wednesday"] ;
 $u_thursday=$uniques["u_thursday"] ;
 $u_friday=$uniques["u_friday"] ;
 $u_saturday=$uniques["u_saturday"] ;
 $u_sunday=$uniques["u_sunday"] ;

}



?>

the id is unique, so it's only one row,
i don't like this part
$u_monday=$uniques["u_monday"] ;
$u_tuesday=$uniques["u_tuesday"] ;
$u_wednesday=$uniques["u_wednesday"] ;
$u_thursday=$uniques["u_thursday"] ;
$u_friday=$uniques["u_friday"] ;
$u_saturday=$uniques["u_saturday"] ;
$u_sunday=$uniques["u_sunday"] ;

isn't better way?

p.s. TheDefender, thanks, that's what i did, it's really much better now

[dcav]

What are you trying to accomplish with all these?
$u_monday=$uniques["u_monday"] ;
$u_tuesday=$uniques["u_tuesday"] ;
$u_wednesday=$uniques["u_wednesday"] ;
$u_thursday=$uniques["u_thursday"] ;
$u_friday=$uniques["u_friday"] ;
$u_saturday=$uniques["u_saturday"] ;
$u_sunday=$uniques["u_sunday"] ;

You need to specify what you are doing with these values first before I could have an idea where to start helping you.

Since it is only 1 record, you could omit the while loop control.
i.e.

$uniques = mysql_fetch_array($getuniques);
$u_monday=$uniques["u_monday"] ;
$u_tuesday=$uniques["u_tuesday"] ;
$u_wednesday=$uniques["u_wednesday"] ;
$u_thursday=$uniques["u_thursday"] ;
$u_friday=$uniques["u_friday"] ;
$u_saturday=$uniques["u_saturday"] ;
$u_sunday=$uniques["u_sunday"] ;