Ahhh, thanks. I'll do that.
--
Regards,
John L. Creed
pcExpressWay Consulting
*
dBASE Gold Charter Member 210
*
http://www.pcexpressway.com
*
"Niel Archer" <[EMAIL PROTECTED]> w
Hi John,
I'd suggest searching within the Extra field instead of testing for the
value explicitly, as this field can theoretically hold several extra
pieces of information.
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Here's what I did wih your help:
function isAutoinc($table,$fieldname){
// returns 0 if false, 1 if true
$breturn = 0;
$sql = "SHOW COLUMNS FROM $table LIKE '$fieldname%' ";
$result = mysql_query($sql) or die("Couldn't open table");
// check column Extra
$row = mysql_fetch_array( $result
Thanks a Million my Friend. I've been struggling with this for days now
--
Regards,
John L. Creed
pcExpressWay Consulting
*
dBASE Gold Charter Member 210
*
http://www.pcexpressway.com
**
Hi
Try using:
SHOW COLUMNS FROM db.table LIKE 'field_name%'
and from the returned row, check the 'Extra' column for 'auto_increment'
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I've been struggling to figure a way to determine if a mySql filed type is
auto inc.
Any ideas?
Iv'e written a function that will INSERT form data which has the exact field
names as the mysql table, thus looping through the table names and then
building a query string for the insert. However I'