The worlds going mad and taking me with it

[baffled_in_UK]

I'm going mad ! Why would this simple code..

$result = mysql_query("SELECT * FROM import",$db);
while ($myrow = mysql_fetch_array($result))  { 

give me this...

You have an error in your SQL syntax near 'Resource id #2' at line 1

[rIkLuNd]

If your connection variable is '$db', then it seems weird, otherwise not...

[baffled_in_UK]

otherwise not..

a bit tantalising that... what do you mean

[leatherback]

Hey Baffled,

Have you tried adding an @ to your query:

$result = mysql_query("SELECT * FROM import",$db);
while ($myrow =@ mysql_fetch_array($result)) {

J.

[rIkLuNd]

This is how I would have done it:

<?php

$host = "localhost";
$user = "root";
$pass = "";
$db = "database";

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

$select = mysql_select_db($db);
if(!$select)
die(mysql_error());

$result = mysql_query("SELECT * FROM import");

while ($myrow = mysql_fetch_array($result)) 
{
// your data output here
}

$close = mysql_close($link);

?>