Page 2 of 2
Posted: Thu May 10, 2007 10:32 am
by influenceuk
i wasjust using PHPmyAdmin.
But after looking around on Hotscripts i now have navicat. I have sorted out the date bit, its just the yes no bit now.
its still saying 0 for no and -1 for yes. Any ideas hows to change this?
Posted: Thu May 10, 2007 10:42 am
by RobertGonzalez
Run this query and post the resulting output (substitute your actual table for my_table_name).
Code: Select all
SHOW CREATE TABLE `my_table_name`;
Posted: Thu May 10, 2007 10:45 am
by influenceuk
guys! i worked it out!!!!
Using Navicat i have done what i been trying to do!
Thank you for the help. I feel like such a fool when i could of just used this piece of software
Basically using the Navicat software i was able to creat a new table, from this i worked out what was needed, my god using the GUI is so much easier
for the yes/no issue i needed to make the type enum and the values set as yes and no

Posted: Thu May 10, 2007 11:08 am
by RobertGonzalez
That can be done with phpMyAdmin as well. I only bring this up because Navicat is like $100 USD for a license, where as phpMyAdmin is free. SQLYog is a bit better priced (it is the tool I use) and usually goes for about $40 per license.
Posted: Thu May 10, 2007 11:15 am
by influenceuk
Yeah i see now i think seeig it with the navicat GUI has made things a lil clearer, even just using the trial version.
I feel a lil more confident now using it.
Now i have the fun task of learning how to display the data onto a webpage and format it how i want
mmm time to surf the net and find a good place to find out how to format the tables, i did try basic HTML when getting PHP to format it, alas it errored though.
But you guys have been a great help
