zero_ZX Posted September 19, 2010 Share Posted September 19, 2010 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? Link to comment https://forums.phpfreaks.com/topic/213804-need-help-with-mysql-p/ Share on other sites More sharing options...
doddsey_65 Posted September 19, 2010 Share Posted September 19, 2010 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>'; } Link to comment https://forums.phpfreaks.com/topic/213804-need-help-with-mysql-p/#findComment-1112759 Share on other sites More sharing options...
zero_ZX Posted September 19, 2010 Author Share Posted September 19, 2010 Nevermind, it didn't work as I forgot to reupload the file after i have made the changes Link to comment https://forums.phpfreaks.com/topic/213804-need-help-with-mysql-p/#findComment-1112761 Share on other sites More sharing options...
fortnox007 Posted September 19, 2010 Share Posted September 19, 2010 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."' ") ; Link to comment https://forums.phpfreaks.com/topic/213804-need-help-with-mysql-p/#findComment-1112762 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.