Trying to retrieve several elements by same ID from Database

Question

I have a car database which stores several cars for each individual model, I am trying to retrieve all the cars for a specific model however my code is not working, where am I going wrong?

$ModelID = $_GET['model_id'];

$result = mysqli_query($con, "SELECT * FROM Car WHERE ModelID = $ModelID");

while($row = mysql_fetch_assoc($result))
{           
   echo $row["RegNumber"];
   echo $row["Colour"]; 
}

`WHERE ModelID = '$ModelID'`. But you should really read up on Prepared Statements — juergen d, Nov 25 '16 at 12:03
make sure that your $ModelID will contains a value try echo and check — Binit Ghetiya, Nov 25 '16 at 12:05
As well as check that the variable it is the correct value controls the name of your database tables — Lorenzo Belfanti, Nov 25 '16 at 12:32

Abhishek Gurjar · Answer 1 · 2016-11-25T12:18:23.897

0

I think you are having error here

while($row = mysql_fetch_assoc($result))
{           
   echo $row["RegNumber"];
   echo $row["Colour"]; 
}

you should use mysqli_fetch_assoc($result) instead.

Do not mix the functions of mysql & mysqli API if your code is previously written in mysql api try to port it to mysqli or PDO.

edited Nov 25 '16 at 12:18

answered Nov 25 '16 at 12:06

Abhishek Gurjar

7,426
10
37
45

Trying to retrieve several elements by same ID from Database

1 Answers1