Can I Do It Like This?

[B-L-A-D-E]

I Have A Question This Is Code Snip Of Your LoadSaveMovie Tut:

// This is the SQL statement that will update the settings in the Database.
$query = "UPDATE saveMovie SET Object1='xO1=$O1x&yO1=$O1y&',  Object2='xO2=$O2x&yO2=$O2y&', Object3='xO3=$O3x&yO3=$O3y' , Comment='$Comment'  WHERE Name='$Name'";
$result = mysql_query($query);

Can I Write It Like This?

// This is the SQL statement that will update the settings in the Database.
$query = "UPDATE theojm_Clients SET OwnersName='$OwnersName&', Address='$Address&', City='$City&', State='$State&', Zip='$Zip&', City='$City&', PhoneNum='$PhoneNum&', CellNum='$CellNum&', EmergencyNum='$EmergencyNum&', TypeOne='$TypeOne&', Comment='$Comment'  WHERE Name='$Name'";
$result = mysql_query($query);

If Not How Would I Do It?
And What Does WHERE mean Again Exacly?

[B-L-A-D-E]

This Is The Whole Edited Code Can You Tell Me Why Its Not Working?

<?php
/* This script is used to update the position of each Object in the database.*/ 

   $OwnersName = stripslashes($OwnersName);
   $Address = stripslashes($Address);
   $City = stripslashes($City);
   $State = stripslashes($State);
   $Zip = stripslashes($Zip);
   $HomeNum = stripslashes($HomeNum);
   $CellNum = stripslashes($CellNum);
   $EmergencyNum = stripslashes($EmergencyNum);
   $TypeOne = stripslashes($TypeOne);
   $TypeTwo = stripslashes($TypeTwo);
   $TypeThree = stripslashes($TypeThree);
   $PetOne = stripslashes($PetOne);
   $PetTwo = stripslashes($PetTwo);
   $PetThree = stripslashes($PetThree);
   $BreedOne = stripslashes($BreedOne);
   $BreedTwo = stripslashes($BreedTwo);
   $BreedThree = stripslashes($BreedThree);
   $BornOne = stripslashes($BornOne);
   $BornTwo = stripslashes($BornTwo);
   $BornThree = stripslashes($BornThree);
   $SexOne = stripslashes($SexOne);
   $SexTwo = stripslashes($SexTwo);
   $SexThree = stripslashes($SexThree);
   $SizeOne = stripslashes($SizeOne);
   $SizeTwo = stripslashes($SizeTwo);
   $SizeThree = stripslashes($SizeThree);
   $BarkerOne = stripslashes($BarkerOne);
   $BarkerTwo = stripslashes($BarkerTwo);
   $BarkerThree = stripslashes($BarkerThree);
   $CodeOne = stripslashes($CodeOne);
   $CodeTwo = stripslashes($CodeTwo);
   $CodeThree = stripslashes($CodeThree);
   $Descriptions = stripslashes($Descriptions);
   $Instructions = stripslashes($Instructions);

// This first line of Code is to load your database variables.
require 'include.php';

// This connects to your database.
mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db("$DBName");

// This line converts name to uppercase so the login is not case sensitive.
$OwnersName = strtoupper ($OwnersName);

