I hope someone will help me. I'm trying to insert several users at ones in the database using phpMyAdmin. I used the same command first with one user and it worked all fine but when I put several rows in the command it didn't work. The rows were added to database fine, but I couldn't see profiles on the website.

Any idea what do I do wrong?

Thank you for your help!

I hope someone will help me. I'm trying to insert several users at ones in the database using phpMyAdmin. I used the same command first with one user and it worked all fine but when I put several rows in the command it didn't work. The rows were added to database fine, but I couldn't see profiles on the website.

Any idea what do I do wrong?

Thank you for your help!

hi can you show us your script are you limiting the number of rows called

hi can you show us your script are you limiting the number of rows called

 

I'm just started to learn, so please don't laugh at me

I tried to insert the users with a command:

 

 

INSERT INTO members 
(mem_username, mem_password, mem_surname, mem_forename, mem_email, mem_newsletter, mem_joindate, mem_dob, mem_expiredate, mem_lastvisit,  mem_sex, mem_type, mem_online, lang_id, mem_confirm, mem_suspend)
VALUES 
("Laura", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1976- 05-04", "2009-02-03", "2008-11-11", "F", "U", "N", "RU", "1", "N"),
("Hidden Tallent", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1983- 05-04", "2009-02-03", "2008-11-11", "F", "U", "Y", "RU", "1", "N"),
("Zaika", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1982- 05-04", "2009-02-03", "2008-11-11", "F", "U", "N", "RU", "1", "N"),
("Lollypie", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1979- 05-04", "2009-02-03", "2008-11-11", "F", "U", "Y", "RU", "1", "N"),
("Evesta", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1978- 05-04", "2009-02-03", "2008-11-11", "F", "U", "N", "RU", "1", "N"),
("Dominica", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1986- 05-04", "2009-02-03", "2008-11-11", "F", "U", "Y", "RU", "1", "N"),
("Ksusha", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1987- 05-04", "2009-02-03", "2008-11-11", "F", "U", "N", "RU", "1", "N"),
("Arianna", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1983- 05-04", "2009-02-03", "2008-11-11", "F", "U", "Y", "RU", "1", "N"),
("Lida", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1986- 05-04", "2009-02-03", "2008-11-11", "F", "U", "N", "RU", "1", "N"),
("Jessika", "kharkov", "Kravchenko", "Olia", "6@globalnuptials.com", "0", "2008-11-11", "1985- 05-04", "2009-02-03", "2008-11-11", "F", "U", "N", "RU", "1", "N");

 

It's how my book told me... I did not limit the number of rows called I didn't even know that I had to... How should I do it?

Thanks

we all have to learn

 

 

ok you say it inserts into phpmyadmin ok but not on your web page can you show us your php script limit just limits the number of rows for example if you add a script that selects say 100 rows from a table and you wouldnt want 100 rows displayed on a page you could limit it to say 10 pages with 10 rows on page

we all have to learn

 

 

ok you say it inserts into phpmyadmin ok but not on your web page can you show us your php script limit just limits the number of rows for example if you add a script that selects say 100 rows from a table and you wouldnt want 100 rows displayed on a page you could limit it to say 10 pages with 10 rows on page

I think we are talking about different things. sorry I probably didn't explain it enough. I'm adding users to the dating website. Each row is a different user and different page on the site.

What do you mean to show you php script? Do I need to show the structure of the table? Sorry, I don't understand

I think we are talking about different things. sorry I probably didn't explain it enough. I'm adding users to the dating website. Each row is a different user and different page on the site.

What do you mean to show you php script? Do I need to show the structure of the table? Sorry, I don't understand

with you saying it inserts into the database but you do not see their profile on the website,if we can see the script that displays the profile we can see whats been selected from the database and where its been displayed on the web page and than we may find an error

with you saying it inserts into the database but you do not see their profile on the website,if we can see the script that displays the profile we can see whats been selected from the database and where its been displayed on the web page and than we may find an error

I understood now but the problem is, how do I get the script of the page? there is now page with those profiles on the website at all. How would I find that script?

Thank you for trying to help. I understand it's hard to explaine something to me as I know so little but I'm really trying to work it out and learn. It's hard to learn without any teacher just with books and internet...

I understood now but the problem is, how do I get the script of the page? there is now page with those profiles on the website at all. How would I find that script?

Thank you for trying to help. I understand it's hard to explaine something to me as I know so little but I'm really trying to work it out and learn. It's hard to learn without any teacher just with books and internet...

ok say you hava a page called profile.php the page would be made up of html and links 2 css and php scripts

 

the php will be used to extract the data from the database and display it on your web page the php will be found between these tags

 

<?php

 

php script goes here

 

?>

 

have you got a link to the live website

I understood now but the problem is, how do I get the script of the page? there is now page with those profiles on the website at all. How would I find that script?

Thank you for trying to help. I understand it's hard to explaine something to me as I know so little but I'm really trying to work it out and learn. It's hard to learn without any teacher just with books and internet...

 

is your page displaying the first entry only, if so can we see the code for that page before it generates the profile