RSprinkel

Hi All, I am trying to take a PHPNuke Block code and convert it to just plain PHP so I can add it on a page for itself. Anyone know how to do this? I have stripped out the block stuff at the top but for some reason I am getting this error: Fatal error: Call to a member function sql_query() on a non-object in /home/mydomain/public_html/bhdstats/block_Top5.php on line 64 Here is the code for this line well the line above it and below it as well: //Get information on ONLINE servers $sql = $db->sql_query("SELECT * FROM chronos_servers WHERE time>$offline ORDER BY name"); $content1 = ""; Any help on this would be greatly appreciated.

Hi all, Ok here is my problem. I am using a page that calls a .css file for all the text and stuff and it also has an include statement to call a head.htm file for the links and the logo. What I want to do is display a background image in the header section (head.htm) and a grey background in the main area. When I try to include the image in the header and and the grey background color in the main page I get the background image from the header all the way down the page. How can I do this with out having either an all grey page or a page with the header image all the way down the page? Thanks much in advance. RSprinkel

THanks much for the help. I see alot of good things there, LOL. Thanks again and much appreciated.

Hi All, I am currently looking for a Menu system that I can use images as the Main Menu, when an image is hovered over or clicked on it will have a drop down menu listing related items for that given Image. Is there anything out there that someone can suggest? I am not a coder and have no idea as to where to start such project. Thanks Much in advance. RSprinkel

Hi EvanAgee, Sorry for the delay in replying. Thanks for the info. However I am lost when using Javascripts. I have no clue as to include java in a page. I am currently setting this up in MS Frontpage. Again Thanks for the info. Looks good, but again No Clue, LOL.

Hi all, Am seeking some help on getting a drop down box setup to where when a User selects a certain item listed that it would display info from a link on the same page as the Drop Down but below it. I have never set anything up like this before and have absolutely no clue either. Thanks Much in advance. PS I have searched the forums and alot of the info I found would be good if I understood it alittle better.

Ok not working. It is not doing the query per member. If you go here http://www.cfrlracing.com on right hand side of the page you will see meet the drivers if you click on any name listed it shows the same for all and not for the selected driver. It has to query the win for the username $sierra first. Thanks UTAlan for all your help. Looks good though.

Also a Heading for the series, LOL Got the centering and color done.

OK, now we have it, THANKS very Much. I am now trying to get some color in there so we can see everything, LOL. Plus center the data. Again THANKS

Ok now we are getting somewhere, however it wants to place this in the wrong format. It is showing the data going across instead of down. Would that be the cause of the <tr?

UTAlan, Thanks for the reply. Well the first choice seems to be the easiest for me to understand, but I have removed the other table(s) and pasted what you posted now I am not getting anything displayed showing as far as a table. Now the 2 lines that you have commented out with // I even removed the // and still nothing. Boy this stuff is hard to grasp, LOL. Probably be easier for me to create seperate tables in the database and create something else, LOL. Just kidding.

Ok I got the syntax issue worked out. UTAlan, Thanks for the help. I guess I left something out when I posted my original message. We run 3 different series (Rookie, Truck, Cup) and I wanted 2 columns per series each series would have column 1 for date and column 2 for track. If you look here http://www.cfrlracing.com/VA/showprofile.php?sierra=S_White you will see mid way what I am trying to accomplish. Below what I am trying to accomplish is what I originally had. They both show the same when the one I am trying to do will break them down into each different series. Again thanks for the help, much appreciated.

Ok not sure I understand but this is what I did and now getting syntax error. So I KNOW I have something wrong, again I am a novice at this stuff, so please bare with me. <p align="center"> </p> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#C0C0C0" width="75%" id="AutoNumber2"> <tr> <td width="33%" align="center"><font color="#FFFFFF"><b>Rookie Series</b></font></td> <td width="33%" align="center"><font color="#FFFFFF"><b>Pro Truck Series</b></font></td> <td width="34%" align="center"><font color="#FFFFFF"><b>Pro Cup Series</b></font></td> </tr> </table> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#C0C0C0" width="75%" id="AutoNumber3"> <tr> <td width="16%" align="center"><font color="#00FFFF"><b>Date</b></font></td> <td width="17%" align="center"><font color="#00FFFF"><b>Track</b></font></td> <td width="16%" align="center"><font color="#00FFFF"><b>Date</b></font></td> <td width="17%" align="center"><font color="#00FFFF"><b>Track</b></font></td> <td width="17%" align="center"><font color="#00FFFF"><b>Date</b></font></td> <td width="17%" align="center"><font color="#00FFFF"><b>Track</b></font></td> </tr> </table> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#C0C0C0" width="75%" id="AutoNumber3"> <? $sql = "SELECT * FROM win WHERE sierra = '$sierra'"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) $nmod = $row['Truck']; $sql = "SELECT date, nmod FROM win WHERE nmod = '$mod'"; { ?> <tr style="color: #111111"> <td align="center"> <font color="#FFFF00"><?php echo $row["date"];?> </font></td> <td align="center"><font color="#FFFF00"><?php echo $row["track"];?></font></td> </tr> <? $sql = "SELECT * FROM win WHERE sierra = '$sierra'"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) $nmod = $row['Cup']; $sql = "SELECT date, nmod FROM win WHERE nmod = '$mod'"; { ?> <tr style="color: #111111"> <td align="center"> <font color="#FFFF00"><?php echo $row["date"];?> </font></td> <td align="center"><font color="#FFFF00"><?php echo $row["track"];?></font></td> </tr> <? $sql = "SELECT * FROM win WHERE sierra = '$sierra'"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) $nmod = $row['Rookie']; $sql = "SELECT date, nmod FROM win WHERE nmod = '$mod'"; { ?> <tr style="color: #111111"> <td align="center"> <font color="#FFFF00"><?php echo $row["date"];?> </font></td> <td align="center"><font color="#FFFF00"><?php echo $row["track"];?></font></td> </tr> </table> Again thanks for the help, it is much appreciated.

Ok I am not sure if this goes here or in the MySQL section, so Admins if it needs to be moved thats no problem. Anyways here is where I am at. I have a db table with the following Columns: ID, username, date, series, mod, location. The Mod has 3 different types of info. On one page I would like to have a Table displaying 3 different types of data from this one table in the db. First it would query the username as this is for a Profile page then query for the information. I have this for the Username query: <? $sql = "SELECT * FROM win WHERE sierra = '$sierra'"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { ?> The query would then have to search for different entries in that same MySQL Table for the Mod and display it in seperate columns. For instance my Displayed table will look as such. Column1 Column2 | Column3 Column4 | Column5 Column6 Date Mod1 Date Mod2 Date Mod3 Hope this is clear enough, LOL. I need more coffee I guess. Thanks much in advance.

Thanks again dsaba, yeah I as well am learning it too, slowly and when I can get the chance. Yeah I think I will go with the storing of the URL instead of the actual image. Makes more sense. Again Thanks for the help.