Forum PHP.pl

[PHP] pobierz, plaintext 
 
if ($_GET['action'] =="add") //tutaj próbowałem z post ale nic z tego
		{
		$dberror = "";
 
 
 
		$title = addslashes($_POST['title']);
		$address = addslashes($_POST['address']);
		$city = addslashes($_POST['city']);
		$fulldesc = addslashes($_POST['fulldesc']);
		$type = addslashes($_POST['type']);
		$transmission = addslashes($_POST['transmission']);
		$color = addslashes($_POST['color']);
		$doors = addslashes($_POST['doors']);
		$notes = addslashes($_POST['notes']);
 
 
 
		$price = ereg_replace("[^[:alnum:]]","",$_POST['price']);
		$year = ereg_replace("[^[:alnum:]]","",$_POST['year']);
		$miles = ereg_replace("[^[:alnum:]]","",$_POST['miles']);
 
 
		if ($linefeeds == "Y")
			{
			$previewdesc = ereg_replace("(\r\n|\n|\r)", "<br>", $_POST['previewdesc']);
			$fulldesc = ereg_replace("(\r\n|\n|\r)", "<br>", $_POST['fulldesc']);
			}
 
		$query = "INSERT INTO vehicles (title, city, state,  price, fulldesc, type, featured, dateposted, agent, notes, owner, model, make, year, drivetrain, transmission, body, doors, features, color, miles, opt1, opt2, opt3, opt4, opt5, opt6, opt7, opt8, opt9, opt10, opt11, opt12, opt13, opt14, opt15, opt16, opt17) values ('$title', '$city', '$state', '$price', '$fulldesc', '$type', '$featured', '$dateposted', '$agent', '$notes', '$owner', '$model', '$make', '$year', '$drivetrain', '$transmission', '$body', '$doors', '$features', '$color', '$miles', '$opt1', '$opt2', '$opt3', '$opt4', '$opt5', '$opt6', '$opt7', '$opt8', '$opt9', '$opt10', '$opt11', '$opt12', '$opt13', '$opt14', '$opt15', '$opt16', '$opt17')";
 
		if (!mysql_query ($query, $link) )
			{
			die (mysql_error());
				}
		print "Your listing has been added...";
		}
 
 
 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
function makelisting($querystring, $link, $guidestring, $cur_page, $listings_per_page, $sort)
		{
		global $use_city_state;
		if ($sort == "") {$sort = "price DESC";}
		$querystring = $querystring." ORDER BY $sort";
		$result = mysql_query("$querystring;",$link);
		$num_rows = mysql_num_rows($result); // <- linia 27
 
	$page_num = $cur_page + 1;
 
		$total_num_page = ceil($num_rows/$listings_per_page);
 
 
		print "<Center>";
		if ($num_rows == "1") {Print "There is currently one listing in this category.<BR>";}
		else {Print "There are currently $num_rows listings in this category.<BR>";}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
while ($a_row =mysql_fetch_array ($result) ) //linia 134
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
SELECT * FROM vehicles WHERE (price >= '0' AND price <= '1E015') AND view = '9' ORDER BY price DESC
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
SELECT * FROM vehicles WHERE (price >= '0' AND price <= '100000') ORDER BY price DESC
[PHP] pobierz, plaintext 

Cytat(misiekk45 @ 1.02.2010, 16:48:09 )

[PHP] pobierz, plaintext 
SELECT * FROM vehicles WHERE (price >= '0' AND price <= '100000') ORDER BY price DESC
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT * FROM vehicles WHERE price >= 0 AND price <= 100000 ORDER BY price DESC
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT * FROM vehicles WHERE price >= 0 AND price <= 100000 ORDER BY price DESC
[SQL] pobierz, plaintext