// This is the SQL statement that will update the settings in the Database.
$query = "UPDATE theojm_Clients SET Address='$Address&', City='$City&', State='$State&', Zip='$Zip&', City='$City&', PhoneNum='$PhoneNum&', CellNum='$CellNum&', EmergencyNum='$EmergencyNum&', TypeOne='$TypeOne&', TypeTwo='$TypeTwo&',TypeThree='$TypeThree&', PetOne='$PetOne&',PetTwo='$PetTwo&',PetThree='$PetThree&', BreedOne='$BreedOne&',BreedTwo='$BreedTwo&',BreedThree='$BreedThree&', BornOne='$BornOne&',BornTwo='$BornTwo&',BornThree='$BornThree&', SexOne='$SexOne&',SexTwo='$SexTwo&',SexThree='$SexThree&', SizeOne='$SizeOne&',SizeTwo='$SizeTwo&',SizeThree='$SizeThree&', BarkerOne='$BarkerOne&',BarkerTwo='$BarkerTwo&',BarkerThree='$BarkerThree&', CodeOne='$CodeOne&',CodeTwo='$CodeTwo&',CodeThree='$CodeThree&', Descriptions='$Descriptions&',Instructions='$Instructions&', VetName='$VetName&',VetNum='$VetNum&',VetExpenseLimit='$VetExpenseLimit&', MedOne='$MedOne&',MedTwo='$MedTwo&',MedThree='$MedThree&', DogRabiesOne='$DogRabiesOne&',DogRabiesTwo='$DogRabiesTwo&',DogRabiesThree='$DogRabiesThree&', DhlppOne='$DhlppOne&',DhlppTwo='$DhlppTwo&',DhlppThree='$DhlppThree&', CatRabiesOne='$CatRabiesOne&',CatRabiesTwo='$CatRabiesTwo&',CatRabiesThree='$CatRabiesThree&', FvrcpOne='$FvrcpOne&',FvrcpTwo='$FvrcpTwo&',FvrcpThree='$FvrcpThree&', LeukOne='$LeukOne&',LeukTwo='$LeukTwo&',LeukThree='$LeukThree&', FeedOne='$FeedOne&',FeedTwo='$FeedTwo&',FeedThree='$FeedThree&', GroomedOne='$GroomedOne&',GroomedTwo='$GroomedTwo&',GroomedThree='$GroomedThree&', DateOne='$DateOne&',DateTwo='$DateTwo&',DateThree='$DateThree&', PriceOne='$PriceOne&',PriceTwo='$PriceTwo&',PriceThree='$PriceThree&', InfoOne='$InfoOne&',InfoTwo='$InfoTwo&',InfoThree='$InfoThree&', NightsOne='$NightsOne&',NightsTwo='$NightsTwo&',NightsThree='$NightsThree&', RateOne='$RateOne&',RateTwo='$RateTwo&',RateThree='$RateThree&', GroomOne='$GroomOne&',GroomTwo='$GroomTwo&',GroomThree='$GroomThree&', MiscOne='$MiscOne&',MiscTwo='$MiscTwo&',MiscThree='$MiscThree&', TotalOne='$TotalOne&',TotalTwo='$TotalTwo&',TotalThree='$TotalThree&',TotalFour='$TotalFour&', DepositOne='$DepositOne&',DepositTwo='$DepositTwo&',DepositThree='$DepositThree&', Comment='$Comment'  WHERE OwnersName='$OwnersName'";
$result = mysql_query($query);


// This prints out the success command to a text field in the movie if it's successful.

print "_root.UpdateStatus=Success Updated - It's saved $OwnersName";
   

?>

[Ronald Wernecke]

Hi,
do you have phpMyAdmin installed?

If not, you should

If you have troble with the syntax of a query, or doubt a query, just enter it into the sql window at phpMyAdmin.
It will tell you where you failed.

Question: what are these apersend signs doing in your query?

Remark: concatination "string$variable" sometimes wors fine, but makes troble with mixed quotes.
To be on the safe side, use the concatination symbol . (dot) to concatinate strings and variables (like: "string".$variable."Stiring" etc.)

[B-L-A-D-E]

The Reason I Wrote The Query that way because im tring to load 95 data Fields from the sql into  95 TextFilds in flash.

How Would I Do This?

Im also tring to make a search for the data base? how could i use a textfield in flash var:OwnersName and via button search the database for any ownersname like that if there is load all 95 fields dealing wit that client load into 95 input text fields in flash for editing?

[Ronald Wernecke]

Hi,
where do you have this db from?
what are you trying to do?
If you get a list (recordset), then you can walk through it with a loop.

[B-L-A-D-E]

Im tring to make a client database but having trouble...

[Andresss]

