: Gary php-gene...@garydjones.name
To: php-general@lists.php.net php-general@lists.php.net
Date: Tuesday, November 16, 2010, 3:35:12 PM
Subject: [PHP] mysql help (sorry, a bit OT)
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid
-
From: Gary php-gene...@garydjones.name
Date: Tue, Nov 16, 2010 13:35
Subject: [PHP] mysql help (sorry, a bit OT)
To: php-general@lists.php.net
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
-Original Message-
From: Gary [mailto:php-gene...@garydjones.name]
Sent: Tuesday, November 16, 2010 5:35 AM
To: php-general@lists.php.net
Subject: [PHP] mysql help (sorry, a bit OT)
Is there a way to check the syntax of a query, short of running it? I've
got an
insert to do
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to change something in that but the I am not able to get the DB
flow..
Is any body knows any tool by which we can create/make the relationship
diagram like we
ganu ullu wrote:
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to change something in that but the I am not able to get the DB
flow..
Is any body knows any tool by which we can create/make the
Ask the open-source project for help. They will be able to answer your
questions better than we can.
On 2/25/06, ganu ullu [EMAIL PROTECTED] wrote:
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to
Hi,
Saturday, February 25, 2006, 5:53:23 AM, you wrote:
gu Hi all,
gu I installed a opensource php project, and now is working fine for me.
gu Now that project has some 40-50 MySQL tables..
gu now I want to change something in that but the I am not able to get the DB
gu flow..
gu Is any body
Curt Zirzow wrote:
* Thus wrote Chris Jernigan ([EMAIL PROTECTED]):
Hi everyone,
What's the problem? I have one week to do this. Oh, and did I mention that I
know VERY little about PHP / mySQL. I know NOTHING about ColdFusion or
MSSQL. And to top it off, the site in question contains over 300
Yeah, I'd say it's completely hopeless in a week. PHP is a totally
different language than ColdFusion. SQL and MySQL may be different. The
databases alone, as others have mentioned, could easily be a week even
if you're experienced. Moving BOTH databases and scripting languages
will probably
Hi everyone,
Ok, I need serious help. I have been handed a project by my boss to convert
an existing site that was built using ColdFusion / SQL into a site that will
use PHP / mySQL. The site relies heavily on calls to the database for
everything from site content, to an admin area where you can
Chris Jernigan wrote:
Hi everyone,
Ok, I need serious help. I have been handed a project by my boss to convert
an existing site that was built using ColdFusion / SQL into a site that will
use PHP / mySQL. The site relies heavily on calls to the database for
everything from site content, to an
[snip]
Tell your boss it's an unrealistic goal. Even for a seasoned PHP
programmer with a firm grasp on MySQL, something of this scope is
unrealistic for a single person. Scoping out the db schema alone could
take a week or more (depending on the size of your db). That doesn't
even take
I've used Cold Fusion for years. However one week at 100 hours might not
be enough time to covert everything to PHP and mySQL.
Hi everyone,
Ok, I need serious help. I have been handed a project by my boss to
convert
an existing site that was built using ColdFusion / SQL into a site that
Tell your boss to get a life :)
I'm working on converting a large web application from ColdFusion/MsSQL
to PHP/MySQL. This web app is almost around 3 million lines of code :| I
was wondering if there exists a tool similiar to ASP2PHP to convert
ColdFusion code to PHP. But anyway, the way
Yeah tell your boss to get stuffed and that your not old enough yet to have
a stroke ;)
There is absolutely no way no one knowlegable and experienced in both
languages can do it in a week no less a non programmer either
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Here's what you do. Assume 10-hour work days. Obviously, you want to start
with the schema. That's pretty darn important, so allow yourself a whole day
for that.
You have four days left. Oh wait -- you will probably have to work the weekend
for this one. So you have six days left.
* Thus wrote Chris Jernigan ([EMAIL PROTECTED]):
Hi everyone,
What's the problem? I have one week to do this. Oh, and did I mention that I
know VERY little about PHP / mySQL. I know NOTHING about ColdFusion or
MSSQL. And to top it off, the site in question contains over 300 .cfm files!
Oh my god...I'm crying...
what the heck is a bacon stretcher ?
t
At 03:52 PM 5/28/2004, Travis Low wrote:
Here's what you do. Assume 10-hour work days. Obviously, you want to
start with the schema. That's pretty darn important, so allow yourself a
whole day for that.
You have four days
That's funny Travis !
Here's what you do. Assume 10-hour work days. Obviously, you want to start
with the schema. That's pretty darn important, so allow yourself a whole day
for that.
You have four days left. Oh wait -- you will probably have to work the weekend
for this one. So you
Hi everybody
I want to start a session after a user validation, I
have my variable I want to register : $login
the code to start my session is:
session_name();
session_start();
session_register('login');
session_encode();
$url=Location: mypage.php?PHPSESSID=.$PHPSESSID;
header($url);
?
Title: Message
hey guys
just wanted to know as usual it was user
error
i had thought i had something stored in the
tables
but apparently i did not.
i apologize for
the noobie question.
thanks
special thanks
to jason.
ultimatefootballleague.com/index.php
[EMAIL PROTECTED]
What am i doing wrong with the script below? What i am trying to do is check
whether the newtest field has a 0 or a 1 value then redirect the user to
a different page based on the answer.
I am then trying to add 2 to the value in the points field of my database
and then to set the newtest field
Hi Steven,
On Sunday 12 January 2003 23:58, Steven M wrote:
include 'db.php';
$result = mysql_query(SELECT newtest FROM users WHERE 14 = '$0');
list($number) = mysql_fetch_row($result);
Here you are closing your conenction to the MySQL-Server:
mysql_close();
if($number==0)
But here you
Hi Johannes
Thanks for the help. I have taken out the mysql_close() and it looks like
it is submitting ok (ie no error messages) but it is not updating the
database when i check it. Any ideas?
Thanks.
Steven
Johannes Schlueter [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
To: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP/MySQL help?
Hi Johannes
Thanks for the help. I have taken out the mysql_close() and
it looks like it is submitting ok (ie no error messages) but
it is not updating the database when i check it. Any ideas?
Thanks.
Steven
Johannes
I thought i read somewhere that you could refer to the field by number. Was
i wrong? It doesn't seem to make a difference anyway. It still doesn't
work. Here's the code with words instead of numbers. I'd be grateful if
you could let me know if there are any obvious errors.
Best wishes.
: [PHP] PHP/MySQL help?
I thought i read somewhere that you could refer to the field
by number. Was i wrong? It doesn't seem to make a difference
anyway. It still doesn't work. Here's the code with words
instead of numbers. I'd be grateful if you could let me know
if there are any
Oops...many thanks for that. Sorry, i am extremely new to this.
Best wishes.
Steven M
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
There are a few PHP calendars:
http://www.cascade.org.uk/software/php/calendar/index.php
for example, that you can start from. It should be relatively easy then
to write a small table that contains just one field:
Date (datetime)
All you do is insert a row in the db for each day that is
Hi All
I have been trying to write a database and scripts for a calendar that shows which
days are booked and have failed at each point.
What i would like it to do is to show a calendar which have the dates that are booked
in a cell which are colour coded (say red) when it is unavailable and
Thanks for everyones help yesterday but nI have come up against a problem
(as I am new). I have created my document as detailed below with notes. I
can see from the form that I have connected to the server, accessed the
correct database, created the statment and executed it. The problem is how
to
you need
$query = SELECT COUNT(*) as count FROM bookings WHERE ('2002-04-04')
BETWEEN booking_start AND booking_end OR ('2002-04-10')BETWEEN
booking_start AND booking_end AND villa_id = ('3')
$villa = mysql_query($query);
while ($result = mysqul_result($villa))
{
echo We have $result[count]
Thanks for everyones help yesterday but nI have come up against a problem
(as I am new). I have created my document as detailed below with notes. I
can see from the form that I have connected to the server, accessed the
correct database, created the statment and executed it. The problem is how
to
Hi,
from this command line test:
select imglocation,height,width from img where imgname='alfstag1'
it looks to me like your imgname field is *characters* rather than *numbers*.
when ever I'm doing something like this (eg WHERE firstName=justin), I
do it with a LIKE statement, rather than with
On Wednesday 31 October 2001 02:32 am, you wrote:
So, I'd recommend giving that a try. From my understanding (limited) of
MySQL, use = in the case of $id=2, and LIKE in the case of firstName
LIKE justin.
Um...you *can* do that, but I don't think you want to. Using LIKE means that
MySQL has
.
Thanks to Kurt and Justin for the help offered on this simple (now that it
is working) problem.
I do not know where my stumbling block was but after a good nights rest and
some coffee this morning I have this and the GetImageSize function
incorporated.. I will list the code incase someone
.
Thank you for the heads up on using like. I was wondering since there will
be 2 similar variables from each page var1 var2 (identical except for the
number). I programmed in DataFlex for about 6 years back in the late 80's
early 90's but have not done anything db wise in over 8 years I
On Wednesday 31 October 2001 07:45 am, turtle wrote:
img src=? echo $imglocation ? ? echo $size[3]; ?
Glad we could help. Also, you can re-write the above so you don't have to
define two sets of ?php ? tags by doing the following:
?php
print img src=\$imglocation\ $size[3];
?
Not a big
.
Thank you Kurt,
The day for the server to be move from Cal to Fla is the 31st (today)
I would image that it is somewhere in transit at the present time...
Will send you an email with another address you can respond to...
Thanks for all of your help
Mike
Kurt Lieber [EMAIL PROTECTED]
I am trying to pass a variable to a popup window, to do a search in a
database, and display an image based on the results... Here is what I have
messed up so far (this is the 1st time I have used php/mysql no
userID/Pswd on local host)
The script that passes the variable (variable does
On Tuesday 30 October 2001 10:13 am, turtle wrote:
?
$link = mysql_connect('localhost')or die (Could not connect);
mysql_select_db('img760')or die (Could not select database);
$query = select ('imglocation','height','width') from img where
imgname=$getimg;
$imglocation = 'imglocation';
.
No reading that section of the manual did me no good. I do not understand
other than I cannot store the results as a variable.
Is there any of what I have done that is usable?
A recommendation for a book that covers this would be helpful... the manual
on this area is way to abbreviated for
On Tuesday 30 October 2001 11:58 am, turtle wrote:
No reading that section of the manual did me no good. I do not understand
other than I cannot store the results as a variable.
yes, you can.
Is there any of what I have done that is usable?
yes, there is. see below. It's probably not
.
It is starting to make sense. I see the correlation between the manual
example and the code you show. Surprisingly (and equally confusing) the
book I have also uses a while loop with mysql_fetch_array to display a list.
The getimg variable comes in from the javasript function on the other
On Tuesday 30 October 2001 02:53 pm, you wrote:
It is starting to make sense. I see the correlation between the manual
example and the code you show. Surprisingly (and equally confusing) the
book I have also uses a while loop with mysql_fetch_array to display a
list.
You would use a while
Kurt Lieber
You would use a while loop if/when you have multiple records to retrive.
From your original code example, it seemed as though you would only have
one
record. (though, for safety's sake, you should code a LIMIT into your sql
statement)
Yes I only need one image location with
Hello,
I have a database with 4 Columns
|ID|First|Second|Third|
I am tring to run a query On the First Column and place the data into an
array. The problem that I am running into
Is that there are doubles, triples, and sometimes more of the same name
in that
At 12:31 PM -0600 9/11/01, Jared Mashburn wrote:
I am tring to run a query On the First Column and place the data into an
array. The problem that I am running into
Is that there are doubles, triples, and sometimes more of the same name
in that column. Each name represents something differnet
In mysql database i have 5 tables, their names are :
db
user
host
tables_priv
columns_priv
I know which information are in tables (db,user,tables_priv, columns_priv)
and I know for what serve this tables but i don't know some information
about table host ? Please send me some information about
On Mon, 10 Sep 2001 16:33, Roman wrote:
In mysql database i have 5 tables, their names are :
db
user
host
tables_priv
columns_priv
I know which information are in tables (db,user,tables_priv,
columns_priv) and I know for what serve this tables but i don't know
some information about
Miles,
The LIMIT works great with UPDATE too.
Miles Thompson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Come on, you're pushing SQL in directions it's not supposed to go! It is
set oriented after all.
So it's experimentation time. I've never tried, but
Come on, you're pushing SQL in directions it's not supposed to go! It is
set oriented after all.
So it's experimentation time. I've never tried, but as LIMIT works on a
SELECT, try it on an update. And let us know what happened.
Miles
At 10:30 AM 8/2/01 +0200, elias wrote:
How can I update
of
a pages overhead (one page on a site I hvae currently takes almost 2 seconds
on average to build...eek!)
elias [EMAIL PROTECTED] wrote in message
- Original Message -
From: elias [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 9:31 AM
Subject: [PHP] Mysql Help #2
database normalization? How is the database designed?
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySql help #1
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the
How can I update only N fields from the database?
usually we do:
UPDATE table1 SET field='VALUE' WHERE condition1
now I want to update fields with a certain condition but only X fields out N
total fields.
ie:
id value
--- ---
1a
2b
3c
4d
5e
how can i update such
Hi again.
$result = mysql_query(SELECT id FROM table);
$id_array = array();
while ($r = mysql_fetch_array($result))
$id_array[] = $r[id];
// now $id_array[] is an array of IDs that was grabbed from the database.
Any faster and/or better approache to build the $id_array?
--
PHP General
ID=.$array[$count];
$result = mysql_query ($sqlstring,$db) or die (mysql_error());
}
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 4:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySql help #1
How can I update only N fields from the database
=.$array[$count];
$result = mysql_query ($sqlstring,$db) or die (mysql_error());
}
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 4:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySql help #1
How can I update only N fields from the database?
usual
is the database designed?
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySql help #1
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3 items
Warning: Unable to jump to row 0 on MySQL result index 2 in
/home/sites/site3/web/showthumb on line 71
--here is my code
Change it to look like this:
$connetion = mysql_connect("localhost","cel34243","s2343223") or
die($php_errormsg);
$query = "select images from celeb where
hi
i get this message when i am trying to load some data from mysql.
Warning: Unable to jump to row 0 on MySQL result index 2 in
/home/sites/site3/web/showthumb on line 71
--here is my code
$connetion = mysql_connect("localhost","cel34243","s2343223");
$query = "select images from celeb where
Hi!
Here I am again...I have a problem to insert user name, password and
host into mysql...I'd like to know what commands I need to do that
(since the command to start mysql on my computer) so that way I won't be
able to do anything wrong!
Thank you
Felipe Lopes
MailBR - O e-mail do
62 matches
Mail list logo
