ChatlogMediaEventsAchievements
22:45
== JJunisonaj quit
22:35
== ★Azria quit
22:33
== JJunisonaj joined #main
22:30
== ★Azria joined #main
20:40
== 🌞kyledove joined #main
17:46
== Rolyataylor2 quit
17:02
Rolyataylor2SELECT first.* FROM first_table first LEFT JOIN second_table second ON first.id = second.id WHERE second.id IS NOT NULL
Rolyataylor2I guess this
16:53
Rolyataylor2I really dont want to do multiple queries, I was thinking of using JOIN + UNION in the mysql to pull the name during the same query
Rolyataylor2or like: PlayerItem( typeofitem:INT ) ItemDefinitions( typeofitem:INT, nameofitem:'potion' )
16:51
αJextoh my!
αJexthaha
16:50
Rolyataylor2The problem im having right now is for database items I store the value of things as a INT like type=2 rather then a VARCHAR. The only solution i can find is to load a table that has the conversions in it to use for the search.... blah
16:47
αJexti see :)
Rolyataylor2its not for any perticular reason just to brush up on programming skills
Rolyataylor2or type:fire brings up moves and pokemon with type:fire
16:46
Rolyataylor2example searching for rol brings up user:rolyataylor2 and move:rollout
Rolyataylor2like search all databases and display a badge representing each row.
16:45
αJextor within a database?
αJextto search for different databases?
αJextoh yeah?
16:44
Rolyataylor2I have been programming a bit as well. I am making a database search page right now
16:43
αJext:wink:
16:42
αJextamazing!
Rolyataylor2Thats good. How is progress on your project going?
16:41
αJextgreat!
Rolyataylor2Mighty fine day so far. How is yours going?
16:40
16:21
15:43
== Rolyataylor2 joined #main
15:40
== Rolyataylor2 quit
14:05
05:01
== Arthzalcotl quit
04:21
== Arthzalcotl joined #main