|
|
|
|
|||||||
| Forums | Portal | Register | Rules & FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| lpr- how to print from page to page | naamas03 | Shell Programming and Scripting | 4 | 12-26-2007 02:30 AM |
| scp-1.2.27 man page | Tornado | Linux | 4 | 03-16-2007 04:09 AM |
| how do i make a web page | Neil Peart | UNIX for Dummies Questions & Answers | 3 | 10-13-2005 08:04 AM |
| adding a man page | jacob358 | UNIX for Dummies Questions & Answers | 1 | 08-08-2005 01:14 PM |
| map Page Down and Page up to ] and [ | buddy_amazing | AIX | 0 | 03-01-2005 10:34 AM |
 |
|
|
LinkBack | Thread Tools | Display Modes |
07-08-2003
|
|||
|
|||
|
PHP:page.php?id= ????
Hi, i have this script to read from mysql (layout below) and the script will display the course title, and a url to the id, but when i click on the url it just goes back to that page(displaying all the course titles)but when u click on a course title i want it to read from detail table in php and display all the data in detail. how would i modifie the script to do that??
<html> <body> <?php $db = mysql_connect("localhost", "root"); mysql_select_db("compulearn",$db); // display individual record if ($id) { $result = mysql_query("SELECT * FROM courses WHERE id=$id",$db); $myrow = mysql_fetch_array($result); printf("First name: %s\n<br>", $myrow["courses"]); } else { // show employee list $result = mysql_query("SELECT * FROM courses",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["courses"], $myrow[""]); } while ($myrow = mysql_fetch_array($result)); } else { echo "Sorry, no records were found!"; } } MYSQL TABLE +------+-------------------+-------------------+ | ID | Courses | detail | +------+--------------------+------------------+ | intro | Intoductions | This course....| +------+--------------------+------------------+ Please someone tell me.i hope u understand what iam lookin for,.
__________________
14 years old with: A+, Netowrk+, ICDL, E-cert, IT-Cert, IT-Diploma 
|
| Forum Sponsor | ||
|
|
|
10-01-2003
|
||||
|
||||
|
I'm not sure if this wil solve the problem, but kill the quotes in the array indecies and put them directly into a print() call, like so:
print("<a href=\"$PHP_SELF?id=$myrow[id]$myrow[courses]$myrow[]"); then change the if($id) to if(!isset($id))... come to think of it, that's probably what's wrong. If you were getting a valid URL with fprint(), then disregard the first thing i said...
|
||||
| Google UNIX.COM |
Linear Mode
