PLEASE help

Anon

Here are 2 scripts i have ... the first links to the second. My problem is the link in the first table for the Agency does not link properly. i believe it has something to do with the fact that i am using myrow[5] twice in the second script and so it states that it cant jump to row 0. i found that when i changed the agency_name='$myrow[5]' to the actual name of the agency replacing the $myrow[5] it works just fine. so this is why i think that the use of $myrow[5] is causeing the error, but i dont know how or to what to change it, for the link to work properly. if you understand my problem please help.

<body>
<?php
$db = pg_connect("","","","","funds");
$query = "SELECT * FROM scholarship where schol_id=$schol_id";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
$numrows = pg_numrows($result);
$row=0;
do
{printf ("<table border=1>\n");
$myrow = pg_fetch_row ($result,$row);
$agency = $myrow[5];
printf ("
<tr><td width=130 bgcolor=\"#dfdfdf\">Name :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Value :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Deadline :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Application Information :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Agency :</td><td width=400><a href=\"agencyview2.php?agency_name=".$myrow[5]."\">%s</a></td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Field of Study :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Level :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Gender :</td><td width=400>%s</td></tr>
<tr><td width=130 bgcolor=\"#dfdfdf\">Eligibility :</td><td width=400>%s</td></tr>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6],
$myrow[7], $myrow[8], $myrow[9]);
$row++;
}
while ($row < $numrows);
printf ("</table>\n");
pg_close($db);
?>
</body>

agencyview2.php

<body>
<?php
$db = pg_connect("","","","","funds");
$query = "SELECT * FROM agency where agency_name='$myrow[5]'";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
$numrows = pg_numrows($result);
$row=0;
do
{printf ("<table border=1>\n");
$myrow = pg_fetch_row ($result,$row);
printf ("
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Agency :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Street :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">City :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Province/State :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Country :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Postal/Zip Code :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Phone Contact(s) :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">E-mail :</td><td width=\"400\">%s</td></tr>
<tr><td width=\"130\" bgcolor=\"#dfdfdf\">Web Address :</td><td width=\"400\"><a href=\"$myrow[9]\">%s</a></td></tr>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7],
$myrow[8], $myrow[9]);
$row++;
}
while ($row < $numrows);
printf ("</table>\n");
pg_close($db);
?>
</body>

[deleted]

" it cant jump to row 0"

That's because you are using the evil "do..while" structure.

Do..While will always execute the loop at least once.

In your case, you run a query, and you want to process the results in the do..while loop. But if there are no results, the do..while will still be executed at least once before it find out that there are no results.

change the do{..}while to while {..}, then the script will find that $row is never less than the number of rows ($row<$numrows==false) and you will not get the error.

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

the thing is ... there ARE results, and the reference is pointing to the right values - they are just not populating the agencyview2 page ... the result is an empty field with the cannot jump to row 0 error. like i said, when i manually enter the value i want in place of the $myrow[5] command which is a reference to it, it works fine. is there something i am not understanding here or wil changing the dowhile statements fix that ? and can i build arrays that point to a table in a database and its values - will that help or does that have nothing to do with the problem ? (i am a beginner but i only have a couple of weeks to do this and write a script to do a multiple search at once).

Anon

On the off chance, could you rewrite the link in the first page to say "urlencode($myrow[5])" instead of just "$myrow[5]"? Can't hurt, and will probably save grief later.

And in the second page, change the "$myrow[5]" in the SQL query to "$agency_name", since that's the name of the variable you're using in the link.

Anon

is this how i would write it using url encode ?? i am getting an error - does this have to do with the fact that my db program is postgresql ?
<a href=\"agencyview2.php?agency_name=".urlencode($myrow[5])."\">

Anon

It doesn't have anything to do with the database. What's the error you're getting?

Anon

this is the line i put in <tr><td width=130 bgcolor=\"#dfdfdf\">Agency :</td><td width=400><a href=\"agencyview2.php?agency_name=".urlencode($myrow[5])."\">%s</a></td></tr> and the page (which doesnt have an error before this says "Warning: printf(): too few arguments in /home/httpd/html/development/php/Funds/scholview.php on line 25"
heres the thing though - before any changes were made - i didnt get any errors til the last page ... the refereence is to the right name when it hovers over the link BUT it doesnt populate the box with the information
when i click and go to the page. said "cant jump to row 0"

Anon

Ditch printf - it's overkill for this job.

What was probably happening is that the agency had some naughty non-URL character in its name. The value of $agency_name that you were seaching on was therefore corrupted and so you go no results for your match.

Then, when you urlencoded it, that naughty character became a %hh escape sequence, which printf then interpreted as a formatting escape. So you ended up with more formatting escapes than parameters for them.

But since you're not doing any formatting anyway, printf is, like I said, overkill, and a waste of clock cycles.

<body>
<?php
$db = pg_connect("","","","","funds");
$query = "SELECT * FROM scholarship where schol_id=$schol_id";
$result = pg_exec($db, $query);
if (!$result) {print ("ERROR"); exit;}
$numrows = pg_numrows($result);
$row=0;
do
{print ("<table border=1>\n");
$myrow = pg_fetch_row ($result,$row);
$agency = $myrow[5];
print('
<tr><td width=130 bgcolor="#dfdfdf">Name :</td><td width="400">'.$myrow[1].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Value :</td><td width="400">'.$myrow[2].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Deadline :</td><td width="400">'.$myrow[3].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Application Information :</td><td width="400">'.$myrow[4].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Agency :</td><td width="400"><a href="agencyview2.php?agency_name='.urlencode($myrow[5]).'">'.$myrow[5].'</a></td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Field of Study :</td><td width="400">'.$myrow[6].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Level :</td><td width="400">'.$myrow[7].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Gender :</td><td width="400">'.$myrow[8].'</td></tr>
<tr><td width=130 bgcolor="#dfdfdf">Eligibility :</td><td width="400">'.$myrow[9].'</td></tr>
');
<?php
$row++;
}
while ($row < $numrows);
print ("</table>\n");
pg_close($db);
?>
</body>

Anon

well - nothing seems to be working .. i dont understand what the problem could be ... i have an exact same script that simply points to the id rather than the name and that one works just fine ... very frustrating. can you think of a way to use the id in this case ?
i tried pointing to the page using the id and adding the name portion as well but that did not work.
is it possible that the name is what could be causing the trouble ? the name of the agency im testing with is "ACSM American Congress on Surveying & Mapping" ....
im retty much fuct with this i think .. gotta rehash and think of another way to link to the agency table .... thanks for all your help.

Anon

ok - here's what it was ... there is an & sign in the name of this particular agency and now that i changed it it works! OMG ! i'm an idiot ... i shoulda known that this was the problem ... i changed it to "and" and it is fine. NOW ... is there a way to script so that symbols CAN be input as parts of names or text ?

Anon

Yeah, it's called urlencode()

"ACSM American Congress on Surveying & Mapping" becomes "ACSM+American+Congress+on+Surveying+%26+Mapping". Note the % which is what printf was choking on.