[SOLVED] Trouble with "WHILE" loops

[netrunnr]

Hello There People!!

 

I'm hacing a slight issue with While loops, can anyone help?

 

                  <?php

					$Sno = 1;
					$pGTotal = 0;

					if(!(session_register('login')))
					{
						$query = "SELECT * FROM userordersdetail WHERE order_id=".$oid."";									
						$result_orderdetails = mysql_query($query)or die("error".mysql_error());
						$rownum = mysql_num_rows($result_orderdetails);

						if($rownum > 0)
						{
							while($res_order = mysql_fetch_array($result_orderdetails))
							{
								$pPrice = $res_order['product_price'];
								$pTotPrice = $pPrice * $res_order['product_qty'];
								$pTotPrice = number_format($pTotPrice,2,'.','');
								$pGTotal = $pGTotal + $pTotPrice;
								$pGTotal = number_format($pGTotal,2,'.','');
								$pPrice = number_format($pPrice,2,'.','');
				?>
                  <tr class="bodyText">
                    <td height="36" align="center"><strong> <?php echo $Sno; ?>.</strong></td>
                    <td align="center"> <?php echo $res_order['product_name']; ?></td>
                    <td align="center"> <?php echo $res_order['product_size']; ?></td>
                    <td align="center">  <?php echo $pPrice; ?></td>
                    <td align="center"> <?php echo $res_order['product_qty']; ?> </td>
                    <td align="center">  <?php echo $pTotPrice; ?> </td>
                    <td> </td>
                    <td> </td>
                  </tr>
                  <tr>
                    <td colspan="8" ></td>
                  </tr>
                  <?php
								$Sno++;
								}
							}
							else
							{
								echo "<tr>";
								echo "<td height=\"25\" colspan=\"8\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, sans-serif\">Shopping Basket Is Empty!</font></td>";
							    echo "</tr>";
							}
						}
						else
						{
					  ?>
                  <tr>
                    <td height="25" colspan="8"> </td>
                  </tr>
                  <tr>
                    <td height="25" colspan="8"> </td>
                  </tr>
                  <?php
						}
					  ?>

[themistral]

Please can you be more specific about the problem you are having.

[netrunnr]

It basically doesn't go past this line:

 

<EDITED> if(!(session_register('login'))) </EDITED>

:(

[netrunnr]

Ok, bit more information, I want this to go through the loop and pick the things out from the SQL database.

 

The session is registered as it is pulling other things from the database. It is just this bit that doesnt work

 

*Help!* (pur-lease)

[themistral]

Not sure if you are doing the right thing with this line

 

if(!(session_register('login'))) {

 

Think the correct syntax should probably be

 

if(!isset(session_register('login'))) {

 

Explain what you want this line to check and I will see if I can get the correct code for you!

[netrunnr]

Hey, cheers for the reply.

 

Basically I want the code to check to see if the session is true (which it is). then go through the databse picking out the UserOrderDetails and showing them (what they ordered, quantities etc).

 

I changed the line you mentioned but to no avail.  :-\

[themistral]

OK try

 

if(isset(session_register('login'))) {

 

I don't use session_register so this may not work in the way I expect - post to let us know if this is still unsuccessful.

[netrunnr]

I just get the standard: syntax error, unexpected T_STRING, expecting T_VARIABLE... etc

 

Thank you anyway, i just want to connect to the db, read the contents where the Order ID is $oID and just pull the information out.

 

I've done this loads of times, but this time it has be stumped

[netrunnr]

*bump*

[rajivgonsalves]

is it that your trying to set the value or get the value

 

it should be

 

if(isset($_SESSION['login'])) {

[netrunnr]

hmm, well that has stopped the "no items in basket" from coming up, but still no data in the table... it's just empty...

 

It is definitely that line (or my session) as it just skips the entire php section and does the last ELSE statement.

 

???

 

[netrunnr]

[  [  [ Mega Bump *]  ]  ]  ]

[adam291086]

have you tried echoing $_SESSION['login'] to make sure it has been set

[netrunnr]

It's ok, I sorted it...

 

My database is formatted into two partitions for data, only one partition was being read.

 

The image below you you lot:

<(I'll kill you!)

 

Sorry, but thank you very much for your help (those who took time )