formatted code that php
doesn't even attempt to run. Check that each open , ', [, (, { has a
corresponding closing counterpart and each of your php statements (~lines)
are terminated with a semi-colon (;).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems
solution, like taking
the middle? I've already put some thought in it, but I see no reason to
reinvent the wheel again. Has anybody
any better ideas? I'm open to solutions.
If you're going to be running on some *nix platform then have a look at the
chapter on pspell.
--
Jason Wong - Gremlins
to create a linked list. The fields will hold the
previous and next records in the list
I'll leave you to work out the implementation details.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
a bundled GD library there may not be much incentive
for people write one.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
I wonder why the PHP/MySql interface doesn't simply return dates as
dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems
On Monday 31 March 2003 04:46, Benjamin Higgins wrote:
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql, is that sufficient to get MySQL 4 support?
Yes.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
On Saturday 29 March 2003 22:25, Dave Carrera wrote:
I have been trying to find a way to write Apache Log data to a MySql db
via a pipe log directive.
Search the archives, a solution was presented in the past few days.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source
, UPDATE, DELETE queries
3) If you want an associated array use mysql_fetch_assoc()
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search
webserver) then
leave it as 'localhost'. Otherwise do what I originally suggested and use an
upstream SMTP server (probably provided by your ISP).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
sadflkjaflkasdj;
}
1) Check that php.ini is correctly configured
2) Check the php error log
3) Check your mailserver log
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
in sending mail :)
If you're running on some Windows system you can try specifying the SMTP
server provided by your ISP. Otherwise google is your friend.
If you're running some *nix system then they usually come with the ubiquitous
sendmail.
--
Jason Wong - Gremlins Associates
know how to do that ??
If i did'nt explain right please let me know
You can have tar _extract_ an archive onto stdout. But I don't think you can
_create_ an archive and have it go to stdout. So you would _have_ to create a
temporary file and delete it when you're finished with it.
--
Jason
. but for the life of me I can't think straight right
now :-(
The easiest method is to stick them all into an array then implode them using
a comma as the delimiter.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet
.
}
$query = SELECT * FROM Rota WHERE date = $start and date = ($start +
INTERVAL 6 DAY) ;
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
$date = $row[Date];
Again, see above comments.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
that the email bounced email matches?
Search archives (php-general) for mail bounce or mailing list bounce or
similar.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
you're at it do a var_dump($tips) as
well.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
On Friday 07 March 2003 13:59, Ramesh PAtel wrote:
I am working on PHP and PostgreSQL.
I want to insert output of my Query in textfile.
so how to open file and insert data one by one in textfile.
fwrite(), see manual for details and example.
--
Jason Wong - Gremlins Associates
file which on server I can print using lp
filename. Similar thing but without any print dialogue box at the
client end.
Exactly, this is a client-side problem (Javascript, ActiveX/script, etc).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web
On Tuesday 18 February 2003 05:46, Andy wrote:
Hi There., I have a script that lists directorys then how many files are in
each. although it won't list in an A-Z format, would anyone know how i
would do this?
Read all the filenames into an array then use asort().
--
Jason Wong - Gremlins
near 'WHERE cat_id = 2 ' at line 4
Db : mysql
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
in the array named something the code will
print the key 0
PHP is doing automatic type conversion for you. Use:
if ($key === something { ... }
instead. See manual for details.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting
the space or has extremely high
turnover of deleted records, this makes sesne.
Better still, setup parallel tables and move deleted records over. That way
you'll save cluttering up the main tables.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web
.
-
The error is quite explicit: Syntax error in FROM clause
So unless the Jet Engine is lying or is buggy then you have an incorrectly
formed query.
can anyone help me?
Nobody can help you unless you post your query.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software
]);
$Array[id_num] = trim ($Array[id_num]);
$Array[Email] = trim ($Array[Email]);
Use
print_r($_POST)
to show all the values POSTed from your form.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet
products etc...
I'm trying to quicken my development cycle.
freshmeat.net and search for mysql forms
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
the question.
Real email clients gives you multiple response methods -- reply to sender;
reply to list; reply to all; bounce; redirect etc
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
On Thursday 13 February 2003 04:33, Zach Davis wrote:
However, I've noticed that if anything past the 8th character in the
password is irrelevant.
That is clearly explained in the manual.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web
you expect them to contain. And also you could consider using BETWEEN instead
of the less-than and greater-than comparisons.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
run a monitor while testing your code locally,
you'll be able to pinpoint precisely what causes the recources to be chewed
up.
There is something called mysqltop.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet
hp?email=.HTTP_POST_VARS[email].;
should be
$insertGoTo = booking_details.php?email=$HTTP_POST_VARS[email].;
For people wondering _why_ it works like a charm the correct statement
should in fact be:
$insertGoTo = booking_details.php?email=.$HTTP_POST_VARS[email].;
--
Jason Wong - Gremlins As
foreach database query.);
}
$event_date is an array with several dates separated by commas.
(2003-10-02, 2003-10-03). The code above successfuly inserts the first dae
in the array, but none of the others... am I missing something?
Any error messages? If so what does mysql_error() say?
--
Jason
is an array with several dates separated by commas.
(2003-10-02, 2003-10-03). The code above successfuly inserts the first
Could you explain what exactly $event_date contains? The output of
print_r($event_date) would suffice.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source
the values I want in the session through a query on
the previous script and call it directly to the function I want to use?
Please post your code.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
of the variable in another
php program. butit is not getting. one our friend told to put like
echo $_post(fname)
but it is also not working. now getting the error about post array.
so what to do.
manual A simple tutorial
manual Variables Variables from outside PHP
--
Jason Wong - Gremlins
)) {
$prod_search .= ,;
}
}
$prod_search .= );
Can anyone see where I am going wrong?
$doo = array('dah', 'dee', 'dib');
$doo = in (' . implode(', ', $doo) . ');
echo $doo;
--
Jason Wong - Gremlins Associates - www.gremlins.biz
with HTMLs (kind of template) and
by means of Php tags I can echo these variables where needed.
What exactly are you having problems with? What is your code so far?
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet
for Call to undefined function mysql_connect will
probably cover all the common cases.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
On Wednesday 05 February 2003 15:03, kumar wrote:
(B
(B I have created reservation table i need to store all the values in
(B database when i click the submit button
(B but it couldn`t working.
(B
(BCould you give a detailed description of HOW it isn't working?
(B
(BWhat did you
for the function in question to see
which configure option/switch you need to compile that function into PHP.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
that value i
did like:
?php
echo($fname);
?
where fname is the text box name of the previos page. but it is not coming.
what should i do.
help me..
Have you tried reading the manual? The chapter A simple tutorial?
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source
with 4.0.6 you really
should be using a newer version.
If you really do need 4.0.6 then check the archives on how to use the patch.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
on this project.
http://freshmeat.net search for mysql forms
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you
trying for hours. You
mentioned printing out Globals or something. I am relatively new to this,
so I don't really know how to do that. I would really appreciate more
help. Thanks.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design
That should be:
... name='CheckBox[$counter]' ...
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
1 1 was a race-horse, 2 2 was 1 2. When 1 1 1 1 race, 2 2 1 1 2.
*/
--
PHP
files then
things will fly
Remember HTTP uploads doesn't allow you to resume transfer. Thus if a file was
99% uploaded and an error occurs you have a very unhappy user ;-)
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting
someone else's code. There are plenty of classes
at www.phpclasses.org which builds and verifies forms for you. Also searching
freshmeat.net for mysql forms should be rewarding.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting
inspection so that
whatever port was used to initiate the connection with mysql should be
allowed through.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
We're all
of a button and
Submit Your Ad is it's value? As it is part of the form and you're
programmatically (or indiscriminately) extracting everything from $_POST (or
equivalent) then that is why you end up with it.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems
date
functions). If your date stuff will mostly be done in PHP then use unix
timestamps.
On the whole I would stick to a DBMS native date format because:
- it's human readable
- built-in date functions
- not limited to post epoch dates
--
Jason Wong - Gremlins Associates - www.gremlins.biz
the contents of
$formdata into your database. If that code is properly written then the
presence (or otherwise) of next_ should not affect its operation.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet
$formdata is empty?? If it is, where are you getting
$formdata from?
[snip]
$result = mysql_query($query)
or die (Couldn't execute query.);
Don't use die(), use:
$result = mysql_query($query)
or echo Couldn't execute query. . mysql_error();
--
Jason Wong - Gremlins Associates
. Considering all of the columns exist, I think the problem
just has to do with how I am pulling the array values out and placing them
into their column. Any help would be appreciated. Thanks in advance,
Please post your code and DB schema.
--
Jason Wong - Gremlins Associates
) {
do_insert_row;
}
while ($row = mysql_fetch_array($result)) {
insert_results($row);
}
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Joe's sister puts spaghetti
to do this. One is:
$date = explode('-', '10-01-2003');
$newdate = $date[2] . $date[0] . $date[1];
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
To err is humor
describe in more detail how your code doesn't behave the way you
expected it to behave?
So do you see anything at all?
What exactly does it do?
Error messages?
Have you checked the logs?
Have you tried echo() on the important variables to see what they contain?
--
Jason Wong - Gremlins
that smileys associated
with the same image are displayed on the same row.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
I'm not the person your mother warned you about... her
);
if ($result)
echo mail sent;
}
It always print mail sent, but I never got the email.
So I was wondering if Mail() request any send mail program to work.
Is it a windows server that you're using? SMTP only works for windows.
Anything else uses sendmail or equivalent.
--
Jason Wong
. Any more ideas?
Which probably means your $StopDate is 0. What does it actually contain? You
really should assign your query to some variable ($query) THEN plug it into
your query function. If and you have any problems you can echo $query to see
what you're passing to mysql.
--
Jason Wong
options in php.ini.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Don't SANFORIZE me!!
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
-- unclosed/unbalanced tags (/td, /tr,
/table).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
When the going gets tough, the tough go grab a beer.
*/
--
PHP Database Mailing
do the same for prob[] as well.
Having done that then in your example you should get something like:
$prob[0]: Problem one
$prob[1]: Problem two $level[1]: High
$prob[2]: Problem three$level[2]: Low
NB that $level[0] is undefined.
--
Jason Wong - Gremlins
a page. Has anyone seen this behavier before ?
Yes.
I've seen it before.
Loads of times.
It means your version of php was not compiled with mysql support, or the mysql
module was not found.
Try searching in the archives for an answer.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
new to databases then check out some php/database tutorials (there
are _plenty_ out there).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Our business is run on trust. We
is
a auto increment field, as is id... but it seems I need to know the value
of faqid to relate it correctly to the fgNumber...
The retrieve faqid use mysql_insert_id().
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet
). Also google MySQL vs PostgreSQL should be
helpful.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
It is better to wear out than to rust out.
*/
--
PHP Database Mailing
the archives, check the usual script sites
(www.hotscripts.com, www.zend.com, www.phpclasses.org etc) for timing
classes/functions/etc.
Everything runs
on my ISP's server.
That's not an issue.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
a syntax error. Is it not legal to do this?
The php-mysql interface does not support multiple queries.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
A handful of friends
.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Catch a wave and you're sitting on top of the world.
-- The Beach Boys
*/
--
PHP Database Mailing List (http
and values have to be different? When it is inserted into
the DB it shouldn't matter since the record would not be a duplicate.
manual FAQ PHP and HTML
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet
-general php-db), it's been
covered many times before.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
static buildup
*/
--
PHP Database Mailing List (http://www.php.net
mysql to allow remote connections
(checkout the GRANT command).
Also if you have a firewall between the two machines you would naturally have
to take that into account.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet
.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Life is like a tin of sardines. We're, all of us, looking for the key.
-- Beyond the Fringe
*/
--
PHP
writing file './nrlug/home.frm' (Errcode: 28)
This is obviously a mysql question. Go to their website and search on the
error message.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
On Friday 03 January 2003 17:11, conbud wrote:
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob
is cool, but doesn´t support a fieldcheck or events
after an insert.
There is also ImpAkt which supports all the features but it´s nich
OpenSource.
www.phpclasses.org
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting
to be created by the PHP machine (wild guess)
but it looks like this:
/var/tmp//phptkYxkV
Any ideas on how to get it to look like: filename.doc would be greatly
appreciated.
RTFM section on Handling file uploads, in your code print_r($_FILES).
--
Jason Wong - Gremlins Associates
jpgraph
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
The longest part of the journey is said to be the passing of the gate.
-- Marcus Terentius Varro
lang=whatever
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
When you die, you lose a very important part of your life.
-- Brooke Shields
*/
--
PHP
the archives.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Life is a concentration camp. You're stuck here and there's no way
out and you can only rage impotently against your
that you have closing braces on the last two IF
statements. Are you sure you're looking at the right file?
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Promise her anything
On Wednesday 25 December 2002 00:10, zeroked wrote:
Hi I am a newbie to PHP so please help
How do I add information into my mysql db?
I have a db called sitedb and I want to insert datat into my news table
inside my sitedb.
Merry Christmas. You forgot to say what the problem is.
--
Jason
application to link tables together.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
This ASEXUAL PIG really BOILS my BLOOD ... He's so ... so ... URGENT!!
*/
--
PHP Database
INTO inventory
(registration,type,total_time,price,description,picture_name)
VALUES
('{$_POST['registration']}','{$_POST['type']}',...);
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
and validate forms for you.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Qvid me anxivs svm?
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
other day (or so it seems).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Nihilism should commence with oneself.
*/
--
PHP Database Mailing List (http://www.php.net
4.2.3
MySql 3.23
IIS 5.0
My mind reading skills aren't very good, but I think there's something wrong
with line 13 of your program.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
If this is an all Redhat RPM installation then install the mysql-php*.rpm as
well.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
If you suspect a man, don't employ him.
*/
--
PHP
insert picture into mysql
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
It's not an optical illusion, it just looks like one.
-- Phil White
*/
--
PHP
, here are a couple of pointers:
1) Bypass the login page, hardcode the login details and see whether that gets
you logged in.
2) Use print_r() on your major variables in strategic places in your code to
see what's happening to them as they pass through your code.
--
Jason Wong - Gremlins
. I am
working off localhost on a WINXP machine. PHP 4.2.2.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Ain't that something what happened today. One of us got traded
the random table working.
[snip]
Anybody see the solution??
First we need to know _what_ the problem is. I think we can assume your code
doesn't work the way you expected. Can you tell us _how_ it doesn't work?
Error messages?
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source
. There's an example in the manual which shows you
how to use mysql_list_tables(). Get that working, _then_ adapt it to return
random tables.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications
you're not testing for it? You should
_always_ use something like:
mysql_query('...') or die(mysql_error());
Second, the reason why it fails is because you need commas between the items
in your SET clause:
UPDATE table SET col1 = 'val1', col2 = 'val2' ...
--
Jason Wong - Gremlins Associates
, $db_pass to see whether they contain what you think
they contain.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Persistence in one opinion has never been considered a merit
with the other
code but it still loads the form under
if (!$login_clients and !$register_clients){
If I use isset it does the same thing.
Quickest solution, stick a phpinfo() in the first line your code to see
exactly what is and isn't being set.
--
Jason Wong - Gremlins Associates
the choices provided in the while loop from the database. Please let
me know what you think.
Your table doesn't seem to be closed.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development
using PHPMyAdmin, minus the var of course, the table
is created.
When I run it in my code, nothing happens. I do a die($SQL) to see the
final outcome of the query and it's correct and is what I am using to
run the query in PHPMyAdmin.
mysql_error() to see what the problem is.
--
Jason Wong
on the form before they
edit it)
*change the prices after submission of the form into the mysql database
THANKS A LOT, it will really help
I bet it will ;-)
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet
.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
FORTUNE PROVIDES QUESTIONS FOR THE GREAT ANSWERS: #15
A: The Royal Canadian Mounted Police.
Q: What was the greatest
201 - 300 of 617 matches
Mail list logo