11Tami

OK I've got this to try to delete a field from the table named add. Whatever field is entered into the form is the data row to be deleted. I'm getting this error on the page when the page first loads, before anything is even entered in the form. Anyone know why? Thanks. Error with queryNot unique table/alias: 'data'

What do you mean please Andy? Thanks.

Thats a great idea, we'd also like to know if there is a way we can stop the rows from being added at the database itself. Anyone know? Thanks.

Hello, right now for a site I'm working on people are entering their software in our database faster than we can put them on our pages. Is there a way we can put a limit on how many rows the database will take? That way when we get caught up we can open it back up again? If we do will it keep the form from sending for those that want to add more? Need good advice on this, nightmare land. Thanks.

Thanks a lot. Yes thats where I would like to learn how to do it. I have tried to back up the database before. I exported it as a sql file. Then I tried to upload it to a brand new database just to make sure it would import back again but it wouldn't work. So I still don't know the proper way to export yet. Any good tips on the proper way to export? Thanks.

Fantastic I'm glad there's a way. I've heard about entering queries manually before and I've looked at the guide but need some advice. It sounds like there is a way to enter in a command to the database when youre at the database. So it can be entered there and not from a php form that you make. Where are these codes entered there? At the database? Please get back to me, thanks.

Hello, for mysql on the server. Is there an easy or another way to delete rows? Right now I'm checkmarking the row I want to delete and then clicking on the red x for each one. It takes absolutely forever. Is there a better way? Please let me know, thank you very much.

You should be able to tell I don't know what I'm doing. You mean the statement on the page? Or do I insert it at the database? Thanks.

Ok thanks, where do I put your code?

What I mean is, are you saying there is no button in the database itself anywhere? A button that you can push that says "sort by" like other databases have? I don't know what your code means or what to do with it.

Thanks, so you can't sort the fields? You can only pull them out of the database alphabetically?

Thanks, first there is the whole database, then the tables. Then all the fields in each table. The fields in the table is what I need sorted. So right now I have many fields in one table. The first field is listed as "name." With other fields after it. When I click on browse to look at all the rows that have been entered, the rows are not listed alphabetically. Instead they are listed by which row was entered first and last. Another way to explain it. There are forms on the web pages. Each person comes along and enters their information. It is sent to the database. Each entry for each person appears as a row in the fields. So I have all these rows being added. But they are being with the last one being added at the end. Instead of alphabetical by what their name is. Fields, first field is name [name] [information] Rows [Tami] [Tamisinfo] [grey] [betty] [bettyinfo] [blue] I'd like it to be alphabetical by name, so that Betty would come before Tami. Not Betty last just because she entered her stuff in after Tami. Either sorted alphatically automatically when they are added. Or sorted when I come along later and hit a button to sort everything. Hope someone knows a way. Thank you very much.

Hello, is there a way to make mysql server sort its fields? Like if I wanted the fields to appear by alphabet of the name instead of just which one was entered first. Please let me know if you can sort these fields, I looked everywhere can't see how to do it, yet other databases can sort. Please let me know, thank you very much.

Good deal, I'll try it thanks!

Hello, am I the only one having a hard time tracking these posts. You'll ask a question and then bookmark it. Then to come back to see if there are any responses you can't use the bookmarks because all it shows is the newest posts instead. Is there any way to keep track of our own posts? Without copying and pasting the url? Anyone please let me know how it works for you, thank you very much.

Hello, I'm trying to follow the example on W3 schools page found here: http://www.w3schools.com/php/func_ftp_fput.asp So I put my own web address under ftp_connect, then put my own admin name and password under ftp_login. Then I uploaded a text file called source.txt to the root with a tiny bit of text in it and uploaded target.txt to the root with no text in it. Then I tried to run the .php page with this code in it. <?php $source = fopen("source.txt","r");$conn = ftp_connect("ftp.myownwebsite.com") or die("Could not connect"); ftp_login($conn,"myownadminname","myownpassword");echo ftp_fput($conn,"target.txt",$source,FTP_ASCII);ftp_close($conn); ?> I just get an error saying it can't connect due to an error on line 4. Can someone please help? Thanks you very much.

Hello, is there a way to get around the browser continually acting like they are loading when using sleep()? It says the page is still loading but it really isn't because we are causing a delay for some data on purpose with php. So it is for an intentional reason that we cause it. Many of us like using sleep(). Anyway to do it without the browsers showing the page is still loading? There must be a way, so many programmers for intense programming use sleep(), I can't imagine they have to deal with the browsers loading prompts whenever they do. Please let me know if you have the answer from real research of your own on this, not just to tell me no as a guess, thanks.

Thanks a lot everyone, that should help. Helps me find a way to give the variables that so many codes want so bad.

I'm getting hung up on a few things because everytime I turn around the php wants me to use a variable $. I guess this is what I need. How would I do that? How would I return value from separate function and then store it in $t variable? function a(){ echo "this is a"; } a(); How to get a() to $t?

Hello, can you put a function on a variabe in php? Such as: $t = function a(){} Do something with $t? Please let me know, thanks.

Why can't it replace the first entry when the page loads again to add the second?

Hello, I need some php or advice to help me replace the first entry with the second. For instance with this it just adds the second one onto the first one. I need it to move the second position date into the first position. Any ideas? I tried several things but think I was moving in the wrong direction. Thanks <?php // Current time echo date('h:i:s') . "\n"; // wait for 2 seconds usleep(2000000); // back! echo date('h:i:s') . "\n"; ?>

Thanks, that won't work. I just need part of a page refreshed, I don't need to pull anything from the server using javascript.

Is there any way the server can read part of the page with php in it, without doing a full refresh? Please let me know, thank you very much.

Thanks wild teen, it helps when someone explains why it is done a certain way. Then I can remember it better and understand it.