Organizational Research By

Surprising Reserch Topic

how to select default value of a field


how to select default value of a field  using -'php,mysql,sql,phpmyadmin'

I can't seem to find or write a sqlquery that SELECTS the DEFAULT VALUE

(and I don't think I can generate it in phpmyadmin for me to copy)

I tried to SELECT it as if it was a record but to no avail...

 $defaultValue_find = mysql_query(
         "SELECT $group FROM grouptable WHERE $group='DEFAULT'")  
      or die("Query failed:".mysql_error());
 $defaultValue_fetch = mysql_fetch_row($defaultValue_find);
 $defaultValue = $defaultValue_fetch[0];
 echo $defaultValue;

    
asked Oct 13, 2015 by tushar2k6
0 votes
1 view



Related Hot Questions



Government Jobs Opening


...