need help on my query

[pixeltrace]

hi,

 

i need help on fixing my query

i am getting errors on my page

http://mango.resonance.com.sg/mumcentre/qry.php

this is the current code that i have for this

<?php 

$dbhost = 'localhost';
$dbusername = 'username';
$dbpasswd = 'password';
$database_name = 'db';

	$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd") 
	or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
	or die("Couldn't select database.");


/*$qry = "SELECT `jos_muse_users`.* FROM `jos_muse_users` AS `t1`, `jos_muse_users` AS `t2`WHERE `t1`.`username` != `t2`.`email`";
$qry = mysql_query($qry);
while($row = mysql_fetch_assoc($qry)
{
print_r($row);
echo "<br />";
}*/
?>
<?
		$uSql = "SELECT * FROM jos_muse_users ORDER by MemberID";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
			?>
				  
			<?= $uRow[MemberID]?>|<?= $uRow[Email]?>
		  <?
			}    
			}
			?>

 

 

hope you could help me with this.

 

thanks!

[georg]

Are you sure, that it's a problem with your query?

 

As you can see on you site, you haven't set $dbusername to a valid database user or set a wrong password. It can't work!

[jitesh]

you given link is not able to connect to database.

[pixeltrace]

sorry please check the site again

http://mango.resonance.com.sg/mumcentre/qry.php

 

 

thanks!

[georg]

I'd put MemberID and Email in '''

 

<?php 

$dbhost = 'localhost';
$dbusername = 'username';
$dbpasswd = 'password';
$database_name = 'db';

	$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd") 
	or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
	or die("Couldn't select database.");


/*$qry = "SELECT `jos_muse_users`.* FROM `jos_muse_users` AS `t1`, `jos_muse_users` AS `t2`WHERE `t1`.`username` != `t2`.`email`";
$qry = mysql_query($qry);
while($row = mysql_fetch_assoc($qry)
{
print_r($row);
echo "<br />";
}*/
?>
<?
		$uSql = "SELECT * FROM jos_muse_users ORDER by MemberID";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
			?>
				  
			<?= $uRow['MemberID']?>|<?= $uRow['Email']?>
		  <?
			}    
			}
			?>

[jitesh]

echo your query and test in mysql.