StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19998704
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-15T10:18:50.073
FavoriteCount
0
LastActivityDate
2013-11-15T10:18:50.073
LastEditDate
LastEditorUserId
0
OwnerUserId
2995667
ParentId
19997561
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You appear to be using a lot of quotation marks in places that you shouldn't be using them in. It is funny how you can code something for 5 hours and then try to debug it for 2 hours because of a simple quotation mark! It's funny and very depressing at the same time :( Ok, let's fix the code a little bit! Database <pre><code>$link=mysql_connect($host, $username, $password); if (!$link) { die('Could not connect: ' . mysql_error()); } // make foo the current db $db_selected = mysql_select_db($database); if (!$db_selected) { die ('db is not selected : ' . mysql_error()); } </code></pre> Notice how I stripped all of the quotation marks out of the code? That will help with database connection and selection. Now let's move onto the actual inserting of the information into the database! <pre><code>$query = "INSERT INTO clanovi ('Ime', 'Prezime', 'Firma', 'Adresa', 'Telefon', 'Fax', 'Mobitel, 'Email', 'Web_stranica') VALUES ( $field1, $field2, $field3, $field4, $field5, $field6, $field7, $field8, $field9)"; </code></pre> Again, I stripped all of the quotation marks. Plus I removed backticks and replaced with a ' and also took the '' off of your table name - You should nly use quotation marks when not using a variable. <pre><code>//Correct VALUES ($field1, "textnotvariable", $field2... //Incorrect VALUES ("$field1", "textnotvariable", "field2"... </code></pre> The same goes with echo statements. Here's an example... <pre><code>$myname = "MrJustin"; //Correct echo $myname; //or echo "My name is ". $myname .", it's nice to meet you!"; //Incorrect echo "My name is $myname, it's nice to meet you"; </code></pre> You'll notice how I used ". $myname ." - that tells the echo to break away from using text, and to pass a variable! :) That to me is the best way to explain how quotations will break a code. Oh, and you should ALWAYS sanitize your inputs/outputs when using foreign code. I would do some Google searching on that one, and then chat us back up if you run into problems with that! Hopefully this helps, and happy coding!!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCode doesn't write values in db
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMrJustin
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.