Posted by Peter on 10/31/07 21:04

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
>
>

• Next in forum: PHP subroutine - get additional info from text file?
• Prev in forum: Query Empty on page not im phpmyadmin
• Thread view: Re: Query Empty on page not im phpmyadmin

[Reply to this message]