View Full Version : Problem help please.


Phillip
08-03-2006, 01:31 PM
Ok i've got an avatar script. Which SELECT's the users username from the database. I have also made a subnav where it will display links on if your a moderator/admin the scrit is fine until i add it to my header then i get this:


Fatal error: Cannot redeclare escape_data() (previously declared in /home//public_html/profiles.mysql_connect.php:25) in /home//public_html/mysql_connect.php on line 25

How do I stop this please?

Douglas
08-03-2006, 02:43 PM
Phill, you know we need to see the script to help you :D Please can I see it :P

Phillip
08-03-2006, 04:51 PM
Which script?

Douglas
08-03-2006, 06:51 PM
The one with the error...

Phillip
08-03-2006, 08:24 PM
Here she is:

<?php
require('mysql_connect.php');

// Make the query.
$query = "SELECT user_privlige FROM users WHERE first_name='{$_SESSION['first_name']}' AND user_privlige='Moderator'";
$result = mysql_query ($query) or trigger_error("Query: $query\n<br />Mysql error " . mysql_error());

if (@mysql_num_rows($result) == 1) {

echo '<a href="/panel/mod/"><img src="http://www.peble.co.uk/images/mod_panel.bmp" width="150" height="22" border="0" /></a><br />
<a href="/help/contact/support/view_ticket.php"><img src="http://www.peble.co.uk/images/view_ticket.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/mods/view_users.php"><img src="http://www.peble.co.uk/images/member_list.bmp" width="150" height="22" border="0" /></a><br />
<a href="/help/view_cfh.php"><img src="http://www.peble.co.uk/images/view_cfh.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/mods/ban_user.php"><img src="http://www.peble.co.uk/images/ban_user.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/mods/announcement.php"><img src="http://www.peble.co.uk/images/announcement.bmp" width="150" height="22" border="0" /></a><br />
';

} else {
echo '';
}
?>
<?php
require('mysql_connect.php');
$query = "SELECT user_privlige FROM users WHERE first_name='{$_SESSION['first_name']}' AND user_privlige='Admin'";
$result = mysql_query ($query) or trigger_error("Query: $query\n<br />Mysql error " . mysql_error());

if (@mysql_num_rows($result) == 1) {
echo '<a href="/panel/admin/"><img src="http://www.peble.co.uk/images/admin_panel.bmp" width="150" height="22" border="0" /></a><br />
<a href="/help/contact/support/view_ticket.php"><img src="http://www.peble.co.uk/images/view_ticket.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/admin/view_users.php"><img src="http://www.peble.co.uk/images/member_list.bmp" width="150" height="22" border="0" /></a><br />
<a href="/help/view_cfh.php"><img src="http://www.peble.co.uk/images/view_cfh.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/admin/ban_user.php"><img src="http://www.peble.co.uk/images/ban_user.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/admin/announcement.php"><img src="http://www.peble.co.uk/images/announcement.bmp" width="150" height="22" border="0" /></a><br />
<a href="/panel/admin/view_banned_users.php"><img src="http://www.peble.co.uk/images/view_banned_users.bmp" width="150" height="22" border="0" /></a><br />
';
} else {
echo '';
}
mysql_free_result($result);
mysql_close();
?>

harmor
08-03-2006, 10:27 PM
Just require "mysql_connect.php" once in the script you posted.

Phillip
08-03-2006, 10:46 PM
didn't work :(

harmor
08-04-2006, 01:47 AM
let me see mysql_connect.php