Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: Query Empty on page not im phpmyadmin

Posted on 2007-10-31 21:11:53 by Peter

Hello all,

I don't get it, when i use the code below I get a "Query empty", however
when I enter the myql statement in phpmyadmin i get the result i want...
what am i doing worng?

$msyql = "SELECT DATE_FORMAT(d_date, '%M %e, %Y') as date FROM `pages`
WHERE id_pages = 1";

echo $mysql;

$result = mysql_query($mysql) or die (mysql_error());

while(list($date)=mysql_fetch_row($sql_date)){

echo "The date of this row is: $date";

}



Regards,
Peter

Report this message

#2: Re: Query Empty on page not im phpmyadmin

Posted on 2007-10-31 22:04:20 by Peter

msyql instead of mysql

darn typos....


> Hello all,
>
> I don't get it, when i use the code below I get a "Query empty", however
> when I enter the myql statement in phpmyadmin i get the result i want...
> what am i doing worng?
>
> $msyql = "SELECT DATE_FORMAT(d_date, '%M %e, %Y') as date FROM `pages`
> WHERE id_pages = 1";
>
> echo $mysql;
>
> $result = mysql_query($mysql) or die (mysql_error());
>
> while(list($date)=mysql_fetch_row($sql_date)){
>
> echo "The date of this row is: $date";
>
> }
>
>
>
> Regards,
> Peter
>
>

Report this message