PHP - Displaying Only The First Part Of An Exploded Php String

Hi, i have written a section of code for my website and i have been trying to get it to work but whatever i try it will not work

Here is the code

Code: [Select]
$upgrade_user = mysql_query("SELECT * FROM user_info WHERE id='$id'");
while($row = mysql_fetch_array($upgrade_user)){
$real_balance = $row["$balance"];
$real_rank = $row["$rank"];
}

echo $real_balance;

if($real_rank == 'merchant' && $real_balance > '500'){
$n1x = '<a href="upgrades_info.php?userid=$id&rank=noble"><img src="images/noble.jpg" width="170" height="200" /></a>';
}
else
{
$n1x = '<img src="images/noblex.jpg" width="170" height="200" />';
}

It should outbut the first if, but instead it keeps displaying the else, i have checked the $real_rank and it matches merchant and the $real_balance is over 500.

Any ideas?

I am guessing its a simple error in the way i have written it, but i can't seem to get it to work.

Thanks

I'm using PHP to get a list of names from a mysql database, which then produces a drop down list for the user to select an option and then progress to the next page where the selection is displayed with other stuff. My problem is that my drop down list works fine, but when the user goes to the next page only the first part of the string is displayed, ie if the string is Fred Bloggs, only Fred is shown. I can get it to work by adding ' ' around the string name in the option section, but this shows 'Fred Bloggs' in the drop down list which isn't very pretty.

I haven't got the actual code to hand at the moment, but any ideas on where I'm going wrong?

Cheers

Code: [Select]
<?php 
$result = mysql_query("SELECT * 
FROM FamilyTbl
INNER JOIN PeopleTbl ON (FamilyTbl.Name_ID = PeopleTbl.NameID) 
WHERE FamilyTbl.House_ID = '$address'
ORDER BY NameLast, NameFirst
") OR die(mysql_error());

WHILE ($row = mysql_fetch_array($result) )  { 

   echo $row[NameLast]. ", ". $row[NamePrefix]. " ". $row[NameFirst]. " ". $row[NameMiddle]. $row[NameSuffix]. " "; 
}
?>

OK, some of these queries return A LOT of names.  I'd like to be able to display them in columns in a table like so:
Code: [Select]
Charne, Mr. Michael   Glanger, Mrs. Karin      Kling, Mr. Wayne 
Charne, Mrs. Suzette  Glanger, Mr. Trevor      Lazarow, Mrs. Fiona 
Charney, Mrs. Linda   Jochelson, Mrs. Barbara  Lazarow, Mr. Mark 
Charney, Mr. Norman   Jochelson, Mr. Neil      Norton, Mr. Charles 
Cohen, Mr. Brendan    Karlan, Mr. Dennis       Norton, Mrs. Jodi 
Cohen, Mrs. Joanna    Karlan, Mrs. Helen       Roy, Mr. Michael 
Flekser, Mrs. Jean    Kling, Mrs. Danielle     Roy, Mrs. Nicki 
Frysh, Dr. Howard     Kling, Mrs. Melanie      Tsafrir, Mrs. Lauren 
Frysh, Mrs. Sandra    Kling, Mr. Nevil         Tsafrir, Mr. Thomer 

That way it reads top to bottom THEN left to right.

math-wise, it's simple to set up:
Code: [Select]
$num_results = number_of_$results;
$numcols = 3;
$numrows = trunc($numresults/numcols);
<table>
for row_loop=1 to numrows
<tr>
for col_loop = 1 to numcols
<td>
echo result(col_loop-1)*(numrows)+row_loop
</td>
next col_loop
</tr>
next row_loop
</table>

Anyone want to give this a shot?

Revraz already directed me to http://www.phpfreaks.com/forums/index.php/topic,95426.0.html but that displayed the data from left to right then up to down like so:
Code: [Select]
Charne, Mr. Michael   Charne, Mrs. Suzette  Charney, Mrs. Linda 
Charney, Mr. Norman   Cohen, Mr. Brendan    Cohen, Mrs. Joanna 
Flekser, Mrs. Jean    Frysh, Dr. Howard     Frysh, Mrs. Sandra 
Glanger, Mrs. Karin   Glanger, Mr. Trevor   Jochelson, Mrs. Barbara 
Jochelson, Mr. Neil   Karlan, Mr. Dennis    Karlan, Mrs. Helen 
Kling, Mrs. Danielle  Kling, Mrs. Melanie   Kling, Mr. Nevil 
Kling, Mr. Wayne      Lazarow, Mrs. Fiona   Lazarow, Mr. Mark 
Norton, Mr. Charles   Norton, Mrs. Jodi     Roy, Mr. Michael 
Roy, Mrs. Nicki       Tsafrir, Mrs. Lauren  Tsafrir, Mr. Thomer 

It's a good temp solution, but if anyone is good with for loops, I'd appreciate the help, thanks!

-Dave

Let's say I have a variable called $big_paragraph

I want to display the variable IF it contains the word "hello".  The word may or may not be there AND it could be anywhere in that paragraph (separated by a space before and after it to signify that it is a word).  So I can't use substr since it assumes I know the position.

Thanks.

I have  string like this (without the spaces)

[ QUOTE="Adrock"]This is a test message[/QUOTE ]

How do i get just what is between the double quotes taking into account in the message there could be double quotes?

I've tried this but it doesn't echo anything unless i put the square brackets in but i want the username

$origauth = html_entity_decode($message);

$b = substr($origauth, strpos($origauth, '&#38;#034') + 1); 

$c = substr($b, 0, strpos($b, '&#38;#034')); 

echo $c;