I'm going crazy!

kamy99

Hi all:

I posted this problem yesterday and did get a few replies, however those suggestions were stirring to a different direction which I do not intend to follow.
In any case here the (super easy) problem:

I have an order page which pulls data outta mysql, that portion works. When clicking on any of the orders, the next page displays the full detail of each order.
I know this si simple, because I've done 100s of times, but for some reason the variable is not getting passed here.
The codes are as follows:

Initial page:

<?
db_connect();
$getInfo=mysql_query("SELECT * FROM orders_txt ");
while ($i=mysql_fetch_array($getInfo))
{
?>

<?}?>

This portion works fine 🙂

=======
The order_detail.php page which displays details:

<?
db_connect();

$sql="SELECT * FROM orders_txt WHERE OrderID= '$Orders' ";

$showInfo=mysql_query($sql) or die ("Sql prob:".$sql."".mysql_errno().": ".mysql_error());

while ( $i=mysql_fetch_array($showInfo) )
{ ?>
<? echo $i[3]; ?> 
<? echo $i[4]; ?>

<? }
?>

This page just produces blank 🙁

Do you see any problems?

I am going crazy over this!!!

Thanx
in advance
kamy

GBahle

hm, just a guess, but IDs usually aren't strings but numbers, and if that's the case here, than the sql statement should read ... OrderID = $Orders (without the single quotes)

P.s. Using select * only invites trouble. You should name all the columns you want. And, using <? instead of <?php does it too.

kamy99

So I uploaded my files to a production server and everything the way it is works perfectly.
But on my own PC I'm still getting a blank page (ie the variable is not being passed)

My guess is I need to configure Apache/mysql/php somehow.

Any ideas?

intenz

Try...

<? 
db_connect();
$sql = mysql_query("SELECT * FROM orders_txt WHERE OrderID = '$_GET[Orders]'") or die ('Sql prob: ' . $sql . '<p>' . mysql_errno() . ': ' . mysql_error());
while($i = mysql_fetch_array($sql))
{
?>
     <b><? echo $i[3]; ?></b><br>
     <b><? echo $i[4]; ?></b><br>

<?
} 
?>