techker Posted April 22, 2008 Share Posted April 22, 2008 hey guys i was woundering if any body can point me in the right direction. so i have a database that store information of clients like when orders done in the shopping cart.so i recently made a box on the front page saying the last date the client ordered in the shopping cart. but he probleme im having is when there is nothing in there it gives no matches ..but the hole page gets messt up,even if i made it an include.. here is the page that hase the query (the include page) <?php // Connects to your Database mysql_connect("localhost", "kk", "hhh") or die(mysql_error()); mysql_select_db("hhh") or die(mysql_error());?> <?php $QQQ1 = mysql_query("SELECT c.NoCommande AS NoCommande, d.Quantite AS Quantite, c.UName AS Usager, c.DateCommande AS Date, p.SkuFabriquant AS Sku, p.DescriptionCourte AS NomProduit FROM tblCommande AS c LEFT JOIN ( tblCommandeDetail AS d CROSS JOIN tblProduits AS p ) ON ( p.IDProduit = d.IDProduit AND d.NoCommande = c.NoCommande ) WHERE c.UName = '$USERNAME' ORDER BY Date LIMIT 1 , 1 "); if(!$QQQ1) die(mysql_error()); $err = mysql_num_rows($QQQ1); if($err == 0) die("No matches met your criteria.");?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- .echo2 { color: 000000; text-decoration: none; } --> </style> </head> <body> <?php while ($info=mysql_fetch_array($QQQ1)) { echo "</b><br> </i>"; echo "<span class='echo2'>".$info['Date']."</span>"; } ?> </body> </html> so it only put the last date.in the box i made.i don't know if im clear lol Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/ Share on other sites More sharing options...
phpSensei Posted April 22, 2008 Share Posted April 22, 2008 try <?php $QQQ1 = mysql_query("SELECT c.NoCommande AS NoCommande, d.Quantite AS Quantite, c.UName AS Usager, c.DateCommande AS Date, p.SkuFabriquant AS Sku, p.DescriptionCourte AS NomProduit FROM tblCommande AS c LEFT JOIN ( tblCommandeDetail AS d CROSS JOIN tblProduits AS p ) ON ( p.IDProduit = d.IDProduit AND d.NoCommande = c.NoCommande ) WHERE c.UName = '$USERNAME' ORDER BY Date LIMIT 1 , 1 "); if(!$QQQ1){ $err = mysql_num_rows($QQQ1); } if($err == 0){ die("No matches met your criteria."); }?> Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524490 Share on other sites More sharing options...
techker Posted April 22, 2008 Author Share Posted April 22, 2008 it gives me a blanc page?thx! Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524499 Share on other sites More sharing options...
phpSensei Posted April 22, 2008 Share Posted April 22, 2008 Remove all of your "or die(mysql_error())" and "die(error....)" Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524513 Share on other sites More sharing options...
techker Posted April 22, 2008 Author Share Posted April 22, 2008 you mean in my connection?if so it does the same. Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524524 Share on other sites More sharing options...
phpSensei Posted April 22, 2008 Share Posted April 22, 2008 Then your php has an error which you do not see. try error_reporting(E_ALL) Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524527 Share on other sites More sharing options...
techker Posted April 22, 2008 Author Share Posted April 22, 2008 were do i put that? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524530 Share on other sites More sharing options...
phpSensei Posted April 22, 2008 Share Posted April 22, 2008 top of the page. Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524534 Share on other sites More sharing options...
techker Posted April 22, 2008 Author Share Posted April 22, 2008 i put it in the top ? error_reporting(E_ALL) ?> and it still gives me a blanc? i know the page is good cause i have an echo user name and i see it Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524537 Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 Well, let's see $QQQ1. What makes you think there are matching rows? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524811 Share on other sites More sharing options...
techker Posted April 23, 2008 Author Share Posted April 23, 2008 puzzled? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524820 Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 puzzled? Echo $QQQ1. Have you run this query from the CLI or phpmyadmin? Perhaps it's correct. Also, why the cross join? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-524843 Share on other sites More sharing options...
techker Posted April 23, 2008 Author Share Posted April 23, 2008 it was working perfectly.they only thing is when ia new user joined it mess t up my front page cause he had no orders in the catalogue. Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-525553 Share on other sites More sharing options...
fenway Posted April 24, 2008 Share Posted April 24, 2008 Then you need a LEFT JOIN. Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-526035 Share on other sites More sharing options...
techker Posted April 24, 2008 Author Share Posted April 24, 2008 SELECT c.NoCommande AS NoCommande, d.Quantite AS Quantite, c.UName AS Usager, c.DateCommande AS Date, p.SkuFabriquant AS Sku, p.DescriptionCourte AS NomProduit FROM tblCommande AS c LEFT JOIN ( tblCommandeDetail AS d CROSS JOIN tblProduits AS p ) ON ( p.IDProduit = d.IDProduit AND d.NoCommande = c.NoCommande ) WHERE c.UName = '$USERNAME' ORDER BY Date LIMIT 1 , 1 "); it is there? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-526636 Share on other sites More sharing options...
fenway Posted April 25, 2008 Share Posted April 25, 2008 I'm sorry, I thought there was a problem with the sql... maybe it the PHP code that's wrong... does the page work without tha twhile loop? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-527020 Share on other sites More sharing options...
techker Posted April 25, 2008 Author Share Posted April 25, 2008 could it be the limit 1.1 cause it grabs only the last query? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-527423 Share on other sites More sharing options...
fenway Posted April 26, 2008 Share Posted April 26, 2008 We're going in circles here... you currently have a blank page, right? Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-527696 Share on other sites More sharing options...
techker Posted April 27, 2008 Author Share Posted April 27, 2008 yes.it does not show anything. Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-528245 Share on other sites More sharing options...
fenway Posted April 28, 2008 Share Posted April 28, 2008 So comment out all of the php code until it doesn't. Start with the query and anything downstream... just leave the DB connect. Link to comment https://forums.phpfreaks.com/topic/102422-error-if-nothing-in-database/#findComment-528824 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.