hello BLADE!!! for the records you are receiving you can use the DataGrid component, Jorge wrote a very good tutorial about this (loading data into datagrids), now for your search, use a textInput component and then use something like "select column1 from mytable where clumn2 like _[here you write a word you are looking, with no brackets]" that's it

cheers!!!

[Ronald Wernecke]

If you create this database your own, think over the structure.
Did you hear from normalizing a table?
You should do this, after you know which data you will need.
Youre table structure cryes for normalisation

[B-L-A-D-E]

Could not execute query : INSERT INTO registration (id, ownersname, address, city, state, Zip, homenum, cellnum, emergencynum, typeone, typetwo, typethree, petone, pettwo, petthree, breedone, breedtwo, breedthree, bornone, borntwo, bornthree, sexone, sextwo, sexthree, sizeone, sizetwo, sizethree, barkerone, barkertwo, barkerthree, codeone, codetwo, codethree, descriptions, instructions, vetname, vetnum, vetexpenselimit, medone, medtwo, medthree, dograbiesone, dograbiestwo, dograbiesthree, dhlppone, dhlpptwo, dhlppthree, catrabiesone, catrabiestwo, catrabiesthree, fvrcpone, fvrcptwo, fvrcpthree, leukone, leuktwo, leukthree, feedone, feedtwo, feedthree, groomedone, groomedtwo, groomedthree, dateone, datetwo, datethree, priceone, pricetwo, pricethree, infoone, infotwo, infothree, nightsone, nightstwo, nightsthree, rateone, ratetwo, ratethree, groomone, groomtwo, groomthree, miscone, misctwo, miscthree, totalone, totaltwo, totalthree, totalfour, depositone, deposittwo, depositthree, ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '').You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '


How Should I Go About Fixing This?

[Ronald Wernecke]

you have an error ....

delete the comma at the end of the fields list.
why do you want to insert an empty record?

check for your variables, and make sure they are filled with data.

what happens if one has more than 3 pets?

[B-L-A-D-E]

LoL I Reason There Emply Is Because Nothin Got Taking From Flash But I Donno Yet About More Than 3 Pets Im New To This.. lol

[B-L-A-D-E]

How Could I Search My Data Base via flash field And Load All Info Conerning The Search Name get selected from the database and loaded into flash and How Could I Search By id # and Show All Information

[Ronald Wernecke]

If you have the chance, take a look into a book about databases

Depending of what you are searching, you can write different select statements, or generate select statements by script (which in my opinion is the best methode).

in the where clause you can write about everything.

like mysql_query("select list of fields you want to receive from table where ownersname='".$searchname."'");

[B-L-A-D-E]

This Is What I Got? What Did I Do Wrong


<?php


include("Connect.php");

$Search = stripslashes(Search);

