[Music Chart]

yea this is actually pretty simple.

 

on the vote page just do an update query or someting

 

$bands = mysql_query("SELECT * FROM bands WHERE bandname = '$_GET[bandname]'");

while ($band = mysql_fetch_array($bands)) {

mysql_query("UPDATE `bands` SET `votes` = '$band[votes] + 1' WHERE `bandbame` = '$_GET[bandname]'"); }

 

now to order 100 starting with the first on just do

 

$bands = mysql_query("SELECT * FROM bands WHERE bandname = '$_GET[bandname]' ORDER BY votes DESC LIMIT 100'");

while ($band = mysql_fetch_array($bands)) {

echo "$band[bandname]

<br />

\n";

}

 

edit bold bits

[windows redirect]

maybe you would be better using html then

 

echo "<meta http-equiv='refresh' content='0;url=url' />";

[different colored table rows]

lol thanks, im stupid.. 

[[SOLVED] weird display of images on fly]

hm.. i dont see why there would be anything wrong with that...

but try this..

ImageString ($image, $font, 36, 0, 0, "$text", $dblue);

 

i dont no what your do so i just guessd... but just use an image string...

[different colored table rows]

hi, im trying to make the message center on my website look better...

how do i make it so it shows the first table row with a diferent colored background from the next??

 

ive figured out a way of seting the next color in my database.. but is there a quiker way?

[GD Library Help]

as in the image size??

 

save that php document, then on a new one use

 

$sizes = getimagesize("url");

$width = $sizes[0];

$height = $sizes[1];

 

http://nl2.php.net/getimagesize

[[SOLVED] weird display of images on fly]

fly??

 

what way are you doing it??

 

echo "<font face=the font name>text</font>"; (the person viewing this will need to have it iunstalled on their computer)

 

or are you using GD?

[[SOLVED] my script will not connect to the database :@--must be error in code]

could be probleme with the host.. it might not be localhost (if your using a webhost)

[[SOLVED] GET problem...]

check the date manuall

http://nl3.php.net/date

 

date = date(Y-m-d);

tame = date(H:i:s);

[[SOLVED] my script will not connect to the database :@--must be error in code]

$conn = mysql_connect("localhost", "username", "password");

$db = @mysql_select_db("runnerse_profiles", "images");

 

you dont need to put $conn iin the mysql_selecet_db() function..

[[SOLVED] very quick and easy for php intermediate!]

---

