Ad:

PHP Discussion Thread
Marked Solved
Views: 1602

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Jun 10th, 2009

Re: make link from a variable.

php Syntax (Toggle Plain Text)
echo "<tr>
<td><a href='details.php?lessonID=$lessonID'>Details</a></td>
<td>$subject</td>
<td>$learningArea</td>
<td>$noofstudents</td>
<td>$minutes</td>
<td>$class</td>
<td> $ability</td>
</tr>" ;
echo "<tr>
<td><a href='details.php?lessonID=$lessonID'>Details</a></td>
<td>$subject</td>
<td>$learningArea</td>
<td>$noofstudents</td>
<td>$minutes</td>
<td>$class</td>
<td> $ability</td>
</tr>" ;

djjjozsi

Reputation Points: 12

Solved Threads: 11

Junior Poster in Training

Offline

69 posts
since Jun 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

this is a typo error in your SQL query then

Click to Expand / Collapse Quote originally posted by navi17 ...

..........
it should be:
PHP Syntax (Toggle Plain Text)
$myquery = "select * from lesson where subject like '%'.$q.'%' AND learningArea like '%'.$r.'%' AND ability like '%'.$s.'%'";
$myquery = "select * from lesson where subject like '%'.$q.'%' AND learningArea like '%'.$r.'%' AND ability like '%'.$s.'%'";
........

and,
the SQL save version is this:

php Syntax (Toggle Plain Text)
$q = isset($_GET['q'])? mysql_real_escape_string($_GET['q']):'';
$r = isset($_GET['r'])? mysql_real_escape_string($_GET['r']):'';
$s = isset($_GET['s'])? mysql_real_escape_string($_GET['s']):'';
 
// Build SQL Query
$myquery = "select * from lesson where subject like '%{$q}%' AND learningArea like '%{$r}%'
 AND ability like '%{$s}%'";
$q = isset($_GET['q'])? mysql_real_escape_string($_GET['q']):'';
$r = isset($_GET['r'])? mysql_real_escape_string($_GET['r']):'';
$s = isset($_GET['s'])? mysql_real_escape_string($_GET['s']):'';

// Build SQL Query
$myquery = "select * from lesson where subject like '%{$q}%' AND learningArea like '%{$r}%'
 AND ability like '%{$s}%'";

djjjozsi

Reputation Points: 12

Solved Threads: 11

Junior Poster in Training

Offline

69 posts
since Jun 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

try this:

PHP Syntax (Toggle Plain Text)
while ($row= mysql_fetch_array($result))
{
$lessonID = $row["lessonID"];
$subject = $row["subject"];
$learningArea= $row["learningArea"];
$noofstudent= $row["noofstudents"];
$minutes= $row["minutes"];
$class= $row["class"];
$ability= $row["ability"];
 
?>
//display the row
 
<tr>
<td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td>
<td><?php echo $subject; ?></td>
<td><?php echo $learningArea; ?></td>
<td><?php echo $noofstudents; ?></td>
<td><?php echo $minutes; ?></td>
<td><?php echo $class; ?></td>
<td><?php echo $ability; ?> </td>
</tr>
<?php  } ?>
</table>
while ($row= mysql_fetch_array($result))
{
$lessonID = $row["lessonID"];
$subject = $row["subject"];
$learningArea= $row["learningArea"];
$noofstudent= $row["noofstudents"];
$minutes= $row["minutes"];
$class= $row["class"];
$ability= $row["ability"];

?>
//display the row

<tr>
<td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td>
<td><?php echo $subject; ?></td>
<td><?php echo $learningArea; ?></td>
<td><?php echo $noofstudents; ?></td>
<td><?php echo $minutes; ?></td>
<td><?php echo $class; ?></td>
<td><?php echo $ability; ?> </td>
</tr>
<?php  } ?>
</table>

i am sure it works.

Last edited by navi17; Jun 10th, 2009 at 9:18 am.

navi17

