Forum Moderators: coopster

Message Too Old, No Replies

limit the query menus -1

dont work..

         

nanat

9:34 am on Jan 16, 2010 (gmt 0)

10+ Year Member



My query script:

$show = mysql_query("SHOW FIELDS FROM uploadme");
$feildsnum = 0;
while($do = mysql_fetch_array($show)) {
$feild[$do['Field']] = $do['Field'];
$feildsnum++;
}

$numSQL = 1;
$sqlKey = null;

foreach ($feild as $key ) {
if ($numSQL == $feildsnum) {
$sqlKey .= $key;
} else {
$sqlKey .= $key.",";
}
$numSQL++;
}


Test failed:

$do['Field']; - 1;
array_slice()
array_shift()
SHOW 1stField, 2ndField FIELDS FROM uploadme
$feildsnum = $feildsnum - 1; retrun 2; but tree fields

all want to do is to erase the primary key from the query..
Need help guys tnx ^^..

nanat

2:18 am on Jan 18, 2010 (gmt 0)

10+ Year Member



i got it ^^.. no need to reply.. ^^ hehehe