Problem with mysql_fetch_array

fadinha

Hey, I've have a problem with printing the details from database, it's giving an error message (Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\WEBSITE\pages\tapahtumat.php on line 47) in both scripts below. I'd appreciate if someone could tell me what is really wrong, i've been trying to figure this out several days now. And it's getting on my nerves :quiet:

		<?php
		$get_events = "SELECT * FROM tapahtumat";
		$result_events = mysql_query($get_events);
		echo"<table cellpadding=\"0\" cellspacing=\"0\">";
		while($row_events = mysql_fetch_array($result_events))
		{
		echo"		<tr><td class=\"sininenbold\">MESSUT:</td>
					<td>".$row_events['tapahtumanimi'].",".$row_events['paikka'].",".$row_events['aika']."</td></tr>";
		}
		echo"</table>";


	echo"<h3>DOLPHIN mukana seuraavissa medioissa:</h3>";
	$get_links = "SELECT * FROM linkit";
	$result_links = mysql_query($get_links);
	while($row_links = mysql_fetch_array($result_links))
	{
		echo"<a href=\"".$row_links['linkki']."\">".$row_links['linkkinimi']."</a></br>";
		}

	?>

bretticus

Probably an error in your SQL SELECT statments. How 'bout adding die with error messages.

$result_events = mysql_query($get_events) or die('Invalid Query');

and...

$result_links = mysql_query($get_links) or die('Invalid Query');

fadinha

Now it gives the 'Invalid Query' message.

So there's something wrong with the sql query...but what?

Weedpacket

Use [man]mysql_error()[/man] instead of "Invalid Query" to see what error message is given.

fadinha

Well now the error message is : No database selected.

Im using the include to bring the db connetion details, the db.php looks like this:

<?php
//skip the config file if somebody call it from the browser.
if (stristr($_SERVER['PHP_SELF'], "db.php")) {
    Header("Location: ../index.html");
    die();
}

define('SQL_USER', 'root');
define('SQL_PASS', '');
define('SQL_DB', 'dolphin'); 
// Create a link to the database server
$link = mysql_connect('localhost', SQL_USER, SQL_PASS);
if(!$link) :
   die('Could not connect: ' . mysql_error());
endif;
// Select a database where our member tables are stored
$db = mysql_select_db(SQL_DB, $link);
if(!$db) :
   die ('Can\'t connect to database : ' . mysql_error());
endif;
?>

madwormer2

Try specifying for it to use the database that you've selected previously with

mysql_query($get_links, $db);

If that doesn't work, var_dump($db) to see if it's carrying through to your script.