if($_GET

---

==about.txt){

 

instead of

 

if (page="?page=about.txt")

 

and so on..

[[SOLVED] How would I do this? ('top 5 contributors' system)]

when they post add another post too a posts feild in the users table...

 

$query = mysql_query("SELECT * FROM recipes ORDER BY posts DESC LIMIT 5));

while ($row = mysql_fetch_array($query)){

echo "$row[the filed]";

}

 

edit bold bits..

[email verification system]

yea it all works..

[[SOLVED] Help needed with upload script]

my code...

 

<?php
echo "<font face=Arial size=2 color=#000000>";
$path = "uploads/";
$date = date("YmdHis");
if (isset($HTTP_POST_FILES['userfile'])){
if (!$HTTP_POST_FILES['userfile']){ echo "<font color=#ff0000>Error</font>: Please select a file to upload";
}else if (is_uploaded_file($HTTP_POST_FILES['userfile']['tmp_name'])) {
if (($HTTP_POST_FILES['userfile']['type']=="image/gif") || ($HTTP_POST_FILES['userfile']['type']=="image/pjpeg") || ($HTTP_POST_FILES['userfile']['type']=="image/jpeg") || ($HTTP_POST_FILES['userfile']['type']=="image/png")) {
if (file_exists($path .$date .$HTTP_POST_FILES['userfile']['name'])) { echo "<font face=#ff0000>Error</font>: Please try upload again now<br />";
}else{
$res = copy($HTTP_POST_FILES['userfile']['tmp_name'], $path .$date .$HTTP_POST_FILES['userfile']['name']);
if (!$res) { echo "<font color=#ff0000>Error</font>: Unexpected fail<br>";
}else{
echo "upload sucessful<br><br>"; }
echo "File Name: ".$date."".$HTTP_POST_FILES['userfile']['name']."<br>";
echo "File Path: <a href=uploads/".$date."".$HTTP_POST_FILES['userfile']['name']." TARGET=_BLANK>uploads/".$date."".$HTTP_POST_FILES['userfile']['name']."</a><br>";
echo "File Size: ".$HTTP_POST_FILES['userfile']['size']." bytes<br>";
echo "File Type: ".$HTTP_POST_FILES['userfile']['type']."<br>";
echo "<img src=uploads/".$date."".$HTTP_POST_FILES['userfile']['name']."><br>";
}}else{ echo "<font color=#ff0000>Error</font>: wrong file type"; }}}
?>
</font>
<form ENCTYPE=multipart/form-data action='<?php echo "'$_SERVER[php_SELF]'"; ?> method=POST>
The file:
<input type=file name=userfile>
<input type=submit value=Upload>
</form></font>
<form ENCTYPE=multipart/form-data action='<?php echo "'$_SERVER[php_SELF]'"; ?> method=POST>
The file:
<input type=file name=userfile>
<input type=submit value=Upload>
</form></font>
<form ENCTYPE=multipart/form-data action='<?php echo "'$_SERVER[php_SELF]'"; ?> method=POST>
The file:
<input type=file name=userfile>
<input type=submit value=Upload>
</form>

[email verification system]

it might be easy to just md5 their password and then send them it out..

or you could save their session in the database aswell..

 

put this

session_start();

now just save the session_id([string $id])

thats the session id..

 

then mail that too them

[Displaying gender photo]

yes an else if is possilbe

 

if(something==theotherthing){ do something

}else if(something==somethingelse){ do something else

}else{ do the other ting... }

[[SOLVED] Session array?]

$_SESSION=array();

[gather info from html doc]

kk thanks ill have a look

[gather info from html doc]

hi i want to make a page that gathers how many posts ive posted on forums, i was trying to use a code

 

i was planning to first of all open the document, read it, then strip the tags and preg_replace all the other content (i reallised it wouldnt work)

 

i got this far, but it didnt seem to work at all:

<?php
$filename = "http://www.phpfreaks.com/forums/index.php?action=profile;u=45841";
$handle = fopen($filename, "r");
$contents = fread($handle);
$strip = strip_tags($contents);
echo "$strip";
?>

 

anyone got any ideas?

 

thanks, Only

[[SOLVED] gathering from txt file]

hey thanks, got it working 

[[SOLVED] gathering from txt file]

hi, ive created alot of javascript functions for my mmorpg.. (eg. fishing, fighting) where players select options rather then just get the results of what happend (more intresting this way)

after the functions are finnished i insert the variables into a txt file, one problem im having is i want to insert it into my mysql database. im planing to include a file on every page that will gather the info and store it into the database.

 

how do i gather the information???

[Parse error: parse error, unexpected T_STRING]

whoops, thanks, i found my silly prob

 

[[SOLVED] Is there any thing worng witht htis code?]

try this

mysql_query("INSERT INTO dispo_tooSmall (`name`, `phone`) VALUES ('$row[fname]','$row[lname]')");

 

etc..

[Parse error: parse error, unexpected T_STRING]

hi, ive never come across this one..

 

Parse error: parse error, unexpected T_STRING in /home/www/onlyonerule.awardspace.com/tuts/image_gallery.php on line 63

 

heres line 63

 

$minrow = mysql_query("SELECT * FROM `tuts_image_gallery` WHERE id = '$minid'");

[stop showing errors]

is there a way to stop showing errors without useing @ before the function?

 

i dont want to edit my ini file because i still want the errors to show for when im making new stuff