Please help DATABASE ERROR __LINE__

[Anon]

Hi,

Can anyone please help me i keep getting this error DATABASE ERROR LINE

from this bit of code

$result = mysql_query("select bid, impavail, impmade, clicks, date from banner") or die ("DATABASE ERROR LINE");

Does anyone know the problem ?

Kind Regards
Robert

[[deleted]]

try running some like this code instead that will give you a reason for your database error:

$result = mysql_query("select bid, impavail, impmade, clicks, date from banner");
if($t = mysql_errno()) {
&nbsp;&nbsp;&nbsp;&nbsp;echo "<br>$t:". mysql_error();
}

[siwis]

Check capitalisations. Your field names MUST be EXACTLY as they are in your database, else mysql will simply bail out.

IMHO a properly formatted sql should look like this:

$result = mysql_query("SELECT bid, impavail, impmade, clicks, date FROM banner") or die ("DATABASE ERROR LINE");

[jesus_hairdo]

try changing the or die to

... or die(mysql_error());

this will give you the MySQL error.

Have you checked that the field names and table name are all correct?

[Anon]

Hello,

Thank you all for your advice and help i have fixed the problem which was simply i had forgotten caps on the SELECT FROM this was causing the error

Thanks again for helping me i am very grateful

Kind Regards
Robert King

---

url: ww.hostheaven..co.uk

email: [e-mail]