Jump to content

just me and php

Members
 View Profile  See their activity

  • Posts

    59

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

just me and php's Achievements

Member

Member (2/5)

0

Reputation

  1. just me and php
    Thanks Il Try That
  2. just me and php
    Hi Im Not Real Good At Explaining What I Want So Please Bare With Me. I Have A Page On My Site That The Database Outputs To. There Is A User That I Dont Want To Ban Yet , But I Do Want To Block Or auto Delete His Data. Now When Everyone Post New Data The Only Table That Would identify Them Is The Username Table, There Is No Member ID Table. Now I Would Like To querry The Database And Auto Delete Table (Username) BOBBY And The Row BOBBY Posted , So There Is No Data Output To My Site Page For BOBBY. Can Someone Give Me A Couple Codes To Try, And I Would Think The Code Would Need To Be On A New Page That I Need To Make Up Right? Thanks
  3. just me and php
    thanks i think that will do it
  4. just me and php
    I search around but think im using wrong key words on internet what im looking for is how many times a name was posted to db in one table so i get and output of something like bob 300 times
  5. just me and php
    Thanks JJohnsenDK il give that a try it looks good and SSpoke I need to lern both the coding and logic i know that an im trying
  6. just me and php
    hmm ok the page outs a list as peeps post fast times list goes like this this if statement makes up the points if($i==0){$f1000='100';} if($i==1){$f1000='99';} if($i==2){$f1000='98';} if($i==3){$f1000='97';} if($i==4){$f1000='96';} points 1.blablabla 100 2.blablabla 99 3.blablabla 98 ect.... it also outputs total lap time this if statement makes up the points for total time if($i==0){$f2000='100';} if($i==1){$f2000='99';} if($i==2){$f2000='98';} if($i==3){$f2000='97';} if($i==4){$f2000='96';} points 1.blablabla 100 2.blablabla 99 3.blablabla 98 ect.... and yes this if statment makes no sence cause it dont work and im asking if there is a way to make it work if($f1000=$i+$f2000=$i){$f3000='sum';} so you take the 1. spot at top and added it to the number 1. spot at bottom and get 200 same as 2. 3. 4. 5. ect...
  7. just me and php
    Is there a way i can add these together and get the sum as a number if($i==0){$f1000='100';} if($i==1){$f1000='99';} if($i==2){$f1000='98';} if($i==3){$f1000='97';} if($i==4){$f1000='96';} if($i==0){$f2000='100';} if($i==1){$f2000='99';} if($i==2){$f2000='98';} if($i==3){$f2000='97';} if($i==4){$f2000='96';} if($f1000=$i+$f2000=$i){$f3000='sum';} echo "<td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolormp'><B>$f3000</B></font></a></td>\n"; and i get sum as output but i want a number not sum
  8. just me and php
    i have read it and i guess if i uderstood php better i wouldnt ask for help. but thanks anyway il figure it out
  9. just me and php
    here complete code with out any mods from here, i know its a mess but works and i changed all site info to mysite.com/bla <center><body bgcolor="#000000" text="#ffffff" link="gold" vlink="gold" alink="gold"> <SCRIPT language=JavaScript> function reload4(form) { var val3=form.subsubid.options[form.subsubid.options.selectedIndex].value; self.location='contest2.php?id=' + val3 ; } </script> </head> <body> <? require "configdelete2.php"; $id=$HTTP_GET_VARS['id']; // This line is added to take care if your global variable is off if(isset($id) and strlen($id) > 0) {$quer4=mysql_query("SELECT DISTINCT Trackname FROM TourneyData where disp=$id order by Trackname");} else{$quer4=mysql_query("SELECT DISTINCT Trackname FROM TourneyData order by Trackname");} echo "<form method=post name=f1 action=''>"; echo "<center><br /><br />"; echo "</select>"; echo "<center><b>CONTEST : </b>"; echo "<select name='subsubid' onchange=\"reload4(this.form)\"><option value=''>CONTEST</option>"; while($noticia = mysql_fetch_array($quer4)) { if($noticia['Trackname']==@$id4){echo "<option selected value='$noticia[Trackname]'>$noticia[Trackname]</option>"."<BR>";} else{echo "<option value='$noticia[Trackname]'>$noticia[Trackname]</option>";} } echo "</select>"; echo '<input name="select" type="hidden" value="select">' ; echo "</form></center>"; echo "<br>"; ?> </body> </html> <? $p_id = $_GET['id']; $sql="SELECT DATE_FORMAT(Startdate, '%m/%d/%y') AS Startdate, DATE_FORMAT(Enddate, '%m/%d/%y') AS Enddate,Round,Tourneyname,Racetype,Trackname,recno FROM TourneyData WHERE Trackname ='$p_id'ORDER BY 'recno'ASC "; $result=mysql_query($sql); ?> <?php while($rows=mysql_fetch_array($result)){ ?> <tr> <td>http://mysite.com<?echo $_SERVER["PHP_SELF"];?>?round=<?echo $rows['Round'];?>&start=<?echo $rows['Startdate'];?>&end=<?echo $rows['Enddate'];?>&track=<?echo $rows['Trackname'];?></font></a></td> </tr> <? // close while loop } // close connection; mysql_close(); ?> </table></td> </tr> </table> <?php require "config.php"; // All database details will be included here //$page_name="3newres.php"; $p_id = $_REQUEST['Round'];//round $p_id1 = $_REQUEST['Startdate'];//start date $p_id2 = $_REQUEST['Enddate'];//end date $p_id3 = $_REQUEST['Trackname'];//track $p_id = $_GET['round'];//round $p_id1 = $_GET['start'];//start date $p_id2 = $_GET['end'];//end date $p_id3 = $_GET['track'];//track $p_id4 = '1';//SERIES Number $p_id5 = '2007';//SERIES year //$p_id6 = $_GET['cc'];//bike cc or 600,520,500,426,400,250,125 //$p_id4 = $_GET['var4'];//SERIES Number //$p_id5 = $_GET['var5'];//SERIES year //require "contestrounds.php"; echo "<table bordercolor='green' border='5'><tr>"; $query = "SELECT DATE_FORMAT(date, '%h:%i %p') AS time, recno,MAX(disp) AS disp,track,Username,MAX(date) AS date,MAX(online) AS online, MIN(HL_MS) AS HL_MS,reshack,hacked FROM NatHotLap WHERE date > '$p_id1' AND date < '$p_id2'AND track= '$p_id3'AND disp GROUP BY 'Username','track' ORDER BY 'HL_MS' ASC "; $result = mysql_query($query) or die("There was a problem with the SQL query: " . mysql_error()); $i = 0; $rank = 0; $max_rows = 75; $num_rows=mysql_num_rows($result); while($row = mysql_fetch_array($result)) { $fHL_F= $row[HL_F]; $f1= $row[recno]; $f2 = $row[disp]; $f3 = $row[HL_MS]; $f4 = $row[track]; $f5 = $row[username]; $f6 = $row[date]; $f7 = $row[TRT_MS]; if($bgcolor=='#000000'){$bgcolor='#000000';} else{$bgcolor='#000000';} if($row[online]=='Y'){$fontcolor ='#00FF00';} if($row[online]=='N'){$fontcolor ='#FF0000';} if($row[MP]=='Y'){$fontcolormp ='#00FF00';} if($row[MP]=='N'){$fontcolormp ='#FF0000';} if($row[date]=='C'){$f2='';} if($row[date]=='C'){$f3='';} if($row[date]=='C'){$f4='';} if($row[date]=='C'){$f5='';} if($row[date]=='C'){$f6='';} if($row[date]=='C'){$f7='';} if($row[date]=='C'){$f8='';} if($row[date]=='C'){$f9='';} if($row[date]=='C'){$f10='';} if($row[date]=='C'){$f11='';} if($row[date]=='C'){$f12='';} if($row[date]=='C'){$fHL_F='';} if($row[date]=='C'){$f13='';} if($row[reshack]=='C'){$f1='';} if($row[reshack]=='C'){$f2='';} if($row[reshack]=='C'){$f3='';} if($row[reshack]=='C'){$f4='';} if($row[reshack]=='C'){$f5='';} if($row[reshack]=='C'){$f6='';} if($row[reshack]=='C'){$f7='';} if($row[reshack]=='C'){$f8='';} if($row[reshack]=='C'){$f9='';} if($row[reshack]=='C'){$f10='';} if($row[reshack]=='C'){$f11='';} if($row[reshack]=='C'){$f12='';} if($row[reshack]=='C'){$fHL_F='';} if($row[reshack]=='C'){$f13='';} if($row[hacked]=='1'){$f1='';} if($row[hacked]=='1'){$f2='';} if($row[hacked]=='1'){$f3='';} if($row[hacked]=='1'){$f4='';} if($row[hacked]=='1'){$f5='';} if($row[hacked]=='1'){$f6='';} if($row[hacked]=='1'){$f7='';} if($row[hacked]=='1'){$f8='';} if($row[hacked]=='1'){$f9='';} if($row[hacked]=='1'){$f10='';} if($row[hacked]=='1'){$f11='';} if($row[hacked]=='1'){$f12='';} if($row[hacked]=='1'){$fHL_F='';} if($row[hacked]=='3'){$f1='';} if($row[hacked]=='3'){$f2='';} if($row[hacked]=='3'){$f3='';} if($row[hacked]=='3'){$f4='';} if($row[hacked]=='3'){$f5='';} if($row[hacked]=='3'){$f6='';} if($row[hacked]=='3'){$f7='';} if($row[hacked]=='3'){$f8='';} if($row[hacked]=='3'){$f9='';} if($row[hacked]=='3'){$f10='';} if($row[hacked]=='3'){$f11='';} if($row[hacked]=='3'){$f12='';} if($row[hacked]=='3'){$fHL_F='';} if($row[hacked]=='4'){$f1='';} if($row[hacked]=='4'){$f2='';} if($row[hacked]=='4'){$f3='';} if($row[hacked]=='4'){$f4='';} if($row[hacked]=='4'){$f5='';} if($row[hacked]=='4'){$f6='';} if($row[hacked]=='4'){$f7='';} if($row[hacked]=='4'){$f8='';} if($row[hacked]=='4'){$f9='';} if($row[hacked]=='4'){$f10='';} if($row[hacked]=='4'){$f11='';} if($row[hacked]=='4'){$f12='';} if($row[hacked]=='4'){$fHL_F='';} if($row[hacked]=='8'){$f1='';} if($row[hacked]=='8'){$f2='';} if($row[hacked]=='8'){$f3='';} if($row[hacked]=='8'){$f4='';} if($row[hacked]=='8'){$f5='';} if($row[hacked]=='8'){$f6='';} if($row[hacked]=='8'){$f7='';} if($row[hacked]=='8'){$f8='';} if($row[hacked]=='8'){$f9='';} if($row[hacked]=='8'){$f10='';} if($row[hacked]=='8'){$f11='';} if($row[hacked]=='8'){$f12='';} if($row[hacked]=='8'){$fHL_F='';} if($row[hacked]=='9'){$f1='';} if($row[hacked]=='9'){$f2='';} if($row[hacked]=='9'){$f3='';} if($row[hacked]=='9'){$f4='';} if($row[hacked]=='9'){$f5='';} if($row[hacked]=='9'){$f6='';} if($row[hacked]=='9'){$f7='';} if($row[hacked]=='9'){$f8='';} if($row[hacked]=='9'){$f9='';} if($row[hacked]=='9'){$f10='';} if($row[hacked]=='9'){$f11='';} if($row[hacked]=='9'){$f12='';} if($row[hacked]=='9'){$fHL_F='';} if($row[hacked]=='12'){$f1='';} if($row[hacked]=='12'){$f2='';} if($row[hacked]=='12'){$f3='';} if($row[hacked]=='12'){$f4='';} if($row[hacked]=='12'){$f5='';} if($row[hacked]=='12'){$f6='';} if($row[hacked]=='12'){$f7='';} if($row[hacked]=='12'){$f8='';} if($row[hacked]=='12'){$f9='';} if($row[hacked]=='12'){$f10='';} if($row[hacked]=='12'){$f11='';} if($row[hacked]=='12'){$f12='';} if($row[hacked]=='12'){$fHL_F='';} //if($row[display]=='N'){$f2='';} //if($row[display]=='N'){$f3='';} //if($row[display]=='N'){$f4='';} //if($row[display]=='N'){$f5='';} //if($row[display]=='N'){$f6='';} //if($row[display]=='N'){$f7='';} if($row[display]=='N'){$f1='';} if($row[display]=='N'){$f2='';} if($row[display]=='N'){$f3='';} if($row[display]=='N'){$f4='';} if($row[display]=='N'){$f5='';} if($row[display]=='N'){$f6='';} if($row[display]=='N'){$f7='';} if($row[display]=='N'){$f8='';} if($row[display]=='N'){$f9='';} if($row[display]=='N'){$f10='';} if($row[display]=='N'){$f11='';} if($row[display]=='N'){$f12='';} if($row[display]=='N'){$fHL_F='';} if($row[display]=='N'){$f13='';} //if($i==0){$f1000='POINTS';} if($i==0){$f1000='100';} if($i==1){$f1000='99';} if($i==2){$f1000='98';} if($i==3){$f1000='97';} if($i==4){$f1000='96';} if($i==5){$f1000='95';} if($i==6){$f1000='94';} if($i==7){$f1000='93';} if($i=={$f1000='92';} if($i==9){$f1000='91';} if($i==10){$f1000='90';} if($i==11){$f1000='89';} if($i==12){$f1000='88';} if($i==13){$f1000='87';} if($i==14){$f1000='86';} if($i==15){$f1000='85';} if($i==16){$f1000='84';} if($i==17){$f1000='83';} if($i==18){$f1000='82';} if($i==19){$f1000='81';} if($i==20){$f1000='80';} if($i==21){$f1000='79';} if($i==22){$f1000='78';} if($i==23){$f1000='77';} if($i==24){$f1000='76';} if($i==25){$f1000='75';} if($i==26){$f1000='74';} if($i==27){$f1000='73';} if($i==28){$f1000='72';} if($i==29){$f1000='71';} if($i==30){$f1000='70';} if($i==31){$f1000='69';} if($i==32){$f1000='68';} if($i==33){$f1000='67';} if($i==34){$f1000='66';} if($i==35){$f1000='65';} if($i==36){$f1000='64';} if($i==37){$f1000='63';} if($i==38){$f1000='62';} if($i==39){$f1000='61';} if($i==40){$f1000='60';} if($i==41){$f1000='59';} if($i==42){$f1000='58';} if($i==43){$f1000='57';} if($i==44){$f1000='56';} if($i==45){$f1000='55';} if($i==46){$f1000='54';} if($i==47){$f1000='53';} if($i==48){$f1000='52';} if($i==49){$f1000='51';} if($i==50){$f1000='50';} if($i==51){$f1000='49';} if($i==52){$f1000='48';} if($i==53){$f1000='47';} $i++; $rank++; $br++; if($i == 1){ echo "<td valign='top'>\n"; echo "<table>\n"; } if($rank == 1){ echo "<td valign='top'>\n"; echo "<table>\n"; } if($i<=$max_rows){ echo "<td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><B>$rank.</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolor'><B>$f3</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolor'><B>$f2</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><a href='members_1.php?id=$f5'><B>$f5</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolor'><B>$f6</B></font></a></td>\n"; echo "<td><td><td><td><td><td>"; echo "<td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><B>$f1000</B></font></a></td>\n"; echo "<tr><td>$row[iD]</td></tr>\n"; } if($i==$max_rows||$br==$num_rows){ echo "</table>\n</td>\n"; echo "<font face='Verdana' size='2'><font color='#00FF00'><B>TRACK LINK <IMG SRC='themes/hl.jpg' border='0' width='20' hieght='20'><a href='http://mysite.com/bla/bla/bla.php?album=search&type=full&search=$f4'>$f4</a><IMG SRC='themes/hl.jpg' border='0' width='20' hieght='20'> ROUND $p_id $p_id6 ---------- POINTS</B></font></a>"; $i=0; } } require "trtconfig.php"; // All database details will be included here $page_name="3newres.php"; $p_id = $_GET['round'];//round $p_id1 = $_GET['start'];//start date $p_id2 = $_GET['end'];//end date $p_id3 = $_GET['track'];//track $p_id4 = '1';//SERIES Number $p_id5 = '2007';//SERIES year //$p_id6 = $_GET['cc'];//bike cc or 600,520,500,426,400,250,125 //$p_id4 = $_GET['var4'];//SERIES Number //$p_id5 = $_GET['var5'];//SERIES year //require "contestrounds.php"; echo "<tr><tr>"; $query = "SELECT DATE_FORMAT(date, '%h:%i %p') AS time, recno,MAX(disp) AS disp,track,Username,MAX(date) AS date,MAX(online) AS online, MIN(TRT_MS) AS TRT_MS,reshack,hacked FROM NatTRT WHERE date > '$p_id1' AND date < '$p_id2'AND track= '$p_id3'AND disp GROUP BY 'Username','track' ORDER BY 'TRT_MS' ASC "; $result = mysql_query($query) or die("There was a problem with the SQL query: " . mysql_error()); $i = 0; $rank = 0; $max_rows = 75; $num_rows=mysql_num_rows($result); while($row = mysql_fetch_array($result)) { $fHL_F= $row[HL_F]; $f1= $row[recno]; $f2 = $row[disp]; $f3 = $row[TRT_MS]; $f4 = $row[track]; $f5 = $row[username]; $f6 = $row[date]; $f7 = $row[TRT_MS]; if (strlen($f3) == 7) {$f3 = '0'.$f3;} if($bgcolor=='#000000'){$bgcolor='#000000';} else{$bgcolor='#000000';} if($row[online]=='Y'){$fontcolor ='#00FF00';} if($row[online]=='N'){$fontcolor ='#FF0000';} if($row[MP]=='Y'){$fontcolormp ='#00FF00';} if($row[MP]=='N'){$fontcolormp ='#FF0000';} //if($row[date]=='C'){$f2='';} //if($row[date]=='C'){$f3='';} //if($row[date]=='C'){$f4='';} //if($row[date]=='C'){$f5='';} //if($row[date]=='C'){$f6='';} //if($row[date]=='C'){$f7='';} //if($row[date]=='C'){$f8='';} //if($row[date]=='C'){$f9='';} // //if($row[date]=='C'){$f10='';} //if($row[date]=='C'){$f11='';} //if($row[date]=='C'){$f12='';} //if($row[date]=='C'){$fHL_F='';} //if($row[date]=='C'){$f13='';} if($row[reshack]=='C'){$f1='';} if($row[reshack]=='C'){$f2='';} if($row[reshack]=='C'){$f3='';} if($row[reshack]=='C'){$f4='';} //if($row[reshack]=='C'){$f5='';} if($row[reshack]=='C'){$f6='';} if($row[reshack]=='C'){$f7='';} if($row[reshack]=='C'){$f8='';} if($row[reshack]=='C'){$f9='';} if($row[reshack]=='C'){$f10='';} if($row[reshack]=='C'){$f11='';} if($row[reshack]=='C'){$f12='';} if($row[reshack]=='C'){$fHL_F='';} if($row[reshack]=='C'){$f13='';} if($row[hacked]=='1'){$f1='';} if($row[hacked]=='1'){$f2='';} if($row[hacked]=='1'){$f3='';} if($row[hacked]=='1'){$f4='';} //if($row[hacked]=='1'){$f5='';} if($row[hacked]=='1'){$f6='';} if($row[hacked]=='1'){$f7='';} if($row[hacked]=='1'){$f8='';} if($row[hacked]=='1'){$f9='';} if($row[hacked]=='1'){$f10='';} if($row[hacked]=='1'){$f11='';} if($row[hacked]=='1'){$f12='';} if($row[hacked]=='1'){$fHL_F='';} if($row[hacked]=='3'){$f1='';} if($row[hacked]=='3'){$f2='';} if($row[hacked]=='3'){$f3='';} if($row[hacked]=='3'){$f4='';} //if($row[hacked]=='3'){$f5='';} if($row[hacked]=='3'){$f6='';} if($row[hacked]=='3'){$f7='';} if($row[hacked]=='3'){$f8='';} if($row[hacked]=='3'){$f9='';} if($row[hacked]=='3'){$f10='';} if($row[hacked]=='3'){$f11='';} if($row[hacked]=='3'){$f12='';} if($row[hacked]=='3'){$fHL_F='';} if($row[hacked]=='4'){$f1='';} if($row[hacked]=='4'){$f2='';} if($row[hacked]=='4'){$f3='';} if($row[hacked]=='4'){$f4='';} //if($row[hacked]=='4'){$f5='';} if($row[hacked]=='4'){$f6='';} if($row[hacked]=='4'){$f7='';} if($row[hacked]=='4'){$f8='';} if($row[hacked]=='4'){$f9='';} if($row[hacked]=='4'){$f10='';} if($row[hacked]=='4'){$f11='';} if($row[hacked]=='4'){$f12='';} if($row[hacked]=='4'){$fHL_F='';} if($row[hacked]=='8'){$f1='';} if($row[hacked]=='8'){$f2='';} if($row[hacked]=='8'){$f3='';} if($row[hacked]=='8'){$f4='';} //if($row[hacked]=='8'){$f5='';} if($row[hacked]=='8'){$f6='';} if($row[hacked]=='8'){$f7='';} if($row[hacked]=='8'){$f8='';} if($row[hacked]=='8'){$f9='';} if($row[hacked]=='8'){$f10='';} if($row[hacked]=='8'){$f11='';} if($row[hacked]=='8'){$f12='';} if($row[hacked]=='8'){$fHL_F='';} if($row[hacked]=='9'){$f1='';} if($row[hacked]=='9'){$f2='';} if($row[hacked]=='9'){$f3='';} if($row[hacked]=='9'){$f4='';} //if($row[hacked]=='9'){$f5='';} if($row[hacked]=='9'){$f6='';} if($row[hacked]=='9'){$f7='';} if($row[hacked]=='9'){$f8='';} if($row[hacked]=='9'){$f9='';} if($row[hacked]=='9'){$f10='';} if($row[hacked]=='9'){$f11='';} if($row[hacked]=='9'){$f12='';} if($row[hacked]=='9'){$fHL_F='';} if($row[hacked]=='12'){$f1='';} if($row[hacked]=='12'){$f2='';} if($row[hacked]=='12'){$f3='';} if($row[hacked]=='12'){$f4='';} //if($row[hacked]=='12'){$f5='';} if($row[hacked]=='12'){$f6='';} if($row[hacked]=='12'){$f7='';} if($row[hacked]=='12'){$f8='';} if($row[hacked]=='12'){$f9='';} if($row[hacked]=='12'){$f10='';} if($row[hacked]=='12'){$f11='';} if($row[hacked]=='12'){$f12='';} if($row[hacked]=='12'){$fHL_F='';} //if($row[display]=='N'){$f2='';} //if($row[display]=='N'){$f3='';} //if($row[display]=='N'){$f4='';} //if($row[display]=='N'){$f5='';} //if($row[display]=='N'){$f6='';} //if($row[display]=='N'){$f7='';} if($row[display]=='N'){$f1='';} if($row[display]=='N'){$f2='';} if($row[display]=='N'){$f3='';} if($row[display]=='N'){$f4='';} //if($row[display]=='N'){$f5='';} if($row[display]=='N'){$f6='';} if($row[display]=='N'){$f7='';} if($row[display]=='N'){$f8='';} if($row[display]=='N'){$f9='';} if($row[display]=='N'){$f10='';} if($row[display]=='N'){$f11='';} if($row[display]=='N'){$f12='';} if($row[display]=='N'){$fHL_F='';} if($row[display]=='N'){$f13='';} if($i==0){$f1000='100';} if($i==1){$f1000='99';} if($i==2){$f1000='98';} if($i==3){$f1000='97';} if($i==4){$f1000='96';} if($i==5){$f1000='95';} if($i==6){$f1000='94';} if($i==7){$f1000='93';} if($i=={$f1000='92';} if($i==9){$f1000='91';} if($i==10){$f1000='90';} if($i==11){$f1000='89';} if($i==12){$f1000='88';} if($i==13){$f1000='87';} if($i==14){$f1000='86';} if($i==15){$f1000='85';} if($i==16){$f1000='84';} if($i==17){$f1000='83';} if($i==18){$f1000='82';} if($i==19){$f1000='81';} if($i==20){$f1000='80';} if($i==21){$f1000='79';} if($i==22){$f1000='78';} if($i==23){$f1000='77';} if($i==24){$f1000='76';} if($i==25){$f1000='75';} if($i==26){$f1000='74';} if($i==27){$f1000='73';} if($i==28){$f1000='72';} if($i==29){$f1000='71';} if($i==30){$f1000='70';} if($i==31){$f1000='69';} if($i==32){$f1000='68';} if($i==33){$f1000='67';} if($i==34){$f1000='66';} if($i==35){$f1000='65';} if($i==36){$f1000='64';} if($i==37){$f1000='63';} if($i==38){$f1000='62';} if($i==39){$f1000='61';} if($i==40){$f1000='60';} if($i==41){$f1000='59';} if($i==42){$f1000='58';} if($i==43){$f1000='57';} if($i==44){$f1000='56';} if($i==45){$f1000='55';} if($i==46){$f1000='54';} if($i==47){$f1000='53';} if($i==48){$f1000='52';} if($i==49){$f1000='51';} if($i==50){$f1000='50';} if($i==51){$f1000='49';} if($i==52){$f1000='48';} if($i==53){$f1000='47';} if (strlen($f3) == 7) {$f3 = '0'.$f3;} $i++; $rank++; $br++; if($i == 1){ echo "<td valign='top'>\n"; echo "<table>\n"; } if($rank == 1){ echo "<td valign='top'>\n"; echo "<table>\n"; } if($i<=$max_rows){ echo "<td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><B>$rank.</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolor'><B>$f3</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolor'><B>$f2</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><a href='members_1.php?id=$f5'><B>$f5</B></font></a></td>\n"; echo "<td><td><td><td><td><td><td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><font color='$fontcolor'><B>$f6</B></font></a></td>\n"; echo "<td><td><td><td><td><td>"; echo "<td align=left bgcolor=$bgcolor id='title'><font face='Verdana' size='2'><B>$f1000</B></font></a></td>\n"; echo "<tr><td>$row[iD]</td></tr>\n"; } if($i==$max_rows||$br==$num_rows){ echo "</table>\n</td>\n"; $i=0; } } echo "<font face='Verdana' size='2'><font color='#00FF00'><B>$p_id3 </a><IMG SRC='themes/hl.jpg' border='0' width='20' hieght='20'> TRT's <IMG SRC='themes/hl.jpg' border='0' width='20' hieght='20'></a> ROUND $p_id $p_id6 -------------- POINTS</B></font></a>"; ?> </tr></table></center>
  10. just me and php
    hmm i get error with that Warning: Cannot modify header information - headers already sent by (output started at /home/bla/public_html/bla/bla:3) in /home/bla/public_html/bla/bla.php on line 14
  11. just me and php
    yes i would like the return go up to the url insted of printing it on page
  12. just me and php
    this prints to page no problem but is there a way that it would be hidden and prints it to url ? http://bla.com/bla/bla.php?round=2&start=01/01/07&end=01/08/07&track=bla <td bgcolor="#000000"><font color='$fontcolor'><?echo $_SERVER["PHP_SELF"];?>?round=<?echo $rows['Round'];?>&start=<?echo $rows['Startdate'];?>&end=<?echo $rows['Enddate'];?>&track=<?echo $rows['Trackname'];?></font></a></td>
  13. just me and php
    PERFECT Thanks offsprg01 That Works Great
  14. just me and php
    hmm that example i dont understand how it could be used to add a 0 in front of numbers below 10:00.00 like 09:99.99 <?php $str = 'abcdef'; echo strlen($str); // 6 $str = ' ab cd '; echo strlen($str); // 7 ?>
  15. just me and php
    from a table in my database i get a set of numbers like this 1. 10:06.52 2. 10:06.93 3. 10:10.54 4. 11:18.65 5. 7:52.39 6. 8:01.51 7. 8:37.37 8. 8:41.01 9. 8:43.79 10. 9:05.03 11. 9:17.96 12. 9:19.29 13. 9:23.45 14. 9:25.03 15. 9:25.78 16. 9:33.70 but i would like it to be this 1. 07:52.39 2. 08:01.51 3. 08:37.37 4. 08:41.01 5. 08:43.79 6. 09:05.03 7. 09:17.96 8. 09:19.29 9. 09:23.45 10. 09:25.03 11. 09:25.78 12. 09:33.70 13. 10:06.52 14. 10:06.93 15. 10:10.54 16. 11:18.65 is there a way i could add an if (statement) or something in my sqlquery ??to add a 0 in front of all numbers below 10:00.00
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.