reaper7861

Ah yes sorry about that matt is on it already  ::)

are you asking how to connect to mysql using php? if so [code]$dbhost = "localhost"; $dbuser = "username"; $dbpass = "password"; $dbname = "databasename"; mysql_pconnect($dbhost,$dbuser,$dbpass)or die (mysql_error()); mysql_select_db($dbname)or die(mysql_error()); [/code] if thats not what your talking about please be more specific.

[code]$c_sql="Select * from table where row  ='$row'";   $res = @mysql_query($c_sql);   $r = @mysql_fetch_array($res); [/code] actually i just re-read your post and think im missunderstanding you or your asking for the column names themselves or the data inside them?

nevermind its complete i had to rewrite it differently, thanks for the help guys.

ok ive already pulled the information from the database in a var called $bwreset, so can you show me the syntax in which that would go from my members table. thanks

TYVM one last question i want to show the $r['bwreset'] as a date 30 days in the future in a Y-m-d format so i can see when it will reset i know how to echo and such but i just need to know how to show it 30days in the future as a date. Thanks once again for your uber help

i need to be able to make the following code get the creation date +30 days all the dates are set by DATE in mysql. any help would be greatly appreciated. This is my problem area $creationdate + (60*60*24*30) is this correct if not pls let me know what the correct syntax is thank you. [code]$creationdate = $r['bwreset'];           $currentdate = date("Y-m-d");           if($currentdate >= ($creationdate + (60*60*24*30))){  $ResetBW = "Update members set used_bw = '0',bwreset  ='$currentdate' where username = '" . $_POST['user_uname'] ."'";                 mysql_query($ResetBW) or die("BWRESET Failed"); [/code]

Ok i feel completely stupid now...i didnt even think about that....THANKS it works perfectly. $_GET['page'] worked perfect. Crazy

ok im using a page style such as index.php?page=main.php and want it to echo out the page its on for insertion into a tracking system, all i have gotten it to do so far is give index.php with phpself is there another function i could use to call the full page info,i need it to output the info after the ? such as page=main.php. Thanks in advance crazy

[!--quoteo(post=366371:date=Apr 19 2006, 06:40 AM:name=wisewood)--][div class=\'quotetop\']QUOTE(wisewood @ Apr 19 2006, 06:40 AM) [snapback]366371[/snapback][/div][div class=\'quotemain\'][!--quotec--] I may have misunderstood, as it seemed obvious... so let me know if i'm wrong. [code] echo '<center><TABLE Border="1" Cellpadding="0" Cellspacing="0">'; echo '<TD BGCOLOR ="#F8F8F8" WIDTH=200 HEIGHT=150 ALIGN=CENTER valign="top" align="center"><a align="middle" href="/info.php?id_pic='.$id.'"><img src="' . $description . '" /></a><br>'; echo '&nbsp;'.$com.'<br>Rating:&nbsp;'.$rates.'<br>&nbsp;Total Comments:&nbsp;'.$Total2.'<br><br></td>'; [/code] [/quote] yeah i was actually seeing how it looked on top wisewood, and everytime i put <tr></tr>'s in there it breaks my 3x3 table. but what i would like those 3 ,from exactly the way you have them, is to put them on the bottom of the 200x150 bg i have the pic in. but the pic needs to be centered. Thanks very much for your help.

[!--quoteo(post=366247:date=Apr 18 2006, 06:47 PM:name=Caesar)--][div class=\'quotetop\']QUOTE(Caesar @ Apr 18 2006, 06:47 PM) [snapback]366247[/snapback][/div][div class=\'quotemain\'][!--quotec--] [a href=\"http://www.phpfreaks.com/tutorials/43/0.php\" target=\"_blank\"]http://www.phpfreaks.com/tutorials/43/0.php[/a] [/quote] Agrees its perfect.

also what is your declaration for date $date=? cause you can also declare it look here [a href=\"http://us3.php.net/manual/en/ref.datetime.php\" target=\"_blank\"]http://us3.php.net/manual/en/ref.datetime.php[/a] or [a href=\"http://us3.php.net/manual/en/function.date.php\" target=\"_blank\"]http://us3.php.net/manual/en/function.date.php[/a] hope that helps, have a good day. GCT

what i have is a gallery of images in a 3x3 table what i need to do is get the comments the ratings and total comments to be all the way at the bottom of the cell in which the image is...its driving me crazy i add a tr and it messes the 3x3 table up. heres the code for it ill just post the echo statements as i think the problem resides in there. [code]echo '<center><TABLE Border="1" Cellpadding="0" Cellspacing="0">'; echo '<TD BGCOLOR ="#F8F8F8" WIDTH=200 HEIGHT=150 ALIGN=CENTER valign="top" align="center">&nbsp;'.$com.'<br>Rating:&nbsp;'.$rates.'<br>&nbsp;Total Comments:&nbsp;'.$Total2.'<br><br>'; echo '<a align="middle" href="/info.php?id_pic='.$id.'"><img src="' . $description . '" /></a></td>';[/code] if you need any of the other coding pls let me know, the 3x3 is working great so i dont know if its something i need to do in there or not. Thanks in advance