TalkPHP - View Single Post - whats wrong? - i know i missed some simple thing but well help please :)

codefreek · 06-26-2008, 05:31 PM

LOOK DOWN FOR HELPING ME ON A OTHER PROBLEM

PHP Code:


			
<?php
error_reporting(E_ALL & ~E_NOTICE);
include("db_connect.php");

$sql = "SELECT * FROM `users` WHERE `id` = '".$id."'";
                $query = mysql_query($sql) or die(mysql_error());
        while($sel_table = mysql_fetch_array($query)) 
        {
  print $sel_table['username'];

}
    $net = "UPDATE `users` SET `username` = '".$username."', `password` = '".$password."' WHERE `id` = '".$id."'";
    $web_result = mysql_query($net) or die(mysql_error());


?>

no errors are made i am trying to do print $sel_table['username'] or even post the id or something but for some reason it do not print..

so please tell me whats wrong :S

//Code,-No flame please ;)-

Code:

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL,
  `password` varchar(40) NOT NULL,
  `email` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

LOOK DOWN FOR HELPING ME ON A OTHER PROBLEM

06-26-2008, 05:31 PM	#1 (permalink)
codefreek Super Moderator Join Date: Sep 2007 Location: Near you. Posts: 791 Thanks: 241	New Problem - Help is needed Ty in adv! LOOK DOWN FOR HELPING ME ON A OTHER PROBLEM PHP Code: <?php error_reporting(E_ALL & ~E_NOTICE); include("db_connect.php"); $sql = "SELECT * FROM `users` WHERE `id` = '".$id."'"; $query = mysql_query($sql) or die(mysql_error()); while($sel_table = mysql_fetch_array($query)) { print $sel_table['username']; } $net = "UPDATE `users` SET `username` = '".$username."', `password` = '".$password."' WHERE `id` = '".$id."'"; $web_result = mysql_query($net) or die(mysql_error()); ?> no errors are made i am trying to do print $sel_table['username'] or even post the id or something but for some reason it do not print.. so please tell me whats wrong :S //Code,-No flame please ;)- Code: CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `password` varchar(40) NOT NULL, `email` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; LOOK DOWN FOR HELPING ME ON A OTHER PROBLEM __________________ Codefreek's - News Letter, Tech, & some random ramblings Last edited by codefreek : 06-26-2008 at 09:56 PM. Reason: Look down for new problem!