I am using firefox. Neither working for me. Neither code or inline code. Yes only code used to open a dialog box and inline code used to get the code in brackets or something. That doesnt work for me. Nothing of the text processing working for me. B,I LINK and so on.. what did i do wrong?>
<input type='hidden' value="selected_ids" name="selected_ids" multiple="yes" id="selected_ids" />
Alternative: paste your code into the editor, ensure a blank line between your last bit of text and the first line of the code block. Select all entire code block and press TAB.
So back to the question. Show your SQL, your table and structure. The code you posted is of little value as we don't even know if you're using the right enctype in your form tag. C'mon Simon - help us to help you.
i know that the js and html are fine. I am not sure about the php.
You mean i should it by creating another row on my table? Can you give an example?
Posting the same code again? Not sure why.
The values was a mistake but its not this. The '100,102,204' are finctional ids, the point is that i want to store multiple values in one row. Here is the code that i dont know if its right.
The whole point about NOT storing multiple values in one row is that it's the WRONG way to do it. If you insist on this approach, I don't really know what to suggest, other than to wish you well with it.
I read both articles. I dont think that this will apply to my situation. Because there is no violation of first normal form. I use child tables or second and third normal forms in many cases on my db. Let me explain what i want to do. Lets say that you want to send the same message to more than one user. As far as i understand i ll have to make a second formal form with each user id and the message itself or only the same message id right? Why do that? The same message will go to several users. There will be no conflict in the db. There is not going to be the same message again anyway because they will be unique by their id.
The issue comes when the user searches for messages to him/her. At the moment you want to place
'102,786,234,...' into a field. So if I'm user #786, the DB needs to search every row for 786 within that field. You'd probably need to use a FIND_IN_SET()in your WHERE clause. Urgh.
I'd use an index and normalized table, as I noted previously. But that's just MY opinion. Anyhow your original question is about the building of the string. Print the query to the screen (followed by exit) to see what it says.
Ok. I am not so advanced to fully understand what you are saying but i got the picture. In this case its not going to have a search option for the user but that its not the point, i ot what you are saying. I did an echo not print the values are showing ok but there not stored in the database and i dont know why
by SimonIoa: change
$query = mysqli_query($this->db,"INSERT INTO `table` (title,desc,url, img, uid_fk, created, to_uid_fk) VALUES ('$update','$update_description','$press_url','$press_image','$uid','$time',$val)") or die(mysql_error());
$result = mysqli_fetch_array($newquery,MYSQLI_ASSOC);