PHP Code:

$sql="SELECT * FROM countries";
$result=mysql_query($sql);
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            $ccode = $row["ccode"];
            echo '<h1>'.$row["country"].'</h1>';
            
            sql2="SELECT * FROM `numbers` WHERE `location` = '".$ccode."'";
            $result2=mysql_query($sql2);
                while ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC))
                    {
                        echo '<table><tr>';
                        echo '<td><p>'.$row2["name"].'</p></td><td><a href="http://'.$row["url"].'">'.$row2["url"].'</a></td>';
                        echo '</tr></table>';    
                    }
        } 


getting an error for the line

PHP Code:

sql2="SELECT * FROM `numbers` WHERE `location` = '".$ccode."'"; 


any suggestions. the error says Parse error: parse error in C:\wamp\www\prototype1\index.php on line 42

I basically trying to make a script which will group url's depending on the country origin which is inputted by user.

You forgot the $ on sql2.

Instead of executing that query multiple times in the loop you could just build a list of 'ccodes' and select all of the rows you need at once:

SELECT * FROM numbers WHERE location IN ('value1', 'value2', 'value3');

how would I build a list of ccode's and with my current solution to my problem I am now presented with this error

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\prototype1\index.php on line 54. Line 54 is

PHP Code:

while ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) 


Originally Posted by mintuz

with my current solution to my problem I am now presented with this error

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\prototype1\index.php on line 54. Line 54 is

mysql_query returns false on an error, so there must be an error with your query.

Originally Posted by mintuz

how would I build a list of ccode's

I can't right out the code right now. Basically you just need to create an array of ccodes. One thing I try to do is gather all of my data before doing any output. When you mix your output in with the 'logic' portion of your code it makes it difficult rework your approach.

alright thanks, I got it working in the end. I basically changed my query to

PHP Code:

$sql2="SELECT * FROM `numbers` WHERE `location` = '".$ccode."'"; 


If you get time do you think you could help me with arrays, I haven't really worked with them before.