Dear All;
I have table in vehicle.php file that contains vehicle information(plate number, vehicle model, reg. and exp. dates). I pprovided each record with href(more) if he want to know more about this specific vehicle in vehicle-info.php file. in vehicle-info.php I get the plateN and I pass it to the SQL command "Select * from $table where plateN = '$plateN';" However this was not working.
Can you guide me.
Thanks alots...
Hi!
Your post seems very abstract to me,. How can you query using SQL commads from a table that you have in vehicle.php file? Or do you mean to say that you have code in vehicle.php that query's your table in database? I am unable to understand.. If, you have a table in your database, then what you can do is :
Say you have a link for plate number in some page, then provide a link to this,
<a href='vehicle.php?plateN=$plateN'>Plate_number</a>
Now in vehicle.php
$plateN = $_GET['plateN'] ;
and for your query:
$result = mysql_query("SELECT * FROM table_name WHERE plateN = '$plateN' ");
And now you can use the fetched values. This ll work! But I dont know if this is what you are actually wanting to do! The reason is, I am unable to understan your post.
Regards
CyberKing
http://www.bytesandbytes.com