The Help Of Two-Table Query?

[gecekule]

Hello,

 

I'm sorry, my English is bad

 

I'm beginner

 

include "./includes/config.php"; sql connection to the existing

 

The help of two-table query?

 

 

 

Best Regards

Thanks

[smoseley]

Your table1 design is incorrect.

 

It should look more like this:

id      table2_id     amount
5       1             12
5       3             3
5       5             7

[gecekule]

Thank you for your answer

 

Tables of have to be like in the picture

Continues to Tables

This picture is an example

The first table resource based, I have to make query, but how?

[gecekule]

OR How do I write to the database?

Insert multi row?

id	 table2_id	 amount
5		 1					 12
5		 3					 3
5		 5					 7

 

source:

$id=5;

name="produc_id[]"

name="amount[]"

 

implode(", ", $_REQUEST['produc_id'] // 2, 4, 6, 7 like

implode(", ", $_REQUEST['amount'] // 5, 8, 12, 20 like

[gecekule]

Helo,

Here is the error?

$query = 'INSERT INTO table_name (`id`, `receiver_id`, `receiver_adet`) VALUES (5, (' .implode('), (', $_REQUEST['secilenreceivermarka_id']). .implode(')', '(', $_REQUEST['secilen_receiver_sayisi']) . '))';
$result = mysql_query($query)
or die('Could not execute INSERT query');

 

Thanks

[Jessica]

You really should fix the structure of the tables. Google normalization

[gecekule]

Change yes, This code does not work for the new table.

I wonder what this error code?

 

$query = 'INSERT INTO table_name (`id`, `receiver_id`, `receiver_adet`) VALUES (5, (' .implode('), (', $_REQUEST['secilenreceivermarka_id']). .implode(')', '(', $_REQUEST['secilen_receiver_sayisi']) . '))';
$result = mysql_query($query)
or die('Could not execute INSERT query');

Thanks

[jazzman1]

Could you echoing out your $query before to send it to the database and post out the result, please.

I suspect that you have a syntax error(s). Also, instead of die('Could not execute INSERT query') use die(mysql_error()).

[gecekule]

Parse error: syntax error, unexpected '.' in D:\www\8.php on line 77

 

I guess the problem here: .implode('), (', $_REQUEST

[jazzman1]

So, your problem is obvious!