Mam problem z wyciagnieciem danych z bazy MSQL

Języki, których efekty są wykonywane po stronie serwera. PHP, ASP czy CGI w połączeniu z bazami danych SQL dają niezwykłe możliwości budowy i zarządzania stron WWW. Tu zadajemy pytania oraz demonstrujemy kod, z którym mamy problem.
witer
Posty: 1
Rejestracja: ndz kwie 20, 2008 11:25 am

Mam problem z wyciagnieciem danych z bazy MSQL

Post autor: witer »

Mozecie mi pomóc bo nie wiem gdzie jest błąd...
Nie jestem zbyt dobry z PHP i MSQL.
bede wdzieczny za wskazowki...

Oto kod...
[php]<?php

/**********************************************
BEGIN CONFIG SECTION
**********************************************/
$category = '4';
$use_nicenick = false;
/**********************************************
END CONFIG SECTION
**********************************************/
mysql_connect("localhost","user","pasword") or trigger_error(mysql_error(),E_USER_ERROR);
@mysql_select_db("base") or die( "Unable to select database");

function convert_datetime($datestamp, $format) {
if ($datestamp!=0) {
list($date, $time)=split(" ", $datestamp);
list($year, $month, $day)=split("-", $date);
list($hour, $minute, $second)=split(":", $time);
$stampeddate=mktime($hour,$minute,$second,$month,$day,$year);
$datestamp=date($format,$stampeddate);
return $datestamp;
}
}

$wp_term_relationships_query_ = "select c.object_id from wp_terms a, wp_term_taxonomy b, wp_term_relationships c where a.term_id = '$category' and a.term_id=b.term_id and b.term_taxonomy_id=c.term_taxonomy_id order by object_id desc limit 1";
$wp_term_relationships_query = mysql_query($wp_term_relationships_query_, $blog_link);
$wp_term_relationships = mysql_fetch_row($wp_term_relationships_query);
$getpost = $wp_term_relationships['object_id'];
$wp_post_query_ = "select * from wp_posts WHERE id = '$getpost' limit 1";
$wp_post_query = mysql_query($wp_post_query_, $blog_link);
$wp_post = mysql_fetch_row($wp_post_query);
$getauthor = $wp_post['post_author'];

$char=array("Â");
$charto=array("");
$oscpost=rtrim(strip_tags(str_replace($char, $charto, $wp_post['post_content'])));

if ($use_nicenick == true) {
$wp_author_query_ = "select * from wp_users WHERE id = '$getauthor' limit 1";
$wp_author_query = mysql_query($wp_author_query_, $blog_link);
$wp_author = mysql_fetch_row($wp_author_query);
$wp_email_query_ = "select * from wp_users WHERE id = '$getauthor' limit 1";
$wp_email_query = mysql_query($wp_email_query_, $blog_link);
$wp_email = mysql_fetch_row($wp_email_query);
} else {
$wp_author_query_ = "select * from wp_usermeta WHERE user_id = '$getauthor' AND meta_key = 'first_name' limit 1";
$wp_author_query = mysql_query($wp_author_query_, $blog_link);
$wp_author = mysql_fetch_row($wp_author_query);
$wp_email_query_ = "select * from wp_users WHERE id = '$getauthor' limit 1";
$wp_email_query = mysql_query($wp_email_query_, $blog_link);
$wp_email = mysql_fetch_row($wp_email_query);
}

$post_date = convert_datetime($wp_post['post_date'], "F j, Y g:ia");
?>
<!-- / wordpress contrib by shindakun / !-->
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td class="infoBoxHeading" height="30"><img src="images/pixel_trans.gif" alt="" border="0" height="17" width="5"></td>
<td class="infoBoxHeading" height="15" width="100%"><a href="<?php echo $wp_post['guid'];?>" class="headerNavigation"><?php echo $wp_post['post_title'];?> (<?php echo $post_date;?>)</a></td>
</tr>
</table>
<table border="1" cellpadding="4" cellspacing="0" width="100%">
<tr>
<td class="smallText" valign="top"><?php echo $oscpost;?></td>
</tr>
<tr>
<td class="infoBoxHeading" valign="top"><div align="right">blogged by <a href="mailto:<?php echo $wp_email['user_email'];?>"><?php if ($use_nicenick == true) {echo $wp_author['user_nicename'];} else {echo $wp_author['meta_value'];}?></a></div></td>
</tr>
</table>[/php]
W tym zapisie pokazuje ze nic nie ma w bazie.
Jest to skrypt ktory powinien wyciagac z bazy post napisane w Wordpressie 2.3.1
Dzieki z apomoc..
ODPOWIEDZ