Posted by = poster = on 12/01/06 12:06

Hi all ,

I have the following problem :

$some_query = mysql_query(
"SELECT table1.id, table1.category, table1.author, table1.title,
table2.title, table2.category FROM table1, table2
WHERE table1.category = table2.category ORDER by table1.id DESC");

while($record = mysql_fetch_array($some_query))
{
$mycategory = ($record['table1.category']);
$mytitle = ($record['table2.title']);

echo"$mycategory";
echo"$mytitle";
}

Does someone know what's wrong here ?
echo don't show the requested values ....


thanks !

• Next in forum: Re: PHP commandline script without commandbox?
• Prev in forum: Re: ezPDF Question
• Thread view: retrieveing vars from mysql join ?

[Reply to this message]