$query="SELECT * FROM Registration WHERE ownersname = '$Search' OR cellnum = '$Search' OR homenum = '$Search';
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$ownersname = mysql_result($result,$i,"ownersname");
$address = mysql_result($result,$i,"address");
$city = mysql_result($result,$i,"city");
$state = mysql_result($result,$i,"state");
$zip = mysql_result($result,$i,"zip");
$homenum = mysql_result($result,$i,"homenum");
$cellnum = mysql_result($result,$i,"cellnum");
$emergencynum = mysql_result($result,$i,"emergencynum");
$typeone = mysql_result($result,$i,"typeone");
$typetwo = mysql_result($result,$i,"typetwo");
$typethree = mysql_result($result,$i,"typethree");
$petone = mysql_result($result,$i,"petone");
$pettwo = mysql_result($result,$i,"pettwo");
$petthree = mysql_result($result,$i,"petthree");
$breedone = mysql_result($result,$i,"breedone");
$breedtwo = mysql_result($result,$i,"breedtwo");
$breedthree = mysql_result($result,$i,"breedthree");
$bornone = mysql_result($result,$i,"bornone");
$borntwo = mysql_result($result,$i,"borntwo");
$bornthree = mysql_result($result,$i,"bornthree");
$sexone = mysql_result($result,$i,"sexone");
$sextwo = mysql_result($result,$i,"sextwo");
$sexthree = mysql_result($result,$i,"sexthree");
$sizeone = mysql_result($result,$i,"sizeone");
$sizetwo = mysql_result($result,$i,"sizetwo");
$sizethree = mysql_result($result,$i,"sizethree");
$barkerone = mysql_result($result,$i,"barkerone");
$barkertwo = mysql_result($result,$i,"barkertwo");
$barkerthree = mysql_result($result,$i,"barkerthree");
$codeone = mysql_result($result,$i,"codeone");
$codetwo = mysql_result($result,$i,"codetwo");
$codethree = mysql_result($result,$i,"codethree");
$descriptions = mysql_result($result,$i,"descriptions");
$instructions = mysql_result($result,$i,"instructions");
$vetname = mysql_result($result,$i,"vetname");
$vetnum = mysql_result($result,$i,"vetnum");
$vetexpenselimit = mysql_result($result,$i,"vetexpenselimit");
$medone = mysql_result($result,$i,"medone");
$medtwo = mysql_result($result,$i,"medtwo");
$medthree = mysql_result($result,$i,"medthree");
$dograbiesone = mysql_result($result,$i,"dograbiesone");
$dograbiestwo = mysql_result($result,$i,"dograbiestwo");
$dograbiesthree = mysql_result($result,$i,"dograbiesthree");
$dhlppone = mysql_result($result,$i,"dhlppone");
$dhlpptwo = mysql_result($result,$i,"dhlpptwo");
$dhlppthree = mysql_result($result,$i,"dhlppthree");
$catrabiesone = mysql_result($result,$i,"catrabiesone");
$catrabiestwo = mysql_result($result,$i,"catrabiestwo");
$catrabiesthree = mysql_result($result,$i,"catrabiesthree");
$fvrcpone = mysql_result($result,$i,"fvrcpone");
$fvrcptwo = mysql_result($result,$i,"fvrcptwo");
$fvrcpthree = mysql_result($result,$i,"fvrcpthree");
$leukone = mysql_result($result,$i,"leukone");
$leuktwo = mysql_result($result,$i,"leuktwo");
$leukthree = mysql_result($result,$i,"leukthree");
$feedone = mysql_result($result,$i,"feedone");
$feedtwo = mysql_result($result,$i,"feedtwo");
$feedthree = mysql_result($result,$i,"feedthree");
$groomedone = mysql_result($result,$i,"groomedone");
$groomedtwo = mysql_result($result,$i,"groomedtwo");
$groomedthree = mysql_result($result,$i,"groomedthree");
$dateone = mysql_result($result,$i,"dateone");
$datetwo = mysql_result($result,$i,"datetwo");
$datethree = mysql_result($result,$i,"datethree");
$priceone = mysql_result($result,$i,"priceone");
$pricetwo = mysql_result($result,$i,"pricetwo");
$pricethree = mysql_result($result,$i,"pricethree");
$infoone = mysql_result($result,$i,"infoone");
$infotwo = mysql_result($result,$i,"infotwo");
$infothree = mysql_result($result,$i,"infothree");
$nightsone = mysql_result($result,$i,"nightsone");
$nightstwo = mysql_result($result,$i,"nightstwo");
$nightsthree = mysql_result($result,$i,"nightsthree");
$rateone = mysql_result($result,$i,"rateone");
$ratetwo = mysql_result($result,$i,"ratetwo");
$ratethree = mysql_result($result,$i,"ratethree");
$groomone = mysql_result($result,$i,"groomone");
$groomtwo = mysql_result($result,$i,"groomtwo");
$groomthree = mysql_result($result,$i,"groomthree");
$miscone = mysql_result($result,$i,"miscone");
$misctwo = mysql_result($result,$i,"misctwo");
$miscthree = mysql_result($result,$i,"miscthree");
$totalone = mysql_result($result,$i,"totalone");
$totaltwo = mysql_result($result,$i,"totaltwo");
$totalthree = mysql_result($result,$i,"totalthree");
$totalfour = mysql_result($result,$i,"totalfour");
$depositone = mysql_result($result,$i,"depositone");
$deposittwo = mysql_result($result,$i,"deposittwo");
$depositthree = mysql_result($result,$i,"depositthree");
$id = mysql_result($result,$i,"id");

