Re: [Phpwebsite-developers] Need help understanding php command

[Matthew M. <ma...@tu...>]

David,

Yes try:

foreach ($columns as $item){
  $sql = "CREATE INDEX on " . $core->tbl_prefix . "$table_name ($item)";
  $this->query($sql)
}

Play with it, I haven't tested it :)

~Matt

On Sat, 2003-11-01 at 22:04, David Macbanay wrote:
> I am still new at databases and PHP programming but I am trying to
> figure out what all needs to be changed to support postgresql and I have
> the following question.
> 
> On line 769 of the file core/Database.php in version 9.3.1 it has the
> statement  $sql = "ALTER TABLE $table_name ADD INDEX (" . implode(", ",
> $columns) . ")";
> 
> How can this be rewritten to use Postgresql's CREATE INDEX ... ON
> statement?
> 
> Thanks,
> David
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
-- 
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
http://phpwebsite.appstate.edu
http://ess.appstate.edu