Posted by Jerry Stuckle on 11/14/07 17:47

Lloyd Harold wrote:
> Jerry Stuckle <jstucklex@attglobal.net> wrote:
>
>> Hi, Lloyd,
>>
>> Sounds like a homework question?
>>
>> This isn't too bad, once you get the hang of it.
>>
>> First you need to execute the mysql query. Then, in a loop, retrieve
>> each result and do what you want with it. For instance (error checking
>> left out for clarity, but you should be checking the result of every
>> MySQL call except the mysql_fetch_array()):
>>
>>
>> $location = 4; // Assumed to be passed from somewhere & validated
>>
>> $link = mysql_connect('localhost', 'userid', 'password');
>> mysql_select_db('mydb');
>>
>> $result = mysql_select("SELECT id, name, details FROM mytable WHERE
>> location=$location"); // Sorry for the wrapping
>> if (mysql_num_rows($result) == 0)
>> echo "No results found<br>\n";
>> else {
>> while($data = mysql_fetch_array($result)) {
>> // $data is an array with elements ['id'], ['name'] and ['details']
>> echo
>> "<p><a href='/details.php?id=$data['id']'>$data['name']</a></p>\n";
>> // You could also display the details, here. Or, if you're not going to
>> // display the details on this page, just leave them out of the query
>> }
>>
>> Then on your details.php page, retrieve the data for the specific ID you
>> want, and display them with code similar to the above (although you
>> won't need a loop as you'll only have one result).
>
> Thanks for your help and encouragement, Jerry.
>
> I've tried the code and am seeing this error:
>
> expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in
>
> "<p><a href='/details.php?id=$data['id']'>$data['name']</a></p>\n";
>
It should be all one line, with the echo in front of it (split because
of my line length limits).

And I was wrong - it should be

"<p><a href='/details.php?id={$data['id']}'>{$data['name']}</a></p>\n";

since it's an array...

Or, you could do use this instead:

'<p><a href="/details.php?id=' . $data['id'] . '>' . $data['name'] .
"</a></p>\n";

But you should know enough about PHP to be able to debug minor syntax
errors like this. In the newsgroups we (almost) never guarantee our
code to be perfect.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]