12-23-2006, 04:21 PM
|
|
|
Confirmed User
Join Date: Oct 2005
Posts: 143
|
Quote:
Originally Posted by amateurcanada
Ok, what i want to do is have the sql load the page based on the modnum entered in the php line (text.php?modnum=1) - ive tried alot of == lines and get errors, how would u simplify this to work :D thanks alot guys! :d
/** SQL QUERY
*/
if(!isset($modnum)){
$sql = "SELECT id,up_date, up_modelname, up_age, up_from, up_description, up_moviename, up_length, up_buyvideo, up_modelset, keywords FROM $upTable WHERE LOWER(keywords) LIKE '%".$modnum."%' ORDER BY up_date DESC";
}
$result = mysql_query($sql, $db_link);
|
Replace $modnum for $_GET['modnum'], I think that is your problem.
|
|
|