Reputation Points: 15

Solved Threads: 6

Junior Poster

Offline

118 posts
since Oct 2007

Permalink

Jun 10th, 2009

Re: make link from a variable.

but its not printing the data from the database... you will see $minutes and other stuffs in the output...
.....
the shortest is the better...

Last edited by djjjozsi; Jun 10th, 2009 at 9:24 am.

djjjozsi

Reputation Points: 12

Solved Threads: 11

Junior Poster in Training

Offline

69 posts
since Jun 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

it will print the data from the database.
i am sure.

navi17

Reputation Points: 15

Solved Threads: 6

Junior Poster

Offline

118 posts
since Oct 2007

Permalink

Jun 10th, 2009

Re: make link from a variable.

Click to Expand / Collapse Quote originally posted by navi17 ...

it will print the data from the database.
i am sure.

i've seen your first version, and in that post i did not see the <?php echo $field... ; ?>
which needed to print the values.

if i saw it wrong then sorry about it.

Last edited by djjjozsi; Jun 10th, 2009 at 9:36 am.

djjjozsi

Reputation Points: 12

Solved Threads: 11

Junior Poster in Training

Offline

69 posts
since Jun 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

I have tried that as well..
please anyone who can identify the error...

thanks.

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

Click to Expand / Collapse Quote originally posted by navi17 ...

try this:
PHP Syntax (Toggle Plain Text)
while ($row= mysql_fetch_array($result))
{
$lessonID = $row["lessonID"];
$subject = $row["subject"];
$learningArea= $row["learningArea"];
$noofstudent= $row["noofstudents"];
$minutes= $row["minutes"];
$class= $row["class"];
$ability= $row["ability"];
 
?>
//display the row
 
<tr>
<td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td>
<td><?php echo $subject; ?></td>
<td><?php echo $learningArea; ?></td>
<td><?php echo $noofstudents; ?></td>
<td><?php echo $minutes; ?></td>
<td><?php echo $class; ?></td>
<td><?php echo $ability; ?> </td>
</tr>
<?php  } ?>
</table>
while ($row= mysql_fetch_array($result)) { $lessonID = $row["lessonID"]; $subject = $row["subject"]; $learningArea= $row["learningArea"]; $noofstudent= $row["noofstudents"]; $minutes= $row["minutes"]; $class= $row["class"]; $ability= $row["ability"]; ?> //display the row <tr> <td><a href="details.php?lessonID=<?php echo $lessonID; ?>"> Details</a></td> <td><?php echo $subject; ?></td> <td><?php echo $learningArea; ?></td> <td><?php echo $noofstudents; ?></td> <td><?php echo $minutes; ?></td> <td><?php echo $class; ?></td> <td><?php echo $ability; ?> </td> </tr> <?php } ?> </table>
i am sure it works.

Hi Navi17.
thanks a lot..can be linked to details page.
however, the Id number is not shown in the result..
all show the same string..details..but the lesson Id that sent to details page is correct (the lessonID)
just the Id is not displayed in the table.
any idea to correct it?

thanks

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

Click to Expand / Collapse Quote originally posted by djjjozsi ...

i've seen your first version, and in that post i did not see the <?php echo $field... ; ?>
which needed to print the values.

if i saw it wrong then sorry about it.

djjjozsi, it does work for me..I mean the link.
the code that I posted before also print data from the database..
The problem is to make a link to the details page.
now, Navi17 has solved that problem..however the ID is not printed here..but the value is passed to the details page... I need both..the lessonID printed & the value passed.
ANy solution. Mny thanks for your respond

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 10th, 2009

Re: make link from a variable.

Thanks all for your help..
NAvi17 & djjjozsi i have corrected it now..
credits for both of you

It works perfectly now.

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Previous
1
Page 2
3
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Internationalization - MySQL queries

Next Thread in PHP Forum Timeline: cake php

DaniWeb Message

Cancel Changes

User Name
Password