PHP Help

[Elton]

The code below can be seen in action at http://www.select-imports.org/

 

Basically, it's the code that displays the latest 10 listings on the site.

 

The owners have decided that they'd like to do away with the text on the front page and have all of their cars listed on the front page, in 3 or four columns. Can anyone tell me where and how I start hacking this to accomodate their wishes?

 

tia,

 

Elton

[Elton]

// Newest Listings Code.

// This code will display the last five listings added.

 

//setup the database

$link = mysql_connect ($dbserver, $dbuser, $dbpassword);

if (! $link)

{

die ("$L_noConnect");

}

if (!mysql_select_db ($db, $link) )

{

die ("Couldn't open $db: ".mysql_error() );

}

$sql = "SELECT v_id, id, year, make , model, price FROM vehicles ORDER BY v_id DESC LIMIT 0,10";

// You can change the 5 in the above statement to whatever number you want to display.

 

$sql_result = mysql_query($sql,$link) or die ("Couldn't execute Query!");

 

if (!$sql_result) {

echo "

Couldn't get List";

}else{

 

// This section prints the display. You may adjust it to fit your needs.

// You can use all the variables defined in the while loop below.

 

echo "

";

while ($row = mysql_fetch_array($sql_result)) {
$v_id = $row["v_id"];
$id = $row["id"];
$year = $row["year"];
$make = $row["make"];
$model = $row["model"];
$price = $row["price"];
$stock_id = stripslashes($stock_id);
$year = stripslashes($year);
$model = stripslashes($model);
$vin = stripslashes($vin);
$price = stripslashes($price);
$price = number_format ($price);
$count = $count + 1;

$img_chk = "SELECT filesize FROM thumb_images WHERE img_id = "$id"";
$img_chk_result = mysql_query($img_chk,$link) or die ("Couldn't execute query");
$row5 = mysql_fetch_array($img_chk_result);
$img = $row5["filesize"];
if ($img > 0){
$item_thumb = "";
}else{
$item_thumb = "";
}

echo "


";
}

echo "

Latest 10 Listings
$L_clickPic
$item_thumb	$year $make $model

 

";

}

?>

[Elton]

Think I may be getting somewhere....

 

By duplicating the table above and changing the 0,10 to 11,10, I get another column with the next ten cars. Just need to remove all the repeated text and away we go, I think.

[rickster]

best of luck m8, took me ages to work out the php for my site in the end i got the it department at work to fix it for me

[Si...]

You could`ve used

 

code:

---

$sql = "SELECT * FROM vehicles ORDER BY v_id DESC LIMIT 0,10";

---

instead of

 

code:

---

$sql = "SELECT v_id, id, year, make , model, price FROM vehicles ORDER BY v_id DESC LIMIT 0,10";

---

Because you`re querying the SQL table like this

code:

---

while ($row = mysql_fetch_array($sql_result)) { 

$v_id = $row["v_id"];

$id = $row["id"];

$year = $row["year"];

$make = $row["make"];

$model = $row["model"];

$price = $row["price"];

---