Ciao ragazzi, sono nuovo del forum, vorrei un aiuto riguardo un sito che sto modificando. Non riesco a capire perchè quando cerco di aprire la pagine index.php mi dà questo errore:
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 '' at line 1
Sto impazzendo... Anche perchè queste pagine mi sono state consegnate e non ho effettuato nessuna modifica a riguardo! Sospetto che il problema sia la funzione require_once ma non riesco proprio a risolverlo!
Aiutatemi vi prego! Ci sono anche altri problemi, magari ve lo posterò in seguito.... Grazie anticipatamente!
Vi posto il codice in questione:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_index = "localhost";
$database_index = "web_journal";
$username_index = "root";
$password_index = "";
$index = mysql_pconnect($hostname_index, $username_index, $password_index) or trigger_error(mysql_error(),E_USER_ERROR);
?>
<?php require_once("index.php"); ?>
<?php
mysql_select_db($database_index, $index);
$query_searchtem = "SELECT * FROM tematica ORDER BY ID ASC";
$searchtem = mysql_query($query_searchtem, $index) or die(mysql_error());
$row_searchtem = mysql_fetch_assoc($searchtem);
?>
<?php
mysql_select_db($database_index, $index);
$query_searchnum = "SELECT * FROM numero_giornale";
$searchnum = mysql_query($query_searchnum, $index) or die(mysql_error());
$row_searchnum = mysql_fetch_assoc($searchnum);
?>
<?php
mysql_select_db($database_index, $index);
$query_searchnewart = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 1";
$searchnewart = mysql_query($query_searchnewart, $index) or die(mysql_error());
$row_searchnewart = mysql_fetch_assoc($searchnewart);
$totalRows_searchnewart = mysql_num_rows($searchnewart);
?>
<?php
$ID = $row_searchnewart['Realizzato_da'];
mysql_select_db($database_index, $index);
$query_searchred = sprintf("SELECT ID, Nome, Cognome FROM staff_editoriale WHERE ID = $ID");
$searchred = mysql_query($query_searchred, $index) or die(mysql_error());
$row_searchred = mysql_fetch_assoc($searchred);
$totalRows_searchred = mysql_num_rows($searchred);
?>
<?php
mysql_select_db($database_index, $index);
$query_searchFirstart = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 1,1";
$searchFirstart = mysql_query($query_searchFirstart, $index) or die(mysql_error());
$row_searchFirstart = mysql_fetch_assoc($searchFirstart);
$totalRows_searchFirstart = mysql_num_rows($searchFirstart);
?>
<?php
mysql_select_db($database_index, $index);
$query_search2art = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 2,1";
$search2art = mysql_query($query_search2art, $index) or die(mysql_error());
$row_search2art = mysql_fetch_assoc($search2art);
$totalRows_search2art = mysql_num_rows($search2art);
?>
<?php
mysql_select_db($database_index, $index);
$query_search3art = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 3,1";
$search3art = mysql_query($query_search3art, $index) or die(mysql_error());
$row_search3art = mysql_fetch_assoc($search3art);
$totalRows_search3art = mysql_num_rows($search3art);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>wjf.it - Web Journal di FacoltÃ*</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link href="/Connections/style.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
<!--
.Stile1 {
color: #CC6B47;
font-weight: bold;
font-style: italic;
}
-->
</style>
<link href="/Connections/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.Stile2 {
color: #0000BB;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="Titolo">
<h1 align="center"> </h1>
<h1 align="center" class="Stile1">WJF.IT </h1>
<h2>il Web Journal della II FacoltÃ* di Scienze MM.FF.NN.</h2>
</div>
<div id="menu">
<ul>
<li class="first"><a href="/Connections/index.php">Home Page</a></li>
<li><a href="/Connections/finalita.php">FinalitÃ*</a></li>
<li><a href="/Connections/staff.php">Redazione</a></li>
<li><a href="/Connections/addform.php">Contattaci</a></li>
<li>
<div align="right"><a href="/Connections/login.php">Login</a></div>
</li>
</ul>
</div>
<hr />
<div id="latest-post" class="Post">
<p class="byline"><span>Ultima modifica apportata il 7 luglio 2008</span></p>
<p style="text-align:center"><object data='http://www.adnkronos.com/IGN/Ticker/Ultimora/Tickerult.swf'
type='application/x-shockwave-flash' width='580' height='45' class="Stile1" id='Tickerult'>
<param name='movie' value='http://www.adnkronos.com/IGN/Ticker/Ultimora/Tickerult.swf' />
<allow-access-from domain='http://www.adnkronos.com' secure='false' />
</object></p>
<p> </p>
<div id="recent-posts">
<h2>PRIMA PAGINA</h2>
<ul>
<h1 style="text-align:center" class="Stile1"><?php echo $row_searchnewart['Titolo']; ?></h1>
<div style="text-align:justify" class="entry">
<p><?php echo $row_searchnewart['Testo']; ?></p>
<p style="text-align:right" class="Stile2">Di: <?php echo $row_searchred['Nome']; echo(' '); echo $row_searchred['Cognome']; ?></p>
</div>
</ul>
</div>
<p class="meta"> </p>
</div>
<div id="recent-posts">
<h2>ARTICOLI RECENTI</h2>
<ul>
<?php
echo('<li class = "first"><h3 class="Stile1">'); echo $row_searchFirstart['Titolo']; echo('</h3> <p style="text-align:justify">[<strong>'); echo $row_searchFirstart['Consegna']; echo('</strong>] '); echo substr($row_searchFirstart['Testo'], 0, 100);
echo('... <a href="RecentPost.php">Leggi</a></p></li>');
echo('<li><h3 class="Stile1">'); echo $row_search2art['Titolo']; echo('</h3> <p style="text-align:justify">[<strong>');
echo $row_search2art['Consegna']; echo('</strong>] '); echo substr($row_search2art['Testo'], 0, 100);
echo('... <a href="RecentPost2.php">Leggi</a></p></li>');
echo('<li><h3 class="Stile1">'); echo $row_search3art['Titolo']; echo('</h3> <p style="text-align:justify">[<strong>');
echo $row_search3art['Consegna']; echo('</strong>] '); echo substr($row_search3art['Testo'], 0, 100);
echo('... <a href="RecentPost3.php">Leggi</a></p></li>');
?>
</ul>
<div style="clear: both; height: 40px;"> </div>
</div>
<div id="sidebar">
<ul>
<li>
<h2>LINK UTILI</h2>
<ul>
<li><a href="http://www.scienze.uniba.it/">FacoltÃ* di Scienze MM.FF.NN. (BARI)</a></li>
<li><a href="http://www.di.uniba.it/dib/ita/index.htm">Dipartimento di Informatica</a></li>
<li><a href="http://icdtaranto.helloweb.eu/forum/index.php">Forum ICD Taranto</a></li>
<li><a href="http://informatica.uniba.it/laurea_dig_taranto/index.htm">Home ICD Taranto</a></li>
<li><a href="http://inchiostro.unipv.it/">Inchiostro di Pavia</a></li>
</ul>
</li>
<li>
<h2>TEMATICHE</h2>
<form name="cerca" action="/Connections/OrdbyTem.php" method="post" style="text-align:center">
<select name="DesTemi" class="Stile2">
<?php
do {
?>
<option value="<?php echo $row_searchtem['Descrizione']?>"><?php echo $row_searchtem['Descrizione']?></option>
<?php
} while ($row_searchtem = mysql_fetch_assoc($searchtem));
$rows = mysql_num_rows($searchtem);
if($rows > 0) {
mysql_data_seek($searchtem, 0);
$row_searchtem = mysql_fetch_assoc($searchtem);
}
?>
</select><p></p><input type="submit" class="Stile2" value="Ricerca gli articoli">
</form>
</li>
<li>
<h2>NUMERI IN ARCHIVIO</h2>
<form name="cerca" action="OrdbyNum.php" method="post" style="text-align:center">
<select name="DesNumeri" class="Stile2">
<?php
do {
?>
<option value="<?php echo $row_searchnum['ID']?>"><?php echo $row_searchnum['ID']?></option>
<?php
} while ($row_searchnum = mysql_fetch_assoc($searchnum));
$rows = mysql_num_rows($searchnum);
if($rows > 0) {
mysql_data_seek($searchnum, 0);
$row_searchnum = mysql_fetch_assoc($searchnum);
}
?>
</select><p></p><input type="submit" align="middle" class="Stile2" value="Ricerca gli articoli">
</form>
</li>
</ul>
<div style="clear: both; height: 40px;"> </div>
</div>
<hr />
<div id="Chiusura">
<p class="legal">wjf.it il Web Journal della II FacoltÃ* di Scienze MM.FF.NN. - UniversitÃ* degli studi di Bari.</p>
</div>
</body>
</html>
Ciao Gigi!
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 '' at line 1
Sto impazzendo... Anche perchè queste pagine mi sono state consegnate e non ho effettuato nessuna modifica a riguardo! Sospetto che il problema sia la funzione require_once ma non riesco proprio a risolverlo!
Aiutatemi vi prego! Ci sono anche altri problemi, magari ve lo posterò in seguito.... Grazie anticipatamente!
Vi posto il codice in questione:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_index = "localhost";
$database_index = "web_journal";
$username_index = "root";
$password_index = "";
$index = mysql_pconnect($hostname_index, $username_index, $password_index) or trigger_error(mysql_error(),E_USER_ERROR);
?>
<?php require_once("index.php"); ?>
<?php
mysql_select_db($database_index, $index);
$query_searchtem = "SELECT * FROM tematica ORDER BY ID ASC";
$searchtem = mysql_query($query_searchtem, $index) or die(mysql_error());
$row_searchtem = mysql_fetch_assoc($searchtem);
?>
<?php
mysql_select_db($database_index, $index);
$query_searchnum = "SELECT * FROM numero_giornale";
$searchnum = mysql_query($query_searchnum, $index) or die(mysql_error());
$row_searchnum = mysql_fetch_assoc($searchnum);
?>
<?php
mysql_select_db($database_index, $index);
$query_searchnewart = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 1";
$searchnewart = mysql_query($query_searchnewart, $index) or die(mysql_error());
$row_searchnewart = mysql_fetch_assoc($searchnewart);
$totalRows_searchnewart = mysql_num_rows($searchnewart);
?>
<?php
$ID = $row_searchnewart['Realizzato_da'];
mysql_select_db($database_index, $index);
$query_searchred = sprintf("SELECT ID, Nome, Cognome FROM staff_editoriale WHERE ID = $ID");
$searchred = mysql_query($query_searchred, $index) or die(mysql_error());
$row_searchred = mysql_fetch_assoc($searchred);
$totalRows_searchred = mysql_num_rows($searchred);
?>
<?php
mysql_select_db($database_index, $index);
$query_searchFirstart = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 1,1";
$searchFirstart = mysql_query($query_searchFirstart, $index) or die(mysql_error());
$row_searchFirstart = mysql_fetch_assoc($searchFirstart);
$totalRows_searchFirstart = mysql_num_rows($searchFirstart);
?>
<?php
mysql_select_db($database_index, $index);
$query_search2art = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 2,1";
$search2art = mysql_query($query_search2art, $index) or die(mysql_error());
$row_search2art = mysql_fetch_assoc($search2art);
$totalRows_search2art = mysql_num_rows($search2art);
?>
<?php
mysql_select_db($database_index, $index);
$query_search3art = "SELECT * FROM articolo ORDER BY ID DESC LIMIT 3,1";
$search3art = mysql_query($query_search3art, $index) or die(mysql_error());
$row_search3art = mysql_fetch_assoc($search3art);
$totalRows_search3art = mysql_num_rows($search3art);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>wjf.it - Web Journal di FacoltÃ*</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link href="/Connections/style.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
<!--
.Stile1 {
color: #CC6B47;
font-weight: bold;
font-style: italic;
}
-->
</style>
<link href="/Connections/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.Stile2 {
color: #0000BB;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="Titolo">
<h1 align="center"> </h1>
<h1 align="center" class="Stile1">WJF.IT </h1>
<h2>il Web Journal della II FacoltÃ* di Scienze MM.FF.NN.</h2>
</div>
<div id="menu">
<ul>
<li class="first"><a href="/Connections/index.php">Home Page</a></li>
<li><a href="/Connections/finalita.php">FinalitÃ*</a></li>
<li><a href="/Connections/staff.php">Redazione</a></li>
<li><a href="/Connections/addform.php">Contattaci</a></li>
<li>
<div align="right"><a href="/Connections/login.php">Login</a></div>
</li>
</ul>
</div>
<hr />
<div id="latest-post" class="Post">
<p class="byline"><span>Ultima modifica apportata il 7 luglio 2008</span></p>
<p style="text-align:center"><object data='http://www.adnkronos.com/IGN/Ticker/Ultimora/Tickerult.swf'
type='application/x-shockwave-flash' width='580' height='45' class="Stile1" id='Tickerult'>
<param name='movie' value='http://www.adnkronos.com/IGN/Ticker/Ultimora/Tickerult.swf' />
<allow-access-from domain='http://www.adnkronos.com' secure='false' />
</object></p>
<p> </p>
<div id="recent-posts">
<h2>PRIMA PAGINA</h2>
<ul>
<h1 style="text-align:center" class="Stile1"><?php echo $row_searchnewart['Titolo']; ?></h1>
<div style="text-align:justify" class="entry">
<p><?php echo $row_searchnewart['Testo']; ?></p>
<p style="text-align:right" class="Stile2">Di: <?php echo $row_searchred['Nome']; echo(' '); echo $row_searchred['Cognome']; ?></p>
</div>
</ul>
</div>
<p class="meta"> </p>
</div>
<div id="recent-posts">
<h2>ARTICOLI RECENTI</h2>
<ul>
<?php
echo('<li class = "first"><h3 class="Stile1">'); echo $row_searchFirstart['Titolo']; echo('</h3> <p style="text-align:justify">[<strong>'); echo $row_searchFirstart['Consegna']; echo('</strong>] '); echo substr($row_searchFirstart['Testo'], 0, 100);
echo('... <a href="RecentPost.php">Leggi</a></p></li>');
echo('<li><h3 class="Stile1">'); echo $row_search2art['Titolo']; echo('</h3> <p style="text-align:justify">[<strong>');
echo $row_search2art['Consegna']; echo('</strong>] '); echo substr($row_search2art['Testo'], 0, 100);
echo('... <a href="RecentPost2.php">Leggi</a></p></li>');
echo('<li><h3 class="Stile1">'); echo $row_search3art['Titolo']; echo('</h3> <p style="text-align:justify">[<strong>');
echo $row_search3art['Consegna']; echo('</strong>] '); echo substr($row_search3art['Testo'], 0, 100);
echo('... <a href="RecentPost3.php">Leggi</a></p></li>');
?>
</ul>
<div style="clear: both; height: 40px;"> </div>
</div>
<div id="sidebar">
<ul>
<li>
<h2>LINK UTILI</h2>
<ul>
<li><a href="http://www.scienze.uniba.it/">FacoltÃ* di Scienze MM.FF.NN. (BARI)</a></li>
<li><a href="http://www.di.uniba.it/dib/ita/index.htm">Dipartimento di Informatica</a></li>
<li><a href="http://icdtaranto.helloweb.eu/forum/index.php">Forum ICD Taranto</a></li>
<li><a href="http://informatica.uniba.it/laurea_dig_taranto/index.htm">Home ICD Taranto</a></li>
<li><a href="http://inchiostro.unipv.it/">Inchiostro di Pavia</a></li>
</ul>
</li>
<li>
<h2>TEMATICHE</h2>
<form name="cerca" action="/Connections/OrdbyTem.php" method="post" style="text-align:center">
<select name="DesTemi" class="Stile2">
<?php
do {
?>
<option value="<?php echo $row_searchtem['Descrizione']?>"><?php echo $row_searchtem['Descrizione']?></option>
<?php
} while ($row_searchtem = mysql_fetch_assoc($searchtem));
$rows = mysql_num_rows($searchtem);
if($rows > 0) {
mysql_data_seek($searchtem, 0);
$row_searchtem = mysql_fetch_assoc($searchtem);
}
?>
</select><p></p><input type="submit" class="Stile2" value="Ricerca gli articoli">
</form>
</li>
<li>
<h2>NUMERI IN ARCHIVIO</h2>
<form name="cerca" action="OrdbyNum.php" method="post" style="text-align:center">
<select name="DesNumeri" class="Stile2">
<?php
do {
?>
<option value="<?php echo $row_searchnum['ID']?>"><?php echo $row_searchnum['ID']?></option>
<?php
} while ($row_searchnum = mysql_fetch_assoc($searchnum));
$rows = mysql_num_rows($searchnum);
if($rows > 0) {
mysql_data_seek($searchnum, 0);
$row_searchnum = mysql_fetch_assoc($searchnum);
}
?>
</select><p></p><input type="submit" align="middle" class="Stile2" value="Ricerca gli articoli">
</form>
</li>
</ul>
<div style="clear: both; height: 40px;"> </div>
</div>
<hr />
<div id="Chiusura">
<p class="legal">wjf.it il Web Journal della II FacoltÃ* di Scienze MM.FF.NN. - UniversitÃ* degli studi di Bari.</p>
</div>
</body>
</html>
Ciao Gigi!