echo "ownersname=$ownersname";
echo "address=$address";
echo "city=$city";
echo "state=$state";
echo "zip=$zip";
echo "homenum=$homenum";
echo "cellnum=$cellnum";
echo "emergencynum=$emergencynum";
echo "typeone=$typeone";
echo "typetwo=$typetwo";
echo "typethree=$typethree";
echo "petone=$petone";
echo "pettwo=$pettwo";
echo "petthree=$petthree";
echo "breedone=$breedone";
echo "breedtwo=$breedtwo";
echo "breedthree=$breedthree";
echo "bornOne=$bornone";
echo "borntwo=$borntwo";
echo "bornthree=$bornthree";
echo "sexone=$sexone";
echo "sextwo=$sextwo";
echo "sexthree=$sexthree";
echo "sizeone=$sizeone";
echo "sizetwo=$sizetwo";
echo "sizethree=sizethree";
echo "barkerone=$barkerone";
echo "barkertwo=$barkertwo";
echo "barkerthree=$barkerthree";
echo "codeone=$codeone";
echo "codetwo=$codetwo";
echo "codethree=$codethree";
echo "descriptions=$descriptions";
echo "instructions=$instructions";
echo "vetname=$vetname";
echo "vetnum=$vetnum";
echo "vetexpenselimit=$vetexpenselimit";
echo "medone=$medone";
echo "medtwo=$medtwo";
echo "medthree=$medthree";
echo "dograbiesone=$dograbiesone";
echo "dograbiestwo=$dograbiestwo";
echo "dograbiesthree=$dograbiesthree";
echo "dhlppone=$dhlppone";
echo "dhlpptwo=$dhlpptwo";
echo "dhlppthree=$dhlppthree";
echo "catrabiesone=$catrabiesone";
echo "catrabiestwo=$catrabiestwo";
echo "catrabiesthree=$catrabiesthree";
echo "fvrcpone=$fvrcpone";
echo "fvrcptwo=$fvrcptwo";
echo "fvrcpthree=$fvrcpthree";
echo "leukone=$leukone";
echo "leuktwo=$leuktwo";
echo "leukthree=$leukthree";
echo "feedone=$feedone";
echo "feedtwo=$feedtwo";
echo "feedthree=$feedthree";
echo "groomedone=$groomedone";
echo "groomedtwo=$groomedtwo";
echo "groomedthree=$groomedthree";
echo "dateone=$dateone";
echo "datetwo=$datetwo";
echo "datethree=$datethree";
echo "priceone=$priceone";
echo "pricetwo=$pricetwo";
echo "pricethree=$pricethree";
echo "infoone=$infoone";
echo "infotwo=$infotwo";
echo "infothree=$infothree";
echo "nightsone=$nightsone";
echo "nightstwo=$nightstwo";
echo "nightsthree=$nightsthree";
echo "rateone=$rateone";
echo "ratetwo=$ratetwo";
echo "ratethree=$ratethree";
echo "groomone=$groomone";
echo "groomtwo=$groomtwo";
echo "groomthree=$groomthree";
echo "miscone=$miscone";
echo "misctwo=$misctwo";
echo "miscthree=$miscthree";
echo "totalone=$totalone";
echo "totaltwo=$totaltwo";
echo "totalthree=$totalthree";
echo "totalfour=$totalfour";
echo "depositone=$depositone";
echo "deposittwo=$deposittwo";
echo "depositthree=depositthree";

++$i; } } else { echo "The database is empty"; }?>



And Got

Parse error: syntax error, unexpected T_STRING in /Clients/Search.php on line 16

[B-L-A-D-E]

i think i  got it all to work except the data im searching for in not being printed into flash? how do i print the data into flash?