variable don't get value

Anon

Hi. I had a page that generates links with a variable associated in this way: if I select a printer I generate a page with all stuff related with the printer: toner, paper, etc,etc. I assigned to both, printer and stuff, codes. But after generating the links when I call the page associated with the link and the variable, the variable seems not be "created". Code follows to better comprehension.

$codd=device code
$cods=stuff code
ref=stuff reference
unit=stuff in stock

$result = mysql_query("SELECT * FROM stuff WHERE codd='$codd'",$db);

while ($myrow = mysql_fetch_array($result)) {
printf("<table border width=%s>\n",$wid);
printf("<tr>\n");
printf("<td><a href=\"deliver.php?cods=%s\"><b>%s</b></a>  Stock: %s</td>\n",$myrow["codc"],$myrow["ref"],$myrow["unit"]);
printf("</tr>\n");
printf("</table>\n");
}

As you can see, i generate links dinamically. I suspect that the variable don't get the value because i use the string "cods" for multiple links. Is this assuption correct? If not, what could cause the variable being empty? Thanks in advance

trellie

hmm... i'm actually thinking of something else..

Do you urlencode/decode the string you send to this script? if not, the $codd might contain characters wich are interpreted wrongfully.

anyways, testing with echo mysql_error() and echo mysql_num_row($result) might get you some more info.

Anon

In the URL things goes ok. I get the http://blabla/deliver?codc=<number> fine. The problem is that in deliver.php codc is empty and i couldn't make any query or insert data in the DB. So i assume maybe I'm using the same variable name to multiple links could cause the problem. I forgot to mention that the WHILE loop is inside of another WHILE loop. But this is not the problem of course🙂. The idea is

while (printer) {
query stuff
while(stuff) {
link stuff
}
}

trellie

printf("<td><a href=\"deliver.php?cods=%s\">%s</a> Stock: %s</td>\n",$myrow["codc"],$myrow["ref"],$myrow["unit"]);

why is it called '...?cods=%s...' and not 'codc'... since you're trying to get $codc in deliver.php

Anon

🙂 Sorry. You must read $myrow["cods"]. I tried avoid errors since I create the coe in my native language.

Anon

Just misspelled cod. The problem persist🙁