multiple variable from mySql

flashgroover2

I have this script below, trying to get the $brand variables to show what i am asking, and they are not. anybody know why? i hope my script is self explanitary enough. thanks for your help.

------------------------ My Script

$result2 = mysql_query("SELECT * FROM watch_list WHERE whatsession LIKE '%".$session."%' ",$db) or die("error with the sql statement 2");
$i = 1;
while ($watch_list = mysql_fetch_row($result2)) {
foreach($watch_list[1] as $brand){
$brand = watch_list[1];
i++;
}
}

echo" $brand[1] ";
echo" $brand[2] ";
echo" $brand[3] ";

YappyDog

Kind of hard to know exactly what you are trying to do without knowing the columns that are in your table, but I think this will do the trick.

$i = 1;
while ($row = mysql_fetch_row($result2)) {
$brand[$i] = row[1];
$i++;
}

flashgroover2

i am only concerned with just the one column, watch_list[1]. for every row that has the value of $session in it i need to know what the [1] column value is, then list it like this-

echo" $brand[1] ";
echo" $brand[2] ";
echo" $brand[3] ";

thanks for the reply.

YappyDog

So, did what I suggested work?

You would probably be better off not using the wildcard (*) in your select statement and instead selecting the column you want by name. It's more efficient that way, and also still works if you (or someone else) add a column to the table.

Then, rather than getting the column by position
$row[1]
you can get it by name
$row["myColumn"];

I'd also put the printing of the results into a loop as you don't know how many entries in the $brand array you are going to end up with.

flashgroover2

yes is working as you suggested, thank you very much. i will take your suggestion about removing the wildcard, i think this will result in a much faster search. i am having the issue with if there is only one return from the query and i ask for the [2] value, (which in some cases thereis not, though in other cases there may be 15) then it errors. can you better explain how to prevent this error.

another thing i should mention is that the $brand[1] results are being diplayed in a variable that is the message part of a mail() function, so to my knowlege i can not but the loop in the mail finction variable. below is my whole code for the section. thanks again for help-in this newbie out.

flashgroover

$result2 = mysql_query("SELECT * FROM watch_list WHERE whatsession LIKE '%".$session."%' ",$db) or die("error with the sql statement 2");

$i = 1;
while ($watch_list = mysql_fetch_row($result2)) {
$brand[$i] = $watch_list[1];
$i++;
}

$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: sales@watchsolution.com\r\n";
$headers .= "Reply-To: sales@watchsolution.com\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();

$mailfrom = 'buyer: '.$name;
$message = "
This person has continued to the World Pay server. 
name: $name
address: $address
country: $country
telephone: $telephone
email: $email
sessionID: $session2
watch total: \$$totals
shipping total: \$$shippingcost
international total: \$$internationaltotal
----------------------------------------------------------------
grandtotal: \$$grandtotal2

$brand[1]
$brand[2]
$brand[3]

$subject = $name. ' has purchased watches.';
$mailto = 'cesar@pacevideo.com';

mail($mailto, $subject, $message, $headers);

YappyDog

So what you need to do then is to break up your $message variable so that you build it in pieces rather than trying to do it all once.

$message = "
This person has continued to the World Pay server. 
name: $name
address: $address
country: $country
telephone: $telephone
email: $email
sessionID: $session2
watch total: \$$totals
shipping total: \$$shippingcost
international total: \$$internationaltotal
----------------------------------------------------------------
grandtotal: \$$grandtotal2

// loop through the array and add what we found to message
for ($i=1;$1<=count($brand);$i++) {
$message .= $brand[$i] . "\n";
}

flashgroover2

fantastic! thanks for all ur help.

cesar