Could really use some help on a query

Hey guys, I am very very new to PHP and could really use a hand with this one

Below is the code I have created for editing a webpage however I have an error on line 66 which is the final

I honestly cannot fathom out why and I don’t really want to change the code if I can avoid it

Any help would be gratefully appreciated

[php]

New document <?php include 'dbconnect.php';

// Make an SQL Query - Using a variable

$bikeSQL="SELECT *
FROM ct_cycles
ORDER BY brand";

// Execute the Query
$rsBike = mysql_query($bikeSQL,$connection)
or die(mysql_error($connection));

echo “<table border=“1”>”;

// Record Set Returned

while ($row = mysql_fetch_assoc($rsBike)) {
$cycleID = $row [‘cycleID’];
$brand = $row [‘brand’];
$type = $row [‘type’];
$style = $row [‘style’];
$model = $row [‘model’];
$groupset = $row [‘groupset’];
$price = $row [‘price’];

mysqli_close($connection);
?>

CycleID:

Bike Brand

Bike Type

Bike Style
">

Bike Model

Bike Group Set

Bike Price

[/php]

You’re missing the closing bracket for your while loop on line 35.

You do realize, that currently you will only retrieve the last value in the database?

Sponsor our Newsletter | Privacy Policy | Terms of Service