[PHP-DB] Database Function

I have a simple php script that searchs a MySQL database and returns results that I made myself and I'm trying to implement code that splits the results into x amount of pages, buts it really tricky. Can anyone give me a link to some code or even better, a search database script that I could

[PHP-DB] Random Selecting from mySQL

a way round this? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Ireland's Online Film Production Directory *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Random Selecting from mySQL

-- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Random Selecting from mySQL I know how to use the ORDER BY rand() command on the end of queries to randomize selection, but that's no good when

[PHP-DB] Temporary MySQL Tables

Hi, On my site now, there's a lengthy register process where the user has to fill in 5 forms, one after the another. I get the PHP script to echo the values from the previous into the next form by using ?php echo input type=\hidden\ name=\name\ value=\ . $name . \; ? for example. Then I keep

[PHP-DB] Simulating a FORM POST thing (HELP!)

Rite, when you see a web form, you know you can simulate the submit by filling in the values in the address field, just like a GET method, and it usually works the exact same. But how do you do it when one of the fields in the form is a file upload?!?!?! For the record, its a GIF file you've to

[PHP-DB] Unique SQL query?????????????

-- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Emulating HTTP File Uploads

Does anyone know how to upload a file through PHP through the HTT interface. I use fopen() to open remote php scripts using the GET method for non-file uploads but it doesnt work with HTTP POST or file uploads. Does anyone have any ideas? -- Regards, Georgie Casey [EMAIL PROTECTED

[PHP-DB] Searching...

know of? or does the 2 queries not mka emuch of a difference -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Hex Help Please...

Rite, There's a PHP script that takes a monochrome BMP and converts it into some sort of hex code and I've noticed some patterns with this code. This image is 72 pixels wide by 14 high so there's 1008 pixels. In the code returned, theres 252 chars, which is 1008 divided by 4. So I guessed the

[PHP-DB] Re: Hex Help Please...

OK, i thought I found my solution but... How come if I convert from 1000 from Binary to Hex in calculator, it returns 8, but when I use the PHP bin2hex function, it returns loads of 3s and 0s Georgie Casey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL P

[PHP-DB] another problem

well, i solved the last problem on my own but now i need help on my new one :-) how do you convert text to hexadecimal with PHP? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory

[PHP-DB] SQL order by queries

Can you d arithmetic division on two fields in an ORDER BY?? eg SELECT * FROM table_name ORDER BY field1 / field2 DESC Can it be done? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory

Re: [PHP-DB] Auto Increment Problems....

why, is this question asked a lot??? anywa, thanks, i was gonna try something like that from something i read in the mysql manual, but it only mentioned it passing and didnt give an example or anything. tanx Daniel Brunner [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

[PHP-DB] Auto Increment Problems....

rite, my primary key column (id) is set to auto_increment as usual which is very handy. But when I delete a row, the auto_increment just keeps incrementing and there's this 'hole' left where I deleted the row! Apart from this looking ugly, it poses another problem. In my PHP script where I can

[PHP-DB] ORDER BY from 2 tables

i assume this is a simple question... how can I SELECT * FROM 2 different tables in the same query, ORDER BYing the 'hits' column, which both tables have. eg, 2 tables i have are similiar and i want to merge them and then select everything ordering by hits -- PHP Database Mailing List

[PHP-DB] Re: Mail problem

maybe use a for loop and mail command. should work Unknown Sender [EMAIL PROTECTED] wrote in message 002701c23924$da9b1e40$539f4dd5@administrator">news:002701c23924$da9b1e40$539f4dd5@administrator... Sorry to be a little bit off topic. I need a tool or script in PHP, that will automaticaly send

[PHP-DB] MySQL queries

for some reason in my mysql selecct statements in my php pages, when i upload them to my web server, they just return a blank record set. no errors or anything, just blank. i can insert fine but no select. it works fine on my test win32 apache/mysql -- Regards, Georgie Casey [EMAIL PROTECTED

[PHP-DB] mySQL settings

do i change to allow me do this? -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] TOO MANY CONNECTIONS!!

Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I know I access the database a lot for each page. So whats the solution to this?? Write scripts that create static html pages that update every 20 minutes or so??