i'm trying to run with 2 "while" loops over 2 different SQL tables

Question

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\public_html\mars\TaskC\hitUrl.php on line 148

$query  = "SELECT url FROM urls";
$tableQuery = mysql_query($query);


while($row = mysql_fetch_array($tableQuery)){
    $newQuery="SELECT urls,date FROM urls_info WHERE url='{$row['url']}'";
    $newTableQuery=mysql_query($newQuery);

    $newGroupedQuery = $newQuery . "GROUP BY date";

    while($newRow = mysql_fetch_array($newTableQuery)){
        $displayStr .=    "<tr>";
        $displayStr .=    "<td>".$newRow['date']."</td>";
        $displayStr .=    "<td>".$newRow['url']."</td>";
        $displayStr .=    "<td>".num_rows($newQuery)."</td>";
        $displayStr .=    "</tr>";   
    }


}

Why don't you just do a single query with a join? – Tremmors Jul 27 '11 at 13:42 — Tremmors, Jul 27 '11 at 13:42

score 1 · Answer 1 · answered Jul 27 '11 at 13:42

1

this seems like the mysql_query is failing, try putting something like this

$tableQuery = mysql_query($query) or die("Query failed with error: ".mysql_error());

And an SQL join is more native to do, and more performance oriented.

answered Jul 27 '11 at 13:42

fatnjazzy

5,840
11
54
82

score 0 · Answer 2 · answered Jul 27 '11 at 13:46

0

Always natively join:

$newQuery="SELECT urls,date FROM urls_info as info INNER JOIN urls ON info.url = urls.url";

answered Jul 27 '11 at 13:46

Martijn

11,598
10
47
95

i'm trying to run with 2 "while" loops over 2 different SQL tables

2 Answers2