Jump to content

Need help with mysql :p


zero_ZX

Recommended Posts

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? :P

Link to comment
https://forums.phpfreaks.com/topic/213804-need-help-with-mysql-p/
Share on other sites

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>';

}

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."' ") ;

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.