Lamez

I am going to take a shot in the dark, maybe asp, I have no idea though, or js

you have your values all mixed up, you need to make sure it looks like the database say your DB looks like username password email then your query needs to look like $sql="INSERT INTO `user` (`username`, `password`, `email`) VALUES ( '$username', '$password', '$email')"; yours looks like $sql="INSERT INTO `user` (`username`, `password`, `email`) VALUES ( '$username', '$email', '$password')";

I am not too sure what your problem is, but if you want people to help you, it might be a wise to use the code tags " my code " just a little side note

like from the message board? the output of lastrepliedto?

any help? should I post the rest of the scripts?

You could do this add the title.php as a include ( include "title.php"; ) and in title.php: Website Name :: <?php switch ($title) { case 'home': echo "Home"; break; case 'login': echo "Login"; break; case 'register': echo "Register"; break; case 'spay': echo "Start Playing"; break; } ?> index.php or what ever you want: $title="home"; <title><?php include ("title.php"); ?> </title> -Any Help?

when I sort by DESC, the new post are at the bottom and in lastrepliedto: lastrepliedto='$thedate' and thedate is: $thedate=date("U"); //get unix timestamp $displaytime=date("F j, Y, g:i a");

It is not very hard, and most CMS sites have a support area on helping you install their system. 1.Download CMS of choice 2.Upload CMS of choice to Webserver of choice 3.Make a Database 4.find the install directory, and go from there. -Good luck!

Hi guys, On my message board it is suppose to post the new topic at top, well it does that, but then when there is about two more it starts posting the topics in the middle of the board, I am not too sure why. here is how it orders: $getthreads="SELECT * from forum where parentid='0' order by lastrepliedto ASC"; here is the whole code: <?php include "connect.php"; //mysql db connection here print '<div class="box">'; if($session->logged_in){ print "<link rel='stylesheet' href='style.css' type='text/css'>"; print "<p align='right'><A href='post.php'><img src='img/topic.png' border='0' alt='New Topic' /></a><br></p>"; print "<table class='maintable'>"; print "<tr class='headline'><td width=50%>Topic</td><td width=20%>Topic Starter</td><td>Replies</td><td>Last replied time</td></tr>"; $getthreads="SELECT * from forum where parentid='0' order by lastrepliedto ASC"; $getthreads2=mysql_query($getthreads) or die("Could not get threads"); while($getthreads3=mysql_fetch_array($getthreads2)) { $getthreads3[title]=strip_tags($getthreads3[title]); $getthreads3[author]=strip_tags($getthreads3[author]); print "<tr class='mainrow'><td><A href='message.php?id=$getthreads3[postid]'>$getthreads3[title]</a>"; print "</td><td align='center' valign='middle'><a href='../userinfo.php?user=$getthreads3[author]'>$getthreads3[author]</a></td><td align='center' valign='middle'>$getthreads3[numreplies]</td><td>$getthreads3[showtime]<br>Last post by <b><a href='../userinfo.php?user=$getthreads3[lastposter]'>$getthreads3[lastposter]</a></b></td></tr>"; } print "</table>"; print "<p align='right'><A href='post.php'><img src='img/topic.png' border='0' alt='New Topic' /></a><br></p>"; }else{ include ("../../style/include/cons/member.php"); } print '</div>'; include ("../../style/include/cons/foot.php"); ?> does anyone see where my problem is? Thanks guys!

:-\

I thinks you would need to upload it to the server, then change it in the CSS, and use '' around the font for example font-family:Verdana, Arial, Helvetica, sans-serif, 'mynewfont'; make sure the font is in the same directory as the style sheet

do a google search on MySQL and here is some functions, and what not http://www.pantz.org/software/mysql/mysqlcommands.html good luck!

alright I did that, I went in my DB using Phpmyadmin, and set the default value to the image I wanted, then I set it to "not null", and when I register a new user, it does not show the default user, then I look in the DB and the avatar is not set.

well, I am not too sure if default is they way I need to go I want a default avatar if they do not set one, what would the best way to go about this?

well what about the alter table? would this work? ALTER TABLE `users` CHANGE `avatar` `avatar` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'http://www.lamezz.info/user/userava/default.jpeg'

alright, I will have to look that up, thanks

right, I could use a query right? but how would I alter a existing row inside a table? table = users row = avatar -I am not too sure, thanks!

bump

I have a avatar field under a table I want to set a value for, so if they do not select a avatar, it shows a default one.

how do I set a default value in MySQL? or using a PHP script? thanks guys!

oh ok thanks guys!

How do I delete a row from a mysql database in php?

I use to have a PHP proxy, worked great.

alright, but then how would I use it with this? {$row['title']} would it be: $title = str_replace("_", " ", {$row['title']});

oh, well then how do I link to the message? that is the only way I know how to link