Show all fields except id

**Xmen** · 08-12-2009

Hi
I am trying a code in php, I have some the following code with me, please check it.

Code:

$fld = array();
$sql = "SHOW fld FROM ".$acronym;
$rsl = mysql_query($sql);
$i = 1; // to skip the id field
while ($rw = mysql_fetch_array($rsl)) {
    $fld[]= $rw['Field'];
}
$str = implode(", ", $fld);
echo $str;

I think this is what it should happen

Code:

$sql = "INSERT INTO ".$acronym." (".$str.") VALUES (".$strLine[$line].")";

Can i exclude all the tags except the ID field which I have in the code.

**Praetor** · 08-12-2009

Hello
To work it properly you have to add the following part of to your code.

Code:

if($row['Field']=="id"){
continue;
}

This should come after this statement in the code.

Code:

while ($rw = mysql_fetch_array($rsl)) {

I have modified your code please check it may help you.

Code:

$fld = array();
$sql = "SHOW fld FROM ".$acronym;
$rsl = mysql_query($sql);
$i = 1; // to skip the id field
while ($rw = mysql_fetch_array($rsl)) {
    if($rw['Field']=="id"){
        continue;
    }
    $fld[]= $rw['Field'];
}
$str = implode(", ", $fld);
echo $str;

**opaper** · 08-12-2009

Hi
the above given example is a good code to demonstrate and to use. This will help you a lot, just try to understand it.

Code:

while ($rw = mysql_fetch_array($rsl)) {
    if($rw['Field']=="id"){
        continue;
    }
    $fld[]= $rw['Field'];
}

This part of the code is where you have to concentrate more. Once you understand this part if the code then the remaining is easy comings. You can just use the select statement as well and leave the id from it. I think this should not be a problem.

**Xmen** · 08-12-2009

Hey guys
Thanks for your help. I have solved the problem with you support and help. I have found the appropriate solution for it. I will continue with my php code.