Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,471
There are 1141 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

need some help - froms from mysql db

Thread title: need some help - froms from mysql db
Closed Thread  
Page 4 of 4 < 1 2 3 4
    Thread tools Search this thread Display Modes  
09-06-2007, 12:11 AM
 #31
Salathe is offline Salathe
Salathe's Avatar
Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP
 
Posts: 3,820
iTrader: 25 / 100%
 

Salathe will become famous soon enough

Send a message via MSN to Salathe

  Old

Try the following PHP and tell us what it outputs, if anything.

PHP Code:

    $sql = "SHOW TABLES LIKE 'cms_%'";
    $query = mysql_query($sql);
    
    $rows = array();
    while($row = mysql_fetch_array($query)) {
        $rows[] = substr($row[0], 4);
    }

    if (count($rows) == 0) {
        echo 'No tables matching <strong>cms_</strong>...';
    } else {
        echo implode('<br>', $rows);
    } 

09-06-2007, 12:46 AM
 #32
pixelgod is offline pixelgod
Status: Member
Join date: Jul 2007
Location: 127.0.0.1
Expertise:
Software:
 
Posts: 110
iTrader: 4 / 100%
 

pixelgod is on a distinguished road

Send a message via MSN to pixelgod

  Old

It outputs this:www.ipcloak.info - not I did make a modification to the script, I changed cms_ to CMS_

EDIT: Ah, thanks, I think I can incorporate this into my application.

EDIT: Hmm, it still doesn't work.. I've never used implode before.
09-06-2007, 09:25 PM
 #33
pixelgod is offline pixelgod
Status: Member
Join date: Jul 2007
Location: 127.0.0.1
Expertise:
Software:
 
Posts: 110
iTrader: 4 / 100%
 

pixelgod is on a distinguished road

Send a message via MSN to pixelgod

  Old

Still can't get it to work..I've read some tutorials on implode.
09-06-2007, 09:56 PM
 #34
Wildhoney is offline Wildhoney
Wildhoney's Avatar
Status: Request a custom title
Join date: Feb 2006
Location: Nottingham
Expertise:
Software:
 
Posts: 1,648
iTrader: 18 / 95%
 

Wildhoney is on a distinguished road

Send a message via AIM to Wildhoney Send a message via MSN to Wildhoney Send a message via Yahoo to Wildhoney

  Old

Salathe has done the implode for you. As he not?
09-07-2007, 12:54 AM
 #35
pixelgod is offline pixelgod
Status: Member
Join date: Jul 2007
Location: 127.0.0.1
Expertise:
Software:
 
Posts: 110
iTrader: 4 / 100%
 

pixelgod is on a distinguished road

Send a message via MSN to pixelgod

  Old

Ah, I've got it, thanks everyone!
09-07-2007, 10:16 PM
 #36
Wildhoney is offline Wildhoney
Wildhoney's Avatar
Status: Request a custom title
Join date: Feb 2006
Location: Nottingham
Expertise:
Software:
 
Posts: 1,648
iTrader: 18 / 95%
 

Wildhoney is on a distinguished road

Send a message via AIM to Wildhoney Send a message via MSN to Wildhoney Send a message via Yahoo to Wildhoney

  Old

I'm glad you got there eventually.
Closed Thread  
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed  

Home   |     |   News   |   Rules   |   FAQ   |  


Powered by HandsOnWebHosting.com

The time is now 08:38 AM (GMT).


Powered by: vBulletin Version 3.8.4 Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.