The following assumes you've already selected the database and that $column contains
the name of the new column and $defaultvalue is the value to be set.
$query = "ALTER TABLE Prices ADD $column DEFAULT \"$defaultvalue\"";
mysql_query($query) or die("Can't add column to Prices");
$query = "UPDA
f.com
Lead Programmer - Data Admin and Data Lib
http://dadmin.sourceforge.net
-
- Original Message -----
From: "ME" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, Ma
there is a page that when user go to need to be looged in,so it automaticaly go back
with him to loggin page but after login i want him to go back to the page he was
in.how?
using history()? and how.
thanks guys
Rehab M.Shouman
i have an input field in a form that accept date called $date and in databse i made it
of type $date so its defualt is -00-00
the problem is when i say:
if($date!="-00-00")
{do something}
he doesn't understand $date!="-00-00"
Rehab M.Shouman
-
i have 3 drop down menues the first 2 are statics and third i want it to retrive
from databse can i do this with javascript and php or i have to reload page 3 times???
Rehab M.Shouman
--
Rehab M.Shouman
-
Express yourself with a super cool email address from BigMailBox.com.
Hundreds of ch
i have this
Antiques & Arts
then i pass this to next page:
i have:
$nowdate=date("Y-m-d");
and i want to increase it by 6 months,how can i do that??
Rehab M.Shouman
---
i want an sql statment that select from table where prefer has the word auction or cash
i tried:
$sql="select * from products where prefer like '%cash%' ";
and it worked biut i tried:
$sql="select * from products where prefer like '%cash%' or prefer like '%auction%' ";
but didn't work !!!
i have sell.php page which requires loggin so i put in it:
http://$HTTP_HOST/auction/login.php";);
exit();
}
?>
then in login.php i have;
$sql = "SELECT * FROM registration WHERE username = '$username' and
password='$password'";
$result = mysql_query($sql,$conn);
if(@mysql_num_rows(
c=document.forms[0].category.options[document.forms[0].category.selectedIndex].text
but the php doesn't understand this c variable
Rehab M.Shouman
---
i know it has nothing to do with php but i'm stuck:)
i have this url:
http://localhost/auction/seller/additems.php?category=Books&subcategory=Fiction
and in javascript when i say for example alert(category) it gives me
undefineddoesn't javascript see variables passe
ls in database.
does anyone have something like this that can help me??
i tried in my script that whenever an item is added i send aletter to all who is
subscribed under this category,but i need to know the ID of this item that is added
first,so i faild to do that
Rehab M.Sh
ls in database.
does anyone have something like this that can help me??
i tried in my script that whenever an item is added i send aletter to all who is
subscribed under this category,but i need to know the ID of this item that is added
first,so i faild to do that
Rehab M.Sh
i have the file:
edit_profile.php
in it i have a form field like this:
Choose City 10-Ramadan 15 May 6-October Abou Redes Abou-Zabal Al Arish Al Mahala Al Tour Al-Natroun Alexandria Asuit Aswan Bader Bani-Sweif Belbis Berkeit sabb Cairo Dahab Damanhour Disouk Dumiat Ein Soukhna El
i get $postdate from my mysql database,the problem is that i want to increase that
date by 6 months??
its stored in mysql as date field
i have asimple problem:
can i put php code in the site template??-i'm using dreamweaver.
and if yes will i save it as php or as .dwt??
thanks guys
Rehab M.Shouman
maybe this is more a javescripy problem...but its related to my php code:
how can i open a new window with javacript and pass to it php variables??
thanks guys alot.
Rehab M.Shouman
what do i need to change in my MySql databse when i upload it to server to work
correctly
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [
Are u using phpmyadmin to create your database?
or u do it from command prompt ,and do i have a databse driver so my database works
when i upload it to server?
--
PHP Da
i want to access the file: test.php and its located in cgi-bin folder.
and my form file is :form.html and its in htdocs folder.
how can i access test.php?
i tried: method=" ../cgi-bin/test.php"
i didn't use a driver just inserted data directly throw phpmyadmin.
do i need a driver?if yes from where can i get it?
--
PHP Database Mailing List (http://www.php.net/)
T
do i need to write thr Grant statement to allow users to a
have access to database(mysql)?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EM
here is my folders tree:
(i'm on windows)
c:/apache/cgi-bin/test.php
c:/apache/htdocs/click.html
i want to call test.php from click.html.
what is the syntax?
is it something like: ../cgi-bin/test.php?
---
i was told to upload my database to server,i do it in access
and then extract it and do so i need ODBC driver for MySql.
is that true?did anyone tried this befor..and is there any other way?
if anyone used it..from where can i get the driver?
here is my code,u only have to care for the session part:
this is the login page:
http://$HTTP_HOST/mall/menu.php";);
exit();
}
else
{
echo "Sorry,you entered either a wrong User Name or Password.Try
again";
echo "Back";
}
else:
?>
Login Page
User Name
Passwo
Cannot send session cache limiter - headers already sent (output started at
C:\apache\htdocs\mall\menu.php:9) in C:\apache\htdocs\mall\menu.php on line 10
this message appear when i make session_start() on a page??
http://$HTTP_HOST/mall/menu.php";);
?>
i wanna make this my log out page.
it works without the:
header("location:http://$HTTP_HOST/mall/menu.php";);
i tried to put it befor session_destroy()
but still didn't work???
---
i wanna limit the result for 10 records per page.
if anyone have a script doing this.
if i said for example limit 0,10
how in next page i'll get next ten?
--
PHP Data
Fatal error: Failed opening required 'connect.php'
(include_path='.:/usr/local/lib/php') in
/home/sites/site92/web/mall/confirmregistration.php on line 3
and
Fatal error: Failed opening required 'connect.php' (include_path='') in
/home/sites/site92/web/mall/confirmregistration.php on line 3
where i can find info abour .htaccess and .htpasswd
files and what should be the code inside them
its urgent please guys
--
PHP Database Mailing List (http://www.php.n
Warning: MySQL Connection Failed: Access denied for user: 'rehab@localhost' (Using
password: YES) in /home/sites/site92/web/mall/confirmregistration.php on line 14
Error connecting to host localhost, by user rehab
should i use this:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON
i want the user to upload files to server
when i worked offline i used to write:
$updir = "C:\apache\htdocs\mall\logos";
as logos folder is where i put the files(logos)
all my files is in a folder called mall and inside the mall folder
there is the logos folder.
what should be the equivilant of
i wanna include auto_prepend_file in .htaccess
how can i write the path to file ???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTE
line..but in my php file!!i don't know.
my host created the databse for me and gave me a username and password i used them in
my scripts...do i still have to use GRANT???
--
does anyone know the max number of tables the mysql can support
and still work efficient???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMA
i made in form list menu with multiple select:
Envelopes
transparencies
greeting cards
labels
plain paper
iron-on transfers
photo paper
banners
glossy coated paper
glossy photo paper
glos
hi there.does anyone know how to pass a variable value to the new window i opened
with open() of javascript?
--
PHP Database Mailing List (http://www.php.net/)
To uns
hi there, i have a similar problem which is driving me crazy and i hope u can help
with:
i have a form whith a normal button when clicked ,i open a new window through
javascript(this window have a php script)
which i wanna pass to it a form field:
but as i told u there is no submission for
is there a way i can upload more than one file in the same page
-ofcourse in 2 different form fields-???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
This should work as well (newer syntax) ?:
SELECT F.question, F.answer
FROMFaqsAS F
LEFT JOIN FaqsRelatedToProducts AS FP ON F.faqid = FP.faqid
WHERE fgnumber = '$yourfgnumber'
Use:
SELECT DISTINCT ...
when your FaqsRelatedToProducts t
Hi list,
I am trying to develop a product catalog using MySQL and PhP.
A long time I was looking for some tips for the database
structure.
The idea is to have a powerfull and as much as possible
universal DB application.
Does anyone have an idea of a book, e-book, site, resource please ?
Th
12:19
To: Hynek Semecký ME; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Catalog
lots of excellent resources on www.devshed.com, notably a PHPShop tutorial
and a catalogue implementation.
Ignatius
- Original Message -
From: "Hynek Semecký ME&quo
Hynek Semecký ME'; Ignatius Reilly; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Catalog
jou want to make it yourself even without nowing how to code it or how to
set up a database design???
just by looking to other code??
think it will be to hard for a first project.. just my idea...
kind rega
Prev 10 lines
Has anyone got some code that will correctly display the next 10 line of a
table with prev and next working?
Or point me in the right direction for help?
Regards
Steve Dodkins
IMPORTANT NOTICE The information in this e-mail is confidential and should
only be read by those persons
Marcel <[EMAIL PROTECTED]> wrote:
Can you clarify? Possibly show how the result should look in the page after
parsing. I'm sure I can help but your question is a bit unclear.
> I want to pass some variables named a1, a2...aX in a form. So I wrote a
> couple of lines to do the trick:
> for($i=1;
at always bugs
> me - using heredoc syntax in a function. Code in the function really should
> be indented (or 4 spaces for PEAR types), but, to quote the documentation,
> "the closing identifier must begin in the first column of the line." That
> means no tabs, right? So is tha
Unknown Sender <[EMAIL PROTECTED]> wrote:
As mentioned in another reply, in MySQL all fields can have quotes regardelss of
type. If you really need to tell, use this:
if(!is_numeric($value)) {
$value = "'" . $value . "'";
}
> I guess this is mostly a MySQL question, but perhaps PHP has a sol
ore by giving an example with 2 variables.
> $q1 = "first_var";
> $q2 = "second_var";
> for($i=1;$i<=2;$i++)
> {
>echo "\n";
> }
> The output should now be:
>
>
> Hope you can help me,
> Marcel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
SELECT COUNT(*) FROM (only on initial page).
Then pass that count from page to page. Then only one query will be necessary
for subsequent page requests.
The count will not always be accurate if records are added during the users
visit. But it's a quicker solution.
David Chamberlin <[EMAIL PRO
Use Content-Type: application/octet-stream
Gary Every <[EMAIL PROTECTED]> wrote:
> Header("Content-type: text/plain");
> Header("Content-Disposition: attachment; filename=topsellers_dvd.csv");
> Gary Every
> Sr. UNIX Administrator
> Ingram Entertainment
> (615) 287-4876
> "Pay It Forward"
> mai
http://www.php.net/array_multisort is your answer.
Mark Snijders <[EMAIL PROTECTED]> wrote:
> hello,
> i've got the next array:
> Array
> (
> [testsubnet] => Array
> (
> [2690910720] => 255.255.255.0
> )
> [GLN-subnetsirangevoorgedelegeerddomein] => Array
>
Do NOT store images in a DB, the overhead kills performance. If it's a tiny app
with very little traffic, the fine. Otherwise, store images in the filesystem.
[EMAIL PROTECTED] wrote:
> Hi everybody,
> i want to store some articles and images to them in MySQL
> db. could you just give ad
53 matches
Mail list logo