TalkPHP - View Single Post - Problem with Query + While $a = mysql_fetch_array($b)

Aaron · 07-03-2008, 07:16 PM

Okay... the code is

PHP Code:


			
// Get Navigation Information
$query = "SELECT `name`, `slug`
          FROM   `page`";
$nl = mysql_query($query);
while ($a = mysql_fetch_array($nl)){
  $b .= '<a href="'.ROOT.strtolower($a['slug']).'">'.$a['name'].'</a>'."\n";
}

as for the rest of my problem... it can be found here.

Edit: Fixed.

Now there is a new problem with Mod_rewrite...

The rewrite module is enabled, and my rewrite code is as follows:

Code:

RewriteEngine On
RewriteRule ^/DNTL\%20Limited/([^/]*)/([^/]*)\.html$ /DNTL\%20Limited/?lang=$1&slug=$2 [L]

The url is http://xx.xxx.xxx.213/DNTL%20Limited/?lang=en&slug=home

and mod rewrite should change it to

http://xx.xxx.xxx.213/DNTL%20Limited/en/home/

07-03-2008, 07:16 PM	#1 (permalink)
Aaron The Frequenter Join Date: Dec 2007 Location: In my basement Posts: 386 Thanks: 47	Problem with Query + While $a = mysql_fetch_array($b) Okay... the code is PHP Code: // Get Navigation Information $query = "SELECT `name`, `slug` FROM `page`"; $nl = mysql_query($query); while ($a = mysql_fetch_array($nl)){ $b .= '<a href="'.ROOT.strtolower($a['slug']).'">'.$a['name'].'</a>'."\n"; } as for the rest of my problem... it can be found here. Edit: Fixed. Now there is a new problem with Mod_rewrite... The rewrite module is enabled, and my rewrite code is as follows: Code: RewriteEngine On RewriteRule ^/DNTL\%20Limited/([^/])/([^/])\.html$ /DNTL\%20Limited/?lang=$1&slug=$2 [L] The url is http://xx.xxx.xxx.213/DNTL%20Limited/?lang=en&slug=home and mod rewrite should change it to http://xx.xxx.xxx.213/DNTL%20Limited/en/home/ __________________ Signatures are nothing but incriminating. Last edited by Aaron : 07-03-2008 at 08:04 PM.