mary1994

I would like to have someone work on my site and fix a couple of things:
1. During the upgrade of IE6 to IE7 three of my css tables are overlapping and not showing good. Basically, it looks great with firefox, IE6 and lower except for IE7,
2. I need to some optimization done to my sql statement inorder to reduce page download time. Lately, my site has been crashing mainly because of the code below I am using to pull data from featured member tables.


Below is a sample of the sql statement that needs optimization.
$sql='SELECT * FROM user WHERE FEATURE=1 ORDER BY RAND() LIMIT 0,1';
$result=mysql_query($sql) or die('error:'.mysql_error());
$Fourth_Feature = array();
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$Fourth_Feature['FEATURED_IMAGE'] = uimage($row['user'],"75",4,"");
????: NamePros.com http://www.namepros.com/developers-for-hire/167720-professional-web-developer-accepting-new-work.html
$Fourth_Feature['FEATURED_USER'] = ulink($row['user']);
$Fourth_Feature['user_location'] = $row['location'];
$Fourth_Feature['user_gender'] = ucfirst($row['gender']);
$Fourth_Feature['user_birthday'] = bday("$row[day]","$row[month]","$row[year]");

if ( $row['city'] || $row['state'] )
{
$Fourth_Feature['user_location_city'] = $row['city'];
$Fourth_Feature['user_location_state'] = $row['state'];
}
//$Members='';
}
$sql='SELECT * FROM user WHERE FEATURE=1 ORDER BY RAND() LIMIT 0,1';
$result=mysql_query($sql) or die('error:'.mysql_error());
$Third_Feature = array();
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$Third_Feature['FEATURED_IMAGE'] = uimage($row['user'],"75",4,"");
$Third_Feature['FEATURED_USER'] = ulink($row['user']);
$Third_Feature['user_location'] = $row['location'];
$Third_Feature['user_gender'] = ucfirst($row['gender']);
$Third_Feature['user_birthday'] = bday("$row[day]","$row[month]","$row[year]");

if ( $row['city'] || $row['state'] )
{
$Third_Feature['user_location_city'] = $row['city'];
$Third_Feature['user_location_state'] = $row['state'];
}
PM me for site name.

arifagic

Cao, Milose!
Hi, there!

I need some optimission on my php CMS and im looking for photoshop tutorial writers, do you do that kind of work.

CMS stuff needed:
Star rating (evt AJAX)
Admin panel update.
etc..

teknoledge

Sorry for delay, I was pretty busy ...
????: NamePros.com http://www.namepros.com/showthread.php?t=167720

I'm not really interested in writing photoshop tutorials, though you can PM me with more info regarding CMS upgrade, etc...

Cheers!

__________________

kiminglis

Ive googled myself into a vegetable trying to find help:

I have a phbBB forum installed on my site. Im trying to create a simple signup/register page (and subsequent "member only" pages) that uses or syncs with the MySQL database used by phpBB.

Can you help - ball park cost

kiminglis@gmail.com

Thnks