Unjustified Error? (PHP + MySQL)

iTZKooPA

Now, obviously there is something wrong with my file but I can't figure out what it is (and neither can AceHTML Freeware's validation techniques which I have found to be useful when I couldn't debug something myself). At any rate under IE and FireFox v0.9.2 the file (linked below) doesn't show me anything, but when I open it under AceHTML's Internal browser, I get the following:

Here are all of the jokes from the database:

Error performing query on jokes:

'); } //display joketext while ( $row = mysql_fetch_array($result)) { echo ($row['joketxt'] ); } ?>

The initial line is simple HTML which should show up in the browsers no matter what, but they don't. The rest is an error stemming from:

//requesting the text from all the jokes
$result = @mysql_query('select joketxt from jokes');

if ( ! $result)
	{
	die('<p> Error performing query on jokes: </p>');
	}

But if I copy+paste "select joketxt from jokes" it does what its supposed to. Does anyone have any ideas or even how I could get the actual error mysql is showing to give me some better insight into the problem?

planetsim

Get rid of the @ on the MySQL Query

iTZKooPA

Removing the @ had no effect (although since it does mask the actual code it should have but still IE and FireFox show nothing and the internal browser also didn't change).

Weedpacket

Originally posted by iTZKooPA
Does anyone have any ideas or even how I could get the actual error mysql is showing to give me some better insight into the problem?

Well, looking at the list of [man]MySQL[/man] functions, I see one there called [man]mysql_error[/man].

iTZKooPA

Ok well I think the problem is actually elsewhere, I was just going through every peice of code to make sure that they all work (C++ debugging habit) and I found something that would definitley put a wrench in the works.

<?php
// connection to the server
$dbcnx = @mysql_connect('localhost', 'root');
if (!$dbcnx)
{
die ( 'Unable to connect to the mySQL Database.');
}
else
echo("I have connected!!@#$!");

// chose the joke database
if ( ! @mysql_select_db('work'))
	{
	die ( 'Unable to connect to the selected Database.');
	}

Neither the if nor the else are displaying so it seems that the database server isn't running correctly but when I run mysql.exe I can see everything fine, browse, edit, add and delete.