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.

dsaba, Thanks much for the help, yes I want to be able to store the image in a database. I just don't know what the code would be to actually use in the Admin Profile Update form is to be able to upload the image. Thats pretty much what I am looking for. I know the code to pull the info, just the code getting the info into the db is my problem, LOL. Again Thanks much for the help.

Hi All, I want to be able to add certain a few things into a Member Profile page that I currently have now. If I can get the help for ONLY one of the items I will be able to do the others with the same info pretty much. I currently run a Nascar Racing 2003 Season League and am looking for a few things. Right now I have a Roster/Member page, when someone clicks on a Members name it pulls a page up with their information. What I want to be able to do is display an image for that given person. I have a page in the Admin Section to where I can manage their stats and Stuff. So I want to be able to add an image from that page into the database for that members name and then display that image when a given members name has been selected in their Profile. I hope this makes sense, LOL. Thanks much for any help in advance. RSprinkel

Actually that worked. Again Thanks a bunch. Sent PM too.

Looks AWESOME! Thank you very very much. Very Much Appreciated. Now one small issue that I see and it is no biggie, but when I click the submit. and I am taking it I get a confirmation page as it shows: Payment status updated \nE-mail sent How do I get rid of the \n before E-Mail sent. I see it here: echo '<tr><td>Payment status updated<br>\n'; And when I try to remove the \n I get the following error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/domain/public_html/Join/Admin/dues.php on line 79 I mean it isn't a big deal, just curious.

Ok your script worked great. One thing though I am not to familiar with the html email as you have it. How would I go about using the email stuff that I have in the above post? I hope I am not being a pain, LOL.

Ok I just did a test and did not send or should I say email me as the user the information. This is my email setup at the bottom of the dues_process.php //insert info into dues table $sql = mysql_query ("INSERT INTO dues (username, date, amount, paidby, next, comments, email) VALUES('$username','$date','$amount','$paidby','$next','$comments','$email')") or die (mysql_error()); if(!$sql){ echo 'There has been an error processing your Payment Received. Please contact the webmaster.'; } // Let's mail the user! $subject = "Your Dues has been received!"; $message = "Dear $username, I am letting you know that your dues has been received and processed. Your next dues payment is due on $next Here is your Payment information received today: Date Received: $date Amount Received: $amount Paid By: $paidby Comments: $comments Thanks! LowRider League Owner/Admin This is an automated response, please do not reply!"; mail($email_address, $subject, $message, "From: Membership<site@email>\nX-Mailer: PHP/" . phpversion());

the field name is email

Ok I can't figure this out. I have tried a few things with the Dues entry page to pull the email address out of the same database as the user I am entering the dues from and to no avail I am not getting anything. The email addy is in the same database as the user. Anyways this is the code that I select the user from. <table cellpadding="10" cellspacing="0" align="center" style="font-size: 8pt"> <tr> <td align="left" valign="top">Username</td> <td>Choose a user: <select name="username"> <?php // assumes database connection already exists $query = "SELECT username from users"; $result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query); while ($row = mysql_fetch_array($result)) { echo "<option value='". $row['username']. "'>". $row['username']. "</option>\n"; } // close the loop, dummy ?> </select></td> <tr> <td align="left" valign="top">Date of Receipt<br>("mm/dd/yy")</td> <td><input name="date" type="text" id="date" value=""></td> </tr> <tr> <td align="left" valign="top">Amount</td> <td><input name="amount" type="text" id="amount" value=""></td> </tr> <tr> <td align="left" valign="top">Payment by</td> <td><input name="paidby" type="text" id="paidby" value=""></td> </tr> <tr> <td align="left" valign="top">Next Payment Due</td> <td><input name="next" type="text" id="next" value=""></td> </tr> <tr> <td align="left" valign="top">Comments:</td> <td><textarea name="comments" id="comments"></textarea></td> </tr> <td align="left" valign="top"> </td> <td><input type="submit" name="Submit" value="File Payment Received!"></td> </tr> </table> I can't for the life of me figure out how to get the user email addy to display to where I can send an email. I would like to have the email addy displayed to make sure the email is sent to the proper person. Any help is very much appreciated. Sorry for being such a newb. RSprinkel

Thanks for your reply Ok hmm thats the problem. I guess I will have to figure that one out. As the way it is set up it has a drop down list of the members names that I choose from and I am not too sure how to get that data to display on the dues page. These are scripts that have been given to me over the past year and I am trying to modify them to my needs and I am not a real good php editor at this time. Thanks to everyone else who replied with the help. Very Much Appreciated.

Ok with me being a newb at such stuff. Since there is no email address listed on this form or in that db, would I have to do a cross reference to another db to get that usernames email address for it to send that user an email? Thanks much for your reply. RSprinkel