nadeemshafi9

i can sort of see how that could work but would it perform a fetch array on each table automaticaly? what im trying to do is read the info in each table and create html interfaces using fopen(file, W), a auto page generate

hi is there a way of performing a foreach(table as i){} on tables in a mysql db using php if so i cant locate the code plz hlp. thanks alot nadeem

i had this problem whith $php_self not working aswell like it should and i ended up changing it to the page self name aswell and it worked i wonder why ???

hi guys has anyone used some free xml feed to fill address details in whith the users postcode, is there any free ways to do this. is there any other way of doing this that you can recomend. Thanx for any help Nadeem

i created the pmadb and relations table and bookmark table using the dump schemas in the documentation and specified the relations and bookmarks tables and the pmadb in the \wwwroot\phpMyAdmin\config.ini.php i now have the interface for making relations in phpMyAdmin, i am gona try making some later and il post back. thanks m8'sss

basicaly i have installed mysql server i know how to do most things but never made relationships fk innodb ect, i havent installed anything to do with innodb i am confused about innodb maybe u could talk alittle about were i can activate it or install it, phpmyadmin works fine i can do everything except make relations, phpmyadmin has a small message in each page saying, [quote]The additional Features for working with linked Tables have been deactivated[/quote] [quote]PMA Database ... not OK[ Documentation ] General relation features Disabled [/quote] so how do i activate basic relations ? what is PMA database ? what file is it ? am i headed in the rright direction to start making links ? thx for any feedback

:) hi all i am about to recreate a big relational database in mysql, i hav been told about innodb, i started creating the tables in phpMyAdmin, everythings fine but theres no options for creating relations, it also says a small error, [code]Error The additional Features for working with linked Tables have been deactivated. To find out why click here. [/code] i click there and then it says [code]PMA Database ... not OK[ Documentation ] General relation features Disabled [/code] the documentation link takes me here [code]$cfg['Servers'][$i]['pmadb'] string Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below. See the Quick Install section in this document for a quick way of creating those tables. Also, if you are using a Windows server, read FAQ 1.23. If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. If you are setting up a multi-user phpMyAdmin installation, you will need to create a new database and setup special privileges, so, as superuser: create a new database for phpMyAdmin:   CREATE DATABASE phpmyadmin; Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):   GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost'; do not give any other user rights on this database. enter the database name in $cfg['Servers'][$i]['pmadb'] [/code] i just need to get it sorted to start making relations i do understand the documentation but before i do anything can somone give me some advice please, like what would u do, i am confused by the flatness of the interface of mysql lol. Thanx alot guys

ok guys i sorted it, i created a new mysql user using phpmyadmin, then i changed the config.ini.php password and that, thanx alot though for any vews. RESOLVED

Hi guys Somtimes i install Mysql to test my software, i use PHPmyadmin with it, i set a password and username in the my.ini file but phpmyadmin keeps telling me that the Mysql server is running on the root login, everything works fine but obviously its insecure, the err is > [code]The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file! Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.[/code] can somone give us a pointer plz thx. thanx v much for the help

thanks, very helpfull, issue RESOLVED

hi guys i just put some code anotation in to a page and my html template has a graphic in a div layer at the bottom right wen i scroll down the layer stays there how do i use lavascript to keep it at the bottom right wen the user scrolls down the page. Thanks for any help guys.

hi guys I am a student and iv been using MS SQL to put data in to simple table feilds i am using Visual Web Developer. the problem is i hav been given the task for my final project to recreate a huge hospital access relational database in MS SQL and add an intranet interface using asp.net. My problem is that i cant seem to see which datatype actualy is the equivalent of autonuber eg for id's ect, do i need to generate these, unique identifier dosent automaticaly enter a number. can somone please help me, thanks alot for any help. Nadeem

hi guys I am a student and iv been using mysql to put data in to simple table feilds such as images and text i hav used dump files and phpmyadmin. the problem is i hav been given the task for my final project to recreate a huge hospital access relational database in mysql and add an intranet interface using php. My problem is that i cant seem to see how relations are made in mysql and which datatype actualy is the equivalent of autonuber eg for id's ect, do i need to generate these, unique identifier dosent automaticaly enter a number. can somone please help me, thanks alot for any help. Nadeem

