l errore è:
Unknown column 'm.id_albo' in 'field list'

grazie

ciao a tutti!

[PHP]<?php
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$rowsPerPage = 20;
$pageNum = 1;
if (isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$lettera=$_REQUEST['lettera'];
if ($lettera == NULL) {
$lettera = '';
} else {
$lettera=$_REQUEST['lettera'];
}
if ($spec == NULL and $lettera == NULL and $tipo_medico == 1) {
$Sqlqr_gl="select * from medici_chirurghi where cognome != '' order by IF (ASCII(LOWER(cognome)) >=ASCII (LOWER('$lettera')),1,2),cognome LIMIT $offset, $rowsPerPage";
$query="SELECT COUNT(m.id_albo) AS numrows from medici_chirurghi where cognome != ''";
} else if ($spec == NULL and $lettera != NULL and $tipo_medico == 1) {
$Sqlqr_gl="select * from medici_chirurghi where cognome != '' and cognome LIKE '$lettera%' order by cognome LIMIT $offset, $rowsPerPage";
$query="SELECT COUNT(m.id_albo) AS numrows from medici_chirurghi where cognome != '' and cognome LIKE '$lettera%'";
} else if ($spec != NULL and $tipo_medico == 1) {
$Sqlqr_gl="select m.* from medici_chirurghi m, matricola_specialita ms, specialita2 s where cognome != '' and s.id_spec = $spec and s.id_spec = ms.id_specialita and m.matricola2 = ms.matricola order by IF (ASCII(LOWER(cognome)) >=ASCII (LOWER('$lettera')),1,2),cognome LIMIT $offset, $rowsPerPage";
$query="SELECT COUNT(m.id_albo) AS numrows from medici_chirurghi m, matricola_specialita ms, specialita2 s where cognome != '' and s.id_spec = $spec and s.id_spec = ms.id_specialita and m.matricola2 = ms.matricola";
} else if ($spec == NULL and $lettera == NULL and $tipo_medico == 2) {
$Sqlqr_gl="select * from medici_odontoiatri where cognome != '' order by IF (ASCII(LOWER(cognome)) >=ASCII (LOWER('$lettera')),1,2),cognome LIMIT $offset, $rowsPerPage";
$query="SELECT COUNT(m.id_albo) AS numrows from medici_odontoiatri where cognome != ''";
} else if ($spec == NULL and $lettera != NULL and $tipo_medico == 2) {
$Sqlqr_gl="select * from medici_odontoiatri where cognome != '' and cognome LIKE '$lettera%' order by cognome LIMIT $offset, $rowsPerPage";
$query="SELECT COUNT(m.id_albo) AS numrows from medici_odontoiatri where cognome != '' and cognome LIKE '$lettera%'";
} else if ($spec != NULL and $tipo_medico == 2) {
$Sqlqr_gl="select m.* from medici_odontoiatri m, matricola_specialita ms, specialita2 s where cognome != '' and s.id_spec = $spec and s.id_spec = ms.id_specialita and m.matricola2 = ms.matricola order by IF (ASCII(LOWER(cognome)) >=ASCII (LOWER('$lettera')),1,2),cognome LIMIT $offset, $rowsPerPage";
$query="SELECT COUNT(m.id_albo) AS numrows from medici_odontoiatri m, matricola_specialita ms, specialita2 s where cognome != '' and s.id_spec = $spec and s.id_spec = ms.id_specialita and m.matricola2 = ms.matricola";
}
echo "<div style=display:none>".$Sqlqr_gl."</div>";
$qr_gl=mysql_query($Sqlqr_gl,$connessione)or die(mysql_error());
while($r_gl=mysql_fetch_array($qr_gl,MYSQL_ASSOC)) {
if ($r_gl['cognome'] != NULL) {
?>[/PHP]

[PHP]<?php
if ($idmenu == '44') {
$tipo_medico = '2';
} else if ($idmenu == '45') {
$tipo_medico = '1';
}
$result=mysql_query($query) or die('Error, seconda query failed');
$row=mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$nav .= "<strong><a href='#'>.$page.</a></strong>"; // no need to create a link to current page
} else {
$nav .= " <a href="$self?page=$page&idmenu=$idmenu&lettera=$lettera&spec=$spec&tipomedico=$tipo_medico">.$page.</a> ";
}
}
if ($pageNum > 1) {
$page = $pageNum - 1;
$prev = " <a href="$self?page=$page&idmenu=$idmenu&lettera=$lettera&spec=$spec&tipomedico=$tipo_medico"><</a> ";
$first = " <a href="$self?page=1&idmenu=$idmenu&lettera=$lettera&spec=$spec&tipomedico=$tipo_medico">[First Page]</a> ";
} else {
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$next = " <a href="$self?page=$page&idmenu=$idmenu&lettera=$lettera&spec=$spec&tipomedico=$tipo_medico">></a> ";
$last = " <a href="$self?page=$maxPage&idmenu=$idmenu&lettera=$lettera&spec=$spec&tipomedico=$tipo_medico">[Last Page]</a> ";
} else {
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
?>[/PHP]

l errore è : Error, seconda query failed
mi potreste dare una mano? grazie a tutti

[PHP]$qr1=mysql_query("select * from medici_chirurghi, medici_odontoiatri where cognome = '$parola' OR nome = '$parola' order by cognome asc LIMIT $offset, $rowsPerPage",$connessione)or die(mysql_error());
[/PHP]

vorrei fare la select in due tabelle
come si fa?

grazie
ciao

[PHP]$qr1=mysql_query("select * from medici_chirurghi, medici_odontoiatri where cognome = '$parola' OR nome = '$parola' order by cognome asc LIMIT $offset, $rowsPerPage",$connessione)or die(mysql_error());[/PHP]

vorrei fare la select in due tabelle
come si fa?

grazie
ciao

a ki dovesse servire ho risolto cosi:

[PHP]<div> 
        <?
        $query = "SELECT c.CAS_ID, c.TITOLO, i.NOME,c.DES_BREVE,c.DESC_ESTESA,c.OFFERTA_SPECIALE FROM `CASE` c LEFT JOIN `IMMAGINI` i ON c.CAS_ID = i.CAS_ID where VISIBLE = 1 and DEF = 1 and HOME = 1 order by c.CAS_ID DESC";
        $result = mysqli_query($mysqli , $query);
        $num = mysqli_num_rows($result);
        $i=0;
        $count = 1;
         while ($row = mysqli_fetch_assoc($result)) {?>
                <a style="border:1px solid #e2001a; margin-bottom:10px; display:block;" class="box_case" href="javascript:;" onClick="showCasa('bigbox_<? echo $row["CAS_ID"];?>'); updateStatCasa(<? echo $row["CAS_ID"];?>)"> 
                    <table border="0" cellpadding="0" cellspacing="0" width="100%">
                        <tr>
                            <td style="padding:15px 0 15px 15px; cursorointer;" width="120" align="center" valign="top"><img src="<?php echo $row["NOME"]; ?>" height="90" /></td>
                            <td style="padding:15px 15px 15px 10px; cursorointer;" valign="top">
                                <span style="font-weight:bold; font-size:12px; color:#13007d;"><?php echo $row["TITOLO"]; ?></span> 
                                <br />
                                <?php echo $row["DES_BREVE"]; ?>
                            </td>
                        </tr>
                    </table>
                </a>
            <? $i++;$count++;
        } ?>
    </div>[/PHP]

provato e riprovato ma niente...
scusa riusciresti a farmi un esempio?
grazie mille

sul sito mi esce qst errore: Warning: mysql_result() expects parameter 1 to be resource, object given in

codice da me usato :

[PHP]<div>
<?
$query = "SELECT c.CAS_ID, c.TITOLO, i.NOME,c.DES_BREVE,c.DESC_ESTESA,c.OFFERTA_SPECIALE FROM CASE c LEFT JOIN IMMAGINI i ON c.CAS_ID = i.CAS_ID where VISIBLE = 1 and DEF = 1 and HOME = 1 order by c.CAS_ID DESC";
$result = mysqli_query($mysqli , $query);
$num = mysqli_num_rows($result);
$i=0;
$count = 1;
while ($i < $num && $i <5) {
$id_case[] = mysqli_result($result,$i,"CAS_ID");
?>
<a style="border:1px solid #e2001a; margin-bottom:10px; display:block;" class="box_case" href="javascript:;" onClick="showCasa('bigbox_<? echo mysql_result($result,$i,"CAS_ID");?>'); updateStatCasa(<? echo mysql_result($result,$i,"CAS_ID");?>)">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td style="padding:15px 0 15px 15px; cursor:pointer;" width="120" align="center" valign="top"><img src="<?php echo mysql_result($result,$i,"NOME"); ?>" height="90" /></td>
<td style="padding:15px 15px 15px 10px; cursor:pointer;" valign="top">
<span style="font-weight:bold; font-size:12px; color:#13007d;"><?php echo mysql_result($result,$i,"TITOLO"); ?></span>
<br />
<?php echo mysql_result($result,$i,"DES_BREVE"); ?>
</td>
</tr>
</table>
</a>
<? $i++;$count++;
} ?>
</div>[/PHP]

nella riga 5 e 6 ho aggiunto la ' i ' alla funzione mysql e funziona, ma nella mysql_result nn va..
sapete darmi una mano?
grazie a tutti!!

a tutti!!