php question

louie · #11 (**permalink**) 16-03-2008, 06:17 PM

which page are you getting the error?
the sql for the details page is not right. should be@

PHP Code:

  mysql_connect("localhost", "username", "password")or die("cannot connect server "); 
mysql_select_db("database")or die("cannot select DB");

$sql = ("SELECT * from events WHERE id='".addslashes($id)."'");
$result = mysql_query($sql) or die (mysql_error);
 
//echo results
while ($row = mysql_fetch_array($result)){
echo $row['date'];
echo "<br />";
}

failsafe · #12 (**permalink**) 24-03-2008, 06:21 PM

If you're saying the link doesn't work you also have a problem in this line

Code:

 echo "<a href='details.php?id=$id'>Click Here For Details</a><br />";

you need to use some concatenation for the variable, like so:

Code:

 echo "<a href='details.php?id=".$id."'>Click Here For Details</a><br />";

I'm teaching myself php at the moment and I find Tizag Tutorials quite useful.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
General Blog questions & BLOG URL SEO question. Help Please? :-)	Gman290	Search Engine Optimisation	6	08-11-2008 01:24 AM
php question	Keewee6	Coding Help	3	15-03-2008 12:34 AM
Ruby on Rails VS PHP Code Igniter	gav240z	Coding Help	10	04-02-2008 12:04 AM
php question	Keewee6	Coding Help	2	17-08-2007 12:51 PM
HELP :: PHP regular expression question	littleBird	Coding Help	3	13-03-2007 10:33 PM

Sponsored links

php question

php question

Similar Threads

Sponsored links