Webmaster Forum / PHP / Database Access / July 2004

I am building a db, using mysql and php. Having called values from a
table I reproducing them in a drop down listbox on a web interface
using php. Once the user selects a value from the drop down list, i
want to select a cost from another table based on that selection. Here

I need to do file uploads from a web form for both images, and .mp3.
How do i force the file upload for a give field to be of an appropriet type?
For example if i only want:
".jpeg, .jpg, .gif, .png" for image types?

can anybody tell me what is happening with phptriad. I dont find new
versions coming up. PHP 5 has come.
Thanks
Jaunty

Is there a 'ALTER TABLE' command to rename a field like
ALTER TABLE foo RENAME oldfieldname [TO] newfieldname;
???
Looked in the mysql-manual online and didn't find what i wanted. I seem to

What's the maximum number of fields able to be used in a MySQL table
these days?
This worked:
CREATE TEMPORARY TABLE TempTable (

What is the safest way of encoding strings in the database to preserve special
characters? Is it best to use addslashes or base64_encode or both (or something
else?)
thanks

i would like to know something.
I am using FULLTEXT to search product within my PRODUCT table using
keywords.
Suppose I have this:

I have  list of titles in a database, many of which begin with "the..."
Is there an sql statement to move the "the" from the beginning of the column
and place it at the end
eg "The Big Blue House" would become  "Big Blue House, The"

This is sql related, rather than anything PHP specific, hope that doesn't annoy....
I'm making a database schema that includes the problem of representing objects
that consist of labels (or keys) and associated values.
For instance, in a straightfoward descriptive way, suppose I ...

Can someone give me some php code that will move or copy a binary file from
a folder on the server to a blob column on a mysql database table.

perhaps I am just a little tired, but I am having trouble with my form
buttons.
Firstly I name them like this
name=\"round".$counter."heats\"

I can't seem to create variable variables properly. Here is my code (with
some testing stuff in it -- the 'echo's):
while ($row = pg_fetch_array($revenue_by_staff)) {
   $varname = '$revenue_'.$row["dat_staff_code"];

There is 2 table "users" and "on_standby_users", these both table
have got a column "login". I must check before insert a new line that
a new user don't try to create itself with existing login:
SELECT * FROM users,on_standby_users WHERE users.login='toto' OR

Please take a look at following very simple script;
#!/usr/bin/php -q
<?
echo "Hello, world!\n";

I am trying to understand more about the types of indexes on tables.
This is my current understanding:
plain old index - allows more direct (hence faster access) to rows when you use
this key. allowed to be null, and can have duplicates.