mkr365

This ois the error± You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', '7 AND groepen.Groepnaam = 'Architect' GROUP BY Bedrijfsnaam ORDER BY Bedrijf' at line 1 And this the query± if($_GET['categorien'] != "") $sql = "SELECT * FROM klantgegevens INNER JOIN rubrieken ON klantgegevens.Rubriek = rubrieken.RubriekID INNER JOIN groepen on rubrieken.GroepID = groepen.GroepID WHERE ".$bedrijfsnaam." ".$provincie." AND Rubriek = ".$categorien." AND groepen.Groepnaam = 'Architect' GROUP BY Bedrijfsnaam ORDER BY Bedrijfsnaam LIMIT ".($page*$numresults).", ".$numresults." "; I forgot to mention that it only goes wrong if i do a search with more than 1 categories. If i search on 2 categories together with an provincie than i get this error

provincie is an default value wich is set. If i delete that part i receive the same syntax error

Can anybody see something wrong with this code, cause i get an error on this query. i really can't find it $sql = "SELECT * FROM klantgegevens INNER JOIN rubrieken ON klantgegevens.Rubriek = rubrieken.RubriekID INNER JOIN groepen on rubrieken.GroepID = groepen.GroepID WHERE ".$bedrijfsnaam." ".$provincie." AND Rubriek = ".$categorien." AND groepen.Groepnaam = 'Architect' GROUP BY Bedrijfsnaam ORDER BY Bedrijfsnaam LIMIT ".($page*$numresults).", ".$numresults." ";

Hello, I have the next problem: I have a site where you can press a 'letter' (for example 'a') and it wil show you the company names starting with an 'a'. It will show you 15 results and if it is more than 15, the next results should be on page 2. The problem is that it wil only show the first 15 results while i have more then 15 company names starting with an 'a'. $numpages = ceil($count/$numresults); if (isset($_GET['page'])) $page = $_GET['page']; else $page = 0; for ($i = 0; $i<$numpages; $i++) { echo '<a href="architecten.php?zoekletter='.$_GET['zoekletter'].'page='.$i.'">pag '.($i+1).'</a> || '; } echo '<br><br>'; My error logging shows the following: PHP Notice: Undefined variable: count. Can somebody help me with this issue?

Well not really, i will give you an example: This is how it show up right now: company1 company2 company3 etc And i want it like this company1 company2 company3 company4 etc

Well i dont think its that simple. Let me explain the situation a little bit more. I have in my database lets say several companies, now if you do a search for example on the fist letter of a company on my site i want that output in 2 rows. At the moment the output shows up in 1 row with a maximum result of 15 companies, everything above the 15 shows up on the next page.

Hi, My output shows up in a table with just 1 row, is it possible that my output shows up in a table with 2 rows? I'm not sure where to start A little help would be great! <?php include("test.php"); echo '<div id="content">'; if (isset($_GET['zoekletter']) || isset($_GET['zoek'])) { if (isset($_GET['zoekletter'])) { echo 'gezocht op letter '.$_GET['zoekletter'].'<br><br>'; $sql = "SELECT * FROM klantgegevens INNER JOIN rubrieken ON klantgegevens.Rubriek = rubrieken.RubriekID INNER JOIN groepen on rubrieken.GroepID = groepen.GroepID WHERE Bedrijfsnaam LIKE '".$_GET['zoekletter']."%' AND groepen.Groepnaam = 'Architect' GROUP BY Bedrijfsnaam ORDER BY Bedrijfsnaam "; $result = mysql_query($sql) or die(mysql_error()); $query = mysql_num_rows($result); if ($query > 0) { if ($query < 15) { while($query = mysql_fetch_array($result)) { $check = url_exists($server.'logos/'.$query['Portfolio'].'.jpg'); if ($check == true) $imageurl = 'logos/'.$query['Portfolio'].'.jpg'; else $imageurl = $default; echo '<table bgcolor="#ffffff" class="border1" onclick=window.open("http://www.test.nl/'.$query['Portfolio'].'") style="cursor:pointer" onmouseover=style.borderColor="#000000" onmouseout=style.borderColor="#ffffff" width="100%"><tr><td width="35%" rowspan="6" ><img src="'.$imageurl.'"></td><td width="15%">Bedrijfsnaam:</td><td width="50%">'.$query['Bedrijfsnaam'].'</td></tr> <tr><td width="15%">Adres:</td><td width="50%">'.$query['Straat'].' '.$query['Huisnummer'].' '.$query['Toevoeging'].'</td></tr> <tr><td width="15%">Postcode:</td><td width="50%">'.$query['Postcode'].'</td></tr> <tr><td width="15%">Provincie:</td><td width="50%">'.$query['Provincie'].'</td></tr> <tr><td width="15%">Portfolio:</td><td width="50%"><a href="http://www.test.nl/'.$query['Portfolio'].'" target="_blanc">www.test.nl/'.$query['Portfolio'].'</a></td></tr> </table><br><br>';