[SOLVED] Displaying results in an array

[Wildhalf]

Hi All,

 

It's been a while since i played with PHP and i cant figure out how to fetch an entry in my MYSQL DB and display the results.

 

I thought something like the following would print out the username.

 

$result = mysql_query ("SELECT * FROM weight WHERE username='wildhalf'");
$data_result = mysql_fetch_array($result);

echo $data_result[username];

 

But how would i return all entries for a certain username, in the table and display them???

[revraz]

http://us3.php.net/foreach

[chigley]

<?php

$result = mysql_query("SELECT * FROM weight WHERE username = 'wildhalf'") or die(mysql_error());

while($date_result = mysql_fetch_assoc($result)) {
echo "{$data_result["username"]}<br />\n";
}

?>

 

That's the code.. seems pretty useless though as you know that all of the usernames will be 'wildhalf' due to your query!

[Wildhalf]

Thats ok I was only testing. Will change the username onc ei have everything else working. My own code works and so does code i want to put together with it. But when combined everything goes pear shaped....

 

Going to try one more thing and then ill post all the code for your help...

[redarrow]

corrected

<?php

$result = mysql_query("SELECT * FROM weight WHERE username = 'wildhalf'") or die(mysql_error());

while($data_result = mysql_fetch_assoc($result)) {
echo $data_result["username"];
}

?>

[chigley]

corrected

<?php

$result = mysql_query("SELECT * FROM weight WHERE username = 'wildhalf'") or die(mysql_error());

while($data_result = mysql_fetch_assoc($result)) {
echo $data_result["username"];
}

?>

 

I already posted that more or less lol?

[redarrow]

your while loop says date_result not data_result in your first post

[chigley]

Whoopsies

[redarrow]

and from php 6 we dont use the curly brace we replace it with the [  ]ok....

[chigley]

and from php 6 we dont use the curly brace we replace it with the [  ]ok....

 

I know.. but we're not on PHP6 yet, are we?

[redarrow]

you might not be but were very close, lots off pro bug php programmers are from the zend world lol.....

 

apart from that the code is useless

[chigley]

I won't start using PHP6 until it's properly released.

[adam291086]

hey guys if my host upgrades to php6 will all my code stop working? The current version of php i am using is php5

[redarrow]

your lucky a host use the php 5 version php 6 on a host will take ages and your code will be fine..

[adam291086]

yeah but that day will eventually come. What then?

[Wildhalf]

Thanks all for your help. Got everything working fine now it is one great tool i found for drwing graphs from database using flash and php..... http://www.maani.us

 

This will make the site im developing brilliant