PHP/MySQL Array - Codewalkers

Codewalkers Forums Sponsor:

October 24th, 2009, 12:07 PM

neex1233

Registered User

Join Date: Jun 2009

Posts: 16

Time spent in forums: 6 h 59 m 26 sec
Reputation Power: 0

PHP/MySQL Array

I have this bit of code which is supposed to be selecting all records from a table. Here:

PHP Code:


		
			
 $sql = "

SELECT * FROM `messages` WHERE `to` = '$username'

"; 

$result = mysql_query($sql) or die (mysql_error());



while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

{

$subject =  $row['subject'];

$from =  $row['from'];

$id = $row['id'];

$time = $row['time'];

}

It works but it is only selecting one of the records that is to that user(first one), then when that one is deleted it is showing the next record to them. What should I do? I just want it to show all records in the table that have their username for the 'to' field. Thanks!

October 24th, 2009, 06:03 PM

jamestrowbridge

Contributing User

Join Date: Jul 2008

Location: Cleveland, Ohio, USA

Posts: 411

Time spent in forums: 4 Days 18 h 54 m 24 sec
Reputation Power: 2

PHP Code:


		
			
 $sql = "SELECT * FROM messages WHERE to != '".NULL."'";

$result = mysql_query($sql) or die (mysql_error());



while ($row = mysql_fetch_array($result))

{

$subject =  $row['subject']; 

$from =  $row['from']; 

$id = $row['id']; 

$time = $row['time']; 

}

try that

EDIT: fixed the while line, thanks Llama

Comments on this post

IAmALlama agrees: you are missing a closing parenthesis on the like with the while loop.

__________________
Sir, a desire of knowledge is the natural feeling of mankind; and every human being, whose mind is not debauched, will be willing to give all that he has to get knowledge.

Last edited by jamestrowbridge : October 25th, 2009 at 03:54 AM.

October 25th, 2009, 01:20 AM

IAmALlama

Join Date: Apr 2007

Location: Seattle, WA

Posts: 1,937

Time spent in forums: 1 Week 5 Days 1 h 54 m 18 sec
Reputation Power: 4

if I had to guess, its because you are looping through the result and just setting the vars to the value and then after the loop echoing out the values in the vars. which would mean that you would only see the last message because on each loop you are just overwriting the value from the last message. you would need to do something like:

PHP Code:


		
			
 $sql = "

SELECT * FROM `messages` WHERE `to` = '$username'

";

$result = mysql_query($sql) or die (mysql_error());



while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

{

    $subject =  $row['subject'];

    $from =  $row['from'];

    $id = $row['id'];

    $time = $row['time'];

    echo "<div style='padding: 5px; border-bottom: 1px solid black;'><a href='?messageID=$id'>$subject - sent at $time from $from</a></div>";

}

if you could post more code it would also help. you are obviously not echoing anything out in the code you provided so speculation like this will be made.

Viewing: Codewalkers Forums > PHP Related > PHP Coding > PHP/MySQL Array

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
Request Your Free Technology Downloads!

Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
Request Your Free Technology Downloads!

Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
Request Your Free Technology Downloads!

Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
Request Your Free Technology Downloads!

Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
Request Your Free Technology Downloads!

More Free IT White Papers!