fetching fields and value

singboy

<html>
<head>
<title>DIY Web Contact Management System</title>
<?php
require_once("db_connect.php");

//$type = $POST['searchtype'];
//$text = $POST['searchtext'];
//trim($text);
$q_result = mysql_query("select * from CUSTOMER where CUS_Name = $cname");
<body bgcolor="#FFFFFF">
<table width="75%" border="1">
<?
while($row = mysql_fetch_row($q_result))
{
$field=mysql_field_name($q_result);
echo ("<tr><td>".$field."</td>");
for($i=0; $i<mysql_num_fields($q_result); $i++)
echo ("<td>".$row[$i]."</td></tr>");
}

    ?>
    </table>
    </body>

</head>
</html>

Actually my purpose is to fetch the data from CUSTOMER table of 17 attributes so that i could view in (row=17, col=2) Somehow its shown :

"); for($i=0; $i".$row[$i]."
"); } ?>

Could anyone plz help me. 😕

HalfaBee

You probably need $cname in single quotes.

$q_result = mysql_query("select * from CUSTOMER where CUS_Name = '$cname'");

HalfaBee

cash_php

seem to be quite complete, let me figure out for you.

Weedpacket

Reposting your original code using [php]:

<html>
<head>
<title>DIY Web Contact Management System</title>
<?php
require_once("db_connect.php");


//$type = $_POST['searchtype'];
//$text = $_POST['searchtext'];
//trim($text);
$q_result = mysql_query("select * from CUSTOMER where CUS_Name = $cname");
<body bgcolor="#FFFFFF">
<table width="75%" border="1">
<?
while($row = mysql_fetch_row($q_result))
{
$field=mysql_field_name($q_result);
echo ("<tr><td>".$field."</td>");
for($i=0; $i<mysql_num_fields($q_result); $i++)
echo ("<td>".$row[$i]."</td></tr>");
}

?>
</table>
</body>
</head>
</html>

And the way the syntax highlighting goes wonly around about the mysql_query() line suggests where the problem lies: a missing ?>.

singboy

<html>
<body>
<head>
<title>DIY Web Contact Management System</title>
<?php
require_once("db_connect.php");

//$type = $POST['searchtype'];
//$text = $POST['searchtext'];
//trim($text);
$cname="solunet";
$q_result = mysql_query("select * from CUSTOMER where CUS_Name = $cname"); ?>
<body bgcolor="#FFFFFF">
<table width="75%" border="1">
<?
while($row = mysql_fetch_row($q_result))
{
$field=mysql_field_name($q_result);
echo ("<tr><td>".$field."</td>");
for($i=0; $i<mysql_num_fields($q_result); $i++)
echo ("<td>".$row[$i]."</td></tr>");
}

?>
</table>
</body>
</head>
</html>

after i tried, but still the same like before:
error:-

".$field." "); for($i=0; $i".$row[$i]."
"); } ?>

Sigh@😕

ii2php

try:
<?php
require_once("db_connect.php");
..
..
mysql_query("select * from CUSTOMER where CUS_Name ='".$cname."'");

put the single quotes around $cname

HalfaBee

try this.

while($row = mysql_fetch_assoc($q_result))
{
    foreach ( $row as $field => $value )
    {
        echo ("<tr><td>".$field."</td>");
        echo ("<td>".$value."</td></tr>");
    }
}

batman

<html> 
<body> 
<head> 
<title>DIY Web Contact Management System</title> 
<?php 
require_once "db_connect.php"; 


//$type = $_POST['searchtype']; 
//$text = $_POST['searchtext']; 
//trim($text); 
$cname="solunet"; 
$q_result = mysql_query("select * from CUSTOMER where CUS_Name='$cname'"); ?> 
<body bgcolor="#FFFFFF"> 
<table width="75%" border="1"> 
<? 
while($row = mysql_fetch_row($q_result)) 
{ 
$field=mysql_field_name($q_result); 
echo ("<tr><td>$field</td>"); 
for($i=0; $i < mysql_num_fields($q_result); $i++)
{ 
echo ("<td>".$row[$i]."</td></tr>");
} 
} 

?> 
</table> 
</body> 
</head> 
</html>

singboy

thank you very much , expert. I learnt that.

HalfaBee

Doesn't mysql_fetch_field() need the field offset?

string mysql_field_name ( resource result, int field_index)

HalfaBee