i have problem to get data in home page

[raghoo]

i am writing my own query but i did not getting result

 

<?php

 

$test=$_REQUEST['test'];

$cat_id=$_REQUEST['cat_id'];

if($test!="")

  {

  if(!isset($_GET['act']) || $_GET['act'] != 'play'){

$query="select * from categories where cImage ";

$result=mysql_query($query);

while($data=mysql_fetch_array($result))

{

$values=$data['cName'];

$cat_id=$data['cId'];

 

echo "<br>";

echo "<table width='100%' cellpading='0' cellspacing='0' border='0'>";

echo "<tr>";

echo "<td width='20%' align='left'><a href='products_dis.php?test=test&cat_id=$data[cId]'><img src='images/$data[cImage]' ></a></a><td>";

echo "<td width='80%' align='left' valign='top'>";

 

echo "</table>";

echo "<td>";

echo "</tr> ";

echo "</table>";

}

}

 

}

?>

 

in this i am getting only one image and related url in every category ony one image(test.jpg) and url(test.php)

please help me how to get related image and url to every category.

[fenway]

I only see one query....

[raghoo]

how to get different images urls for different categories?

is there need any other data i will provide

please help

[raghoo]

anybody here to help me

[raghoo]

anybody here to help me

[fenway]

how to get different images urls for different categories?

is there need any other data i will provide

please help

Like your table structure?

[raghoo]

how to get different images urls for different categories?

is there need any other data i will provide

please help

Like your table structure?

i did not get

[fenway]

Get what?  Your query makes no sense -- WHERE cImage?