ignore wot i said up there i didnt know what i was talking about then, i do now, sorry, thanx anyway.

Hi guys im migrating an Access DB to SQL server, i cant figure out if i can export it somhow which would be amazing. My problem is that my Access DB has very complex relations and i need to recreate them in an SQL DB, in Access i had Autonumber, is this like Uniqueidentifier, and what counteerpart can i giv it on the other end of the relation 1:m (in the many part). Can you maybe point me towards some help or tell me what the equivelent of Autonumber is in SQL and what i should use for feilds like address and phone number because there is such a huge choice but some are very similar and its hard to make a choice. Im using Visual Web Developer, is there an easier way of seeing the relations because its a bit basic. iv been joining them together one by one in table design in Vis Web Dev. Thanks for any help.

schema [b]owner[/b]{ pk ono fname lname adress } [b]property_for_rent[/b]{ pk pno fk ono adress } hi guys here are some tables, the owners own more than one property each SELECT fname&" "&lname&", "&address AS [owner], pno FROM property_for_rent p, owner o WHERE p.ono = o.ono the prob is i get seperated records for each property owned by a single guy, i need to show his or her details once and then followed by the pno (property number)'s they hav. let me giv u a visual of what i am getting with the above code owner 1 pno owner 1 pno owner 1 pno owner 2 pno owner 3 pno owner 3 pno owner 3 pno let me giv u a visual of what i whant [b]owner 1[/b] pno pno pno [b]owner 2[/b] pno [b]owner 3[/b] pno pno pno i know you can count things this way using GROUP BY and COUNT(*) so u must be able to show them this way. thanks alot for any help.

nadeemshafi9@yahoo.co.uk hey ken im sorry woopie i got it it was put in to junk just know, hay man thanx alot both you guys for your help, !!il be back!!

hi again guys thanks for the response i was hoping that what you said would resolve it , but the way most of these things go, it whants more. ok whats happiening is still the same its not getting sent and its not bouncing, so i think its not getting off the server at all, please take a look at my phpinfo() [a href=\"http://diceconsulting.com/phpinfo.php\" target=\"_blank\"]http://diceconsulting.com/phpinfo.php[/a] i found 2 peices relating to the mail the path to sendmail and from. they havent given me ssh access so i cant ssh to the server. i thiink we are getting close, its not the latest php its v4 im used to v5 oop, but still mail is the same on both and id prob hav same prob on both 4 and 5. thanx again for any help

hi guys i have read the php.net/mail() notes i am having trouble figuring out why my program says successfull and mail() returns true yet the email is not sent. i know you need access to the sendmail binary, but how do i do this and how do i check if it is done. im on easyspace starter pack server, its linux whith apachie and php. hers my code [code] <?php     if(mail("nadeemshafi9@hotmail.com", "hi", "hello", "info@DICECONSULTING.com"))     {         print "successfull";         }     else     {         print "ERROR - not sent";     }      ?> [/code] thanks all for any sugestions.

Thanks, that works perfect, what i am trying to do is study for my first SQL test in 2 months time, now i can analyse and remember how that quesry was put together, i think i need to read up on GROUP BY. Thanks mb81

sorry i am an old member but now you hav the email notification thing i stopped and ticked that and it got double posted, very sorry wont happen again, plus i had to re register because my old user account had been lost due to ur update, but i like the new fetures.

Hi guys, i am looking for a way using sql whith a subquery to count the amount of properties(pno) each staff member (sno) looks after using 1 table. here is the schema for the 1 table im talkin about. property_for_rent (pno, street, area, city, pcode, type, rooms, ono, sno, bno) PK pno FK sno FK bno FK ono so i would like to dispplay the sno (sttaff number) along whith the amount (count) of pno (property numbers) that particular staff is repeated in. i uunderstand count and subqueries, but just cant seem to crack this one. THANKS FOR NE HELP