mysql_query(): 35 is not a valid MySQL-Link resource

[Simplyput]

I keep getting this error everytime I execute the following code. My problem child is this line.

$result2 = mysql_query($q_6,$conn_new_4) or die (mysql_error ());

I am populating another database with the following information that is passed through via a form from a script with a diffrent database. Everything is going good until I hit this error message.

My 2 cents

1. I do not think that I have passed in the id correctly.
2. Changed original mysql_db_query to mysql_query on the problem line and still no joy.

Can it be that I am reusing the same connection for the second result set. By the way can you tell I am kind of new at this🙂 I am learning but at the moment I need help. Can someone take a look at the following code and tell me if they see something wrong.

Thanks

$conn_new_3=mysql_connect("localhost", "xxx", "xxx"); 
$q_3="insert into silly_user(user_created,user_updated,user_nickname,user_password,user_emailadr,user_temp) values('".$id."','".$t."','".$t."','".$login."','".$pswd_1."','.$email.','".$pswd."')";
$user_id = mysql_insert_id();
$q_4="insert into silly_user (user_id) values('".$user_id."')";
$db_new_3=mysql_select_db("db2",$conn_new_3) or die("db cant open");
mysql_close($conn_new_3);

													               $conn_new_4=mysql_connect("localhost", "xxx", "xxx"); 
$q_5="select * from play_band_info a, silly_user b Where a.band_name = b.user_nickname"; 
$result = mysql_db_query("db2",$q_5,$conn_new_4) or die (mysql_error()); 
while ($row = mysql_fetch_assoc($result))                                { 
$q_6 = "update silly_user set user_band_id = '".$row['band_id']."' where user_nickname = '".$row['band_name']."'"; 
$result2 = mysql_query($q_6,$conn_new_4) or die (mysql_error ());
mysql_close($conn_new_4);

[bradgrafelman]

1. Why do you close the MySQL connection, but then reopen it?

2. In "q_4" you attempt to insert a new row that has the same user_id as the last row, and with every other column blank. Why?

3. As the error message explains, $conn_new_4 did not return a MySQL link identifier... so, try seeing if MySQL spit out an error message instead of establishing a connection (add an "or die()" statement onto the end, much like you do with the queries).

4. This code is not only a mess, but probably could be condensed to one or two lines. Can you explain to us what you are trying to do?

[Simplyput]

You are right its a mess and I am still somewhat new to codine php. I am good hack not a programmer. Now to why I am doing it this way.

2. In "q_4" you attempt to insert a new row that has the same user_id as the last row, and with every other column blank. Why?

I needed to grab the ID from Mysql and reinsert it back into the table. The only way I could do this was to run a successful insert first and then use mysql_insert_id(); to grab the id as a result and populate the table with it. Should I have used update and not insert for this?

In a nut shell I am trying to add code to make one script populate another scripts database so my members will not have to register twise. Two things have to happen for this to happen.

1. I need to get the table id to populate in silly_user
2. I need to populate the silly_user table's user_band_id to be populated with the same ID as play_band_info's band_id for this to work. I hope I explained this well enough.

[bradgrafelman]

Simplyput wrote:

I needed to grab the ID from Mysql and reinsert it back into the table. The only way I could do this was to run a successful insert first and then use mysql_insert_id(); to grab the id as a result and populate the table with it.

That makes no sense... what do you mean, "populate the table with it" ? Do you mean, you want to set the user_id of the last user you just inserted to the value given by mysql_insert_id() ? If so... why? If you just inserted a new row, and user_id is an auto_increment field, then it will already have been automatically set to the next ID number.

As for your other 2 queries... I would think you could combine them, though I'm not understanding your table structure. Are "band_name" and "user_nickname" supposed to match up? Is there any chance you can provide us with some sample data from the two tables you query?

[Simplyput]

bradgrafelman wrote:

That makes no sense... what do you mean, "populate the table with it" ? Do you mean, you want to set the user_id of the last user you just inserted to the value given by mysql_insert_id() ? If so... why? If you just inserted a new row, and user_id is an auto_increment field, then it will already have been automatically set to the next ID number.

1. Yes I am trying to set the user_id of the last user I inserted to the value given by mysql_insert_ID. The id field is an auto_increment field but its not working so I am using the mysql_insert_id to get this value. I will play with it more and figure it out.

[bradgrafelman]

What do you mean "not working" ? What do newly inserted rows have for a user_id?

If you omit an auto_increment field from an INSERT statement, MySQL will automatically give that row the next id in the sequence. If it's not doing this, then this column is apparently not set as AUTO_INCREMENT.