refiking

Here is the other insert code: $store = "INSERT INTO Records(analyst_id , record_id , b_first_name , b_last_name , c_first_name , c_last_name , address, city , state , zip , loan_amount , rate , cap , mo_pay , new_rate , new_mopay , pay_change , change_date , ltv , lender , telephone , ipaddy , timestamp) VALUES('$analyst_id','$record_id','$bfn','$name','$cfn','$cln','$add','$city','$state','$zip','$la','$iir', '$adjc','$mpay','$nr','$nmpay','$change','$cpdate','$ltv','$lender','$tel','$ipaddy','$dun')";

INSERT INTO `Records` VALUES (`analyst_id`) VALUES ('ma1')

35

ma123, ma124, and ma125 They basically all start with ma.

Well, I don't know what the problem is then. I checked the types. Both are VARCHAR. When I echo, it shows the id. Hmmm.....

Wait a second!!! I almost forgot. I am adding the other fields to the same record later in the page (around 250 lines later). Does that make a difference? The ID is not an INT. It's a VARCHAR. When I did the echo, it came right up with no problem.

Yes. I have the analyst_id field in the Records table. However, when I ran it, it didn't pllace it in the Records table.

Yes. I think we are saying the same thing. I want to take the analyst's personal id and place it on each one of their records they are responsible for. There are two tables. Analysts and Records. The Analysts table just stores the info about the analysts. The Records table stores the info about the records. Did I make it clear or make it more confusing?

OK!!!! That made it echo the id onto the page. Now, how can I place that in my Records table?

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ctpwebco/public_html/leads/proc.php on line 63 This is line 63: while($row = mysql_fetch_assoc($que)){

Problem Solved! Thanks a million!!! Now, I can thank you 2 million if you can help me with the other one.

I looked, but I didn't see anything. Here are lines 63 - 68: $analyst = mysql_query(" SELECT `analyst_id` FROM `Analysts` WHERE username = '$username'"); $que = mysql_query($analyst); while($row = mysql_fetch_assoc($que)){ echo $row['analyst_id']." \n"; }

The following error message appears: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ctpwebco/public_html/leads/proc.php on line 60 Here is the code for line 60: $fetch = mysql_fetch_assoc(mysql_query("SELCT `record_id` FROM `Records` ORDER BY `record_id` DESC LIMIT 1")); Neither problem is fixed, yet? Did I miss a step or is there something else to it?

I am now getting the following error message: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ctpwebco/public_html/leads/proc.php on line 64 Line 64 is the following: while($row = mysql_fetch_assoc($que)){

I am trying to use the auto increment feature and I am completely stuck. I am trying to automatically give each form a new record number. What am I missing? Here is the code: $query1 = "SELECT last_insert_id(record_id) FROM Records"; $record1 = mysql_query($query1); $record_id = $record1 + 1;

I am trying to call the analyst_id from the Analysts table and store it on the Records table. Here is my code: $analyst = mysql_query(" SELECT `analyst_id` FROM `Analysts` WHERE username = '$username'"); $que = mysql_query($analyst); while($row = mysql_fetch_assoc($que){ echo $row["analyst_id"]."<br />\n"; } What am I doing wrong here?