how to create a database if data is given?

Lost User

That will depend on the layout of your CSV files. If there's no difference in layout, then it might be done using a single table. I can imagine calculating the popularity as an occurence of the name between a set of dates, compared to 'any' other name on the same set of dates. ..that is, of the same gender, of course. A female-baby name does not compete with any of the male-baby names.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

User 11236637

[^]https://drive.google.com/file/d/0Bz4F2FWI2Rx9S0tWUlN6dy1pTUU/view[^] this is the link to the data that has been provided to be entered in the database.please have a look at it and tell me if it will work in a single table.

Lost User

I cannot download the zip, just list its contents. Means I also cannot view the content of these files. Still, by the naming-pattern of the file, I'd guess that all files have the same layout and that a single table would do.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Lost User

My apologies, it appears my comments are caught in the spam-filter. Answer was roughly "yes".

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

User 11236637

yeah the layout is same,but i will have to add two columns gender and year to specify the gender and year right?

Lost User

If they are not in the original data as columns, then yes, please do; it will make creating a selection-query a lot easier - you'll need them for calculating popularity :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

User 11236637

Thanks for your help.I will try and implement it and if i have any doubts i'l get back to you.

Lost User

You're welcome :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

User 11236637

i have problem with this code can you plzz check for errors.I was working on live search. <html> <head> <title>Ajax Search Box using PHP and MySQL</title> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <script src="typeahead.min.js"></script> <script > $(document).ready(function(){ $('input.typeahead').typeahead({ name: 'typeahead', remote: 'search.php?key=%QUERY', limit : 10 }); }); </script> .bs-example{ font-family: sans-serif; position: relative; margin: 50px; } .typeahead, .tt-query, .tt-hint { border: 2px solid #CCCCCC; border-radius: 8px; font-size: 24px; height: 30px; line-height: 30px; outline: medium none; padding: 8px 12px; width: 396px; } .typeahead { background-color: #FFFFFF; } .typeahead:focus { border: 2px solid #0097CF; } .tt-query { box-shadow: 0 1px 1px rgba(0, 0, 0, 0.075) inset; } .tt-hint { color: #999999; } .tt-dropdown-menu { background-color: #FFFFFF; border: 1px solid rgba(0, 0, 0, 0.2); border-radius: 8px; box-shadow: 0 5px 10px rgba(0, 0, 0, 0.2); margin-top: 12px; padding: 8px 0; width: 422px; } .tt-suggestion { font-size: 24px; line-height: 24px; padding: 3px 20px; } .tt-suggestion.tt-is-under-cursor { background-color: #0097CF; color: #FFFFFF; } .tt-suggestion p { margin: 0; } </head> <body>

Ajax Search Box using Node and MySQL Codeforgeek Tutorial

<button type="button" class="btn btn-primary btn-lg">Visit Tutorial</button>

</body> </html>

Lost User

I'm not that home in ASP, not a language I work with very often; you might have more success in the ASP.NET forum.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)