choosing field within a row

Zurke · #1 01-Mar-2005, 13:20

PHP 5.0.2
MySQL 4.1.7
Apache 1.3.33

Hi all,

I am allowing my members to change their usernames after registering. I would prefer that if they do change their usernames for use within the forums that their new name is displayed within my members page.

I have blindly tried some "if" statements but cant seem to get anything to work. Here is something I tried but it was fruitless. Any Ideas?

"newname is the name they could change to from username after registering"

PHP Code:


$query='SELECT newname, username, createdate FROM chmembers';
$result = mysqli_query($connection,$query);
if (!$result){
exit('unable to retrieve table mysql_error())';
}

while ($row = mysqli_fetch_array($result)){

$newname=$row[newname];
$createdate=$row[createdate];

"if ($row[newname]==0) {$newname = $row[username]};"

} 
mysqli_close ($connection);

<body>
<table>$newname</table>

#2 09-Mar-2005, 03:24

Quote:

"if ($row[newname]==0) {$newname = $row[username]};"

what does these quotes do here?...
And could you show your errror?

jmumm · #3 24-Mar-2005, 20:14

Why do you have a separate row for newname and username? Why not just update username and use that universally?

Anyways...

Why are there quotes around the if statment, I don't think those are supposed to be there.

One more syntax thing, and I'm not sure if it matters I always forget, but try putting single quotes when using the $row array, like...

Code:

$newname=$row['newname'];

Other than that the code makes sense to me.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Discussion] Choosing a Host	Cash	Web Hosting Forum	7	19-Sep-2005 06:21
User-agent field in robots.txt	JdS	Web Design Forum	7	02-Sep-2004 10:19
Choosing a Host	AuroraHost	Web Hosting Forum	0	17-Jan-2004 19:58
text field problm	zuzupus	Web Design Forum	3	04-Sep-2003 05:18
ambiguity in time field	zuzupus	MySQL / PHP Forum	9	28-Jul-2003 08:40