Click here to Skip to main content
15,918,889 members

Comments by kumar ankit1 (Top 6 by date)

kumar ankit1 6-Jul-12 8:01am View    
this is code retrieving data with hyperlink

<!--?php
$result = mysql_query("SELECT * FROM aa order by name");

echo "<table align='center'?-->
<tr>
<th></th>
</tr>";

while($info = mysql_fetch_array( $result ))
{
echo "<tr>";
//echo "<td>" . $row['name'] . "</td>";

"<td>" . $info['name'] . "</td> ";
echo "<td> " .$info['name'] . "</td>";
echo "<td>" . $name . "</td>";


// $strLink = "" . $strNavn . "";
echo "</tr>";
}
echo "</table>";

mysql_close();
?>
and this code for getting sub categories
<div align="center">

SUB CATEGORY

</div>
<!--?php
// Get data from the database depending on the value of the id in the URL
$result = mysql_query("SELECT * FROM aa WHERE id=". $_GET['id'] );


echo "<table align='center'?-->
<tr>
<th></th>
</tr>";

// Loop the recordset $rs
while($row = mysql_fetch_array($result)) {

echo "<tr>";
//echo "<td>" . ''. $row['id'] .'' . "</td>";
// Write the data of the person
//echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['sub_cat'] . "</td>";
echo "<td>" . $row['sub_cat1'] . "</td>";

echo "</tr>";
}
echo "</table>";
// Close the database connection
mysql_close();
?>
kumar ankit1 6-Jul-12 6:02am View    
actually sir..i have retrievd data with hyperlink from database but i am not getting values from hyperlink.
kumar ankit1 19-Jun-12 14:15pm View    
sir i am using one query as-
String query ="SELECT(first_name +" "+ middle_name +" "+ last_name) as Name,city,state FROM user";
but here its showing one error as ';' expected.....my query is correct but why its showing error....??????
kumar ankit1 16-Jun-12 9:32am View    
yes....how can i do it.......????????
kumar ankit1 15-Jun-12 0:43am View    
i am using two tables one table for usercategory and other table for user........how can i give permission to both.....????