And here's all the PHP code in content.php:mysql_fetch_array() expects parameter 1 to be resource, string given in C:\wamp\www\sporsitesi\content.php on line 20
Code: Select all
<?php
$subject_set = get_all_subjects();
//Sorgu verisini kullan.
while ($subject = mysql_fetch_array($subject_set)) {
echo "<li>{$subject["menu_adi"]}</li>";
$page_set = ($subject["id"]);
echo "<ul class=\"sayfalar\">";
//Sorgu verisini kullan.
while ($page = mysql_fetch_array($page_set)) {
echo "<li>{$page["menu_adi"]}</li>";
}
echo "</ul>";
}
?>Code: Select all
<?php
//Bu dosyada PHP fonksiyonlar? toplanm??t?r.
function confirm_query($result_set) {
if(!$result_set) {
die("Veritaban? sorgulamas? ba?ar?s?z" . mysql_error());
}
}
function get_all_subjects() {
global $connection;
$query = "SELECT *
FROM konular
ORDER BY pozisyon ASC";
$subject_set = mysql_query($query, $connection);
confirm_query($subject_set);
return $subject_set;
}
function get_pages_for_subject_id($subject_id) {
global $connection;
$query = "SELECT *
FROM sayfalar
WHERE subject_id = {$subject["id"]}
ORDER BY pozisyon ASC";
$page_set = mysql_query($query , $connection);
confirm_query($page_set);
}
?>