Formatting mysql data

sinoed

Hi, I'm new to php and hoping that you can help. I've managed to work out how to query the db, insert & delete records etc. but I'd like to be able to display the data in a better format. How can I import information into an HTML form? Can I have a 'confirmation' button (when deleting records) without involving javascript? thank you!

Anon

Yes, sure it's possible.
Just fill a table using the count_rows to determine which format you need.

For the button you do not need javascript, just make a form and only proceed when submit is hit

sgbalsekar

hi,

you cud also do the formatting in PHP...try sprintf function to format data being printed...

reg other query, cud u elaborate ??

regs,
sgb

Anon

Thanks, I think I'm starting to get the hang of the formatting end of it. 🙂

It is possible to pass variables across multiple scripts? What I was trying was to get the variable for the record number entered in one, passed through to the next page with a warning message before deletion & then after the 'submit' button is pressed the next script actually deletes it. There has got to be a better way though. 😛

I saw a script on here within the articles section, the 'building next/prev buttons' one that used a link something like this:

"$PHP_SELF?..."

(I'd post what it is actually supposed to look like but I'm getting 'error 28 from table handler from that section!').

How can a write a link to target certain sections of a php script? If I could do that I could combine the last two scripts into one that just uses the right sections.

gerdt

I am not sure if you use a form but looking at the PHP_SELF I guess you do.
You can enter hidden fields in the form and use their values to select the function you want to use.
You can pass the variables to several scripts using cookies (setcookie()) although that\'s not the safest way if the info is very confidential.
More about cookies at www.php.net at the documentation section
good luck