Need help with mysql :p

[zero_ZX]

Hi, I have this code:

$id = $_GET['id'];

$query = mysql_query("SELECT * FROM bestillinger WHERE id = '".$id."' ") 

     
 $row = mysql_fetch_array($query);

$result = mysql_query("SELECT * FROM fakture WHERE kunde= '".$row['anmoder']."' AND betalt = '0' AND rykker = '3'");

if(mysql_num_rows($result)>0)
{

echo'
<div class="response-msg error ui-corner-all">
						<span>Meddelelse</span>
						Denne kunde har i øjeblikket en eller flere ubetalte faktura på rykker 3
					</div>	';

}

 

So basically I run a query and if it finds something it echoes the message.

Only problem is that the message doesn't appear :/

 

Can any one tell me what I have done wrong?

[doddsey_65]

im no expert but try:

 

$id = $_GET['id'];

$query = mysql_query("SELECT * FROM bestillinger WHERE id = '".$id."' ") 
$row = mysql_fetch_array($query);

$query= mysql_query("SELECT * FROM fakture WHERE kunde= '".$row['anmoder']."' AND betalt = '0' AND rykker = '3'");

$result = mysql_num_rows($query);

if ($result >= 1)
{
echo'
<div class="response-msg error ui-corner-all">
<span>Meddelelse</span>
Denne kunde har i øjeblikket en eller flere ubetalte faktura på rykker 3
</div>';

}

[zero_ZX]

Nevermind, it didn't work as I forgot to reupload the file after i have made the changes

[fortnox007]

I think you want to use join or atleast 1 query.

But you also miss a semicolon in

$query = mysql_query("SELECT * FROM bestillinger WHERE id = '".$id."' ") 

it should be

$query = mysql_query("SELECT * FROM bestillinger WHERE id = '".$id."' ") ;