Why isnt sql showing the table row?

You should find out if your phpMyAdmin settings are setup correctly and are connecting to the right database, whether you're looking at the right table, etc. You haven't provided a lot of information to articulate towards your issue specifically.

Up vote -2 down vote favorite share g+ share fb share tw.

I clearly made an account on register. Php then when I test the code in the SQL section I get Showing rows 0 - 0 (1 total, Query took 0.0010 sec). Even though there is an account its returning that there is none.

Here is the code: php sql row link|improve this question edited Dec 27 '11 at 23:41DaveRandom18.5k2727 asked Dec 27 '11 at 23:34Isaac Nakash162 60% accept rate.

You should find out if your phpMyAdmin settings are setup correctly and are connecting to the right database, whether you're looking at the right table, etc. You haven't provided a lot of information to articulate towards your issue specifically. Also, you are using a SELECT statement in the code you have posted, which will return results from the database table. You should be using the INSERT statement in SQL to insert new rows into your database.

If you are looking for some help for a registration or login script, here is a good example to work with that I wrote a while ago: gist.github.com/1099006.

1 This is a login page, not a register one. – ypercube Dec 27 '11 at 23:43 He named the file 'register. Php', but either way I'm very confused.

– zzatkin Dec 27 '11 at 23:47.

Your script does not insert anything which is quite confusing though you say you have records so perhaps as shomz said check that your criteria matched when escaped but also shouldn't this: $sql = "SELECT * FROM $database1 WHERE username='$myusername' AND password='$mypassword';" be more like: $sql = "SELECT * FROM " . $database1 . "WHERE username='" .

$myusername . "' AND password='" . $mypassword .

"';" Edit: Given the comments/new code I had a fiddle with it and basically gave it a small tidy up my r. Php file '; } // test entry end? > my html file test-php Name: Password: Email: I'm using a default recent WAMP install, it may be worrth while that you get xdebug which I think has come setup as default with the WAMP version and making sure error checking is strict etc.

Sorry guys heres the correct code for register. Php codepad.org/xEVfeDne – Isaac Nakash Dec 28 '11 at 0:17 Are you sure your data is being posted from the form and actually calling the php? – Tom Ingram Dec 28 '11 at 1:58.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.