MySQL and PHP help Needed With a Querry

[woocha]

Hey Guys....I can seem to find anything wrong with this code, can someone tell me what I am missing please?

 

<?
require('db_connect.php');
$query = "select * from merchant where merchant = $merchadmin";
$result	= "mysql_query( $query)";
if ($result){
while ($r = mysql_fetch_array($result))
{
	$siteid	= $r['site_id'];
	$email = $r['email'];
}
$wang = $r['site_id'];

echo "$wang";
echo "<br />";
echo "$merchantdir";
echo "<br />";
echo "$merchadmin";
echo "<br />";

echo date("F, d, Y @ g:iA");
echo "<br />";
//echo "$r['id']";
echo "<br />";
echo "$id";
echo "<br />";
echo "$siteid";
echo "<br />";
echo "$merch";
echo "<br />";
echo "$email";
echo "<br />";
echo "$item_numb";
}
else{
echo "its busted yo";
}
?>

Thank You

[peranha]

where are you setting $merchadmin at ?

[teng84]

$result	= "mysql_query( $query)";

 

should be

$result= mysql_query( $query);

[woocha]

its a global...that's why I have the echo statement at the bottom

echo "$merchadmin";

I also was thinking about that and echoed to the screen to make sure it was global

[woocha]

$result	= "mysql_query( $query)";

 

should be

$result= mysql_query( $query);

 

I removing the quotes and now I am getting my home brew error message "its busted yo"

[teng84]

post here the error?

[woocha]

No...I'm just not getting a $result, so the else statment executes and echos to this line runs

else{

echo "its busted yo";

}

[woocha]

Is there a way to check to connection of my file DB_connect.php?  Some sort of if no connection give a certain error or something?

[teng84]

<?
require('db_connect.php'); // also add a die on you connection 
$query = "select * from merchant where merchant = $merchadmin";
$result	= mysql_query($query) or die(mysql_query());
if ($result){
while ($r = mysql_fetch_array($result))
	{
		$siteid	= $r['site_id'];
		$email = $r['email'];
	}
$wang = $r['site_id'];

echo "$wang";
echo "<br />";
echo "$merchantdir";
echo "<br />";
echo "$merchadmin";
echo "<br />";

echo date("F, d, Y @ g:iA");
echo "<br />";
//echo "$r['id']";
echo "<br />";
echo "$id";
echo "<br />";
echo "$siteid";
echo "<br />";
echo "$merch";
echo "<br />";
echo "$email";
echo "<br />";
echo "$item_numb";
}
else{
echo "its busted yo";
}
?>

[woocha]

ok...Thank you...It must be the connection to my db, cause I ran the srcipt and got a blank white screen..

[peranha]

What is in your db_connect.php page

[teng84]

i believe you have your error reporting of because if you cant connect to db you should get some warning!!!