a few general questions

[dv6cougar]

for and UPDATE command to work, which i have made worked using my PRIMARY KEY id now, do you have to use the Primary key?

does it have to be a key?

can it be a unique key then?

if not then why is .php?username=$username not working right?

and in my update script i have

$query = "UPDATE users SET (Year='$Year',
etc etc etc
WHERE username=$username)";

and username is entered into the form.... the exact way I got the id way to update..

next question

how do you display all the records in a database?

how can you count the number of records in a database?

my ohter database, which is a very nice script and i'm very proud of 🙂

needs a few new options one being, display all the records.

now

my tables are all set as Makes of cars.. Acura, Ford, Chvery etc etc etc lot's of them

and one of the fields is Model

how can I make a search that shows all results for model?

i've been trying thsi way, with no apparent luck

<?
include("db.php");
if ($searchstring) {
$query = "SELECT * FROM $make WHERE $searchtype LIKE '%$searchstring%' ORDER BY Mod_Name ASC";

$searchstring = $searchtype;

$result = mysql_query($query, $mysql_access);



while ($row = mysql_fetch_array($result))
{
	echo "<p aligncenter>";
	echo "Mod Name:<a href=\"result/$make.php?id=".$row["0"]."\"> ".$row["4"]."</a>";


   }

   echo "</p>";

i have a working search set up almost the same way... here's that working script

<?
include("db.php");
if ($searchstring)
{
$query = "SELECT * FROM $make WHERE $searchtype LIKE '%$searchstring%' ORDER BY Mod_Name ASC";



$result = mysql_query($query, $mysql_access);

echo "Search results:";

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

echo "<table width=675 border=1 bordercolor=black borderstyle=solid align=center>";
echo "<tr><b>Mod Name:</b><a href=\"result/$make.php?id=".$row["0"]."\"> ".$row["4"]."</a>";


   }

   echo "</tr></table>";

thanks for reading and thanks for your help 🙂

[ultraslacker]

Google for a sql tutorial

[cgraz]

No you don't have to use the primary key, although you would want to use something unique. Username will work

if the username is passed properly in your url (check it on the update script) and it's not working, then use this

$query = "UPDATE users SET Year='$Year' WHERE username='" . $_GET["username"] . "'"; // don't forget the single quotes

how do you display all the records in a database?

$query = mysql_query("SELECT * FROM your_table");

how can you count the number of records in a database?

$total_count = mysql_num_rows($query); // you can only use mysql_num_rows on the variable that EXECUTED the query with mysql_query

how can I make a search that shows all results for model?

You mean

SELECT * FROM your_table where model='Mercury'

or WHERE model='$model'

??

Cgraz

[cgraz]

here are a few tutorials that should get you well on your way

http://www.w3schools.com/sql/
http://sqlcourse2.com/intro2.html
http://www.w3schools.com/sql/
http://sqlcourse2.com/intro2.html
http://www.devshed.com/Server_Side/MySQL/Speak
http://www.devshed.com/Server_Side/MySQL/Intro/page1.html

Cgraz

[dv6cougar]

i'll get reading thanks 🙂

and i meant $model

the rest I can do with!

THANKS SO MUCH! i'll have to show you when i'm all done 🙂

[dv6cougar]

did everything i wanted with this 🙂

thanks