id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
Adam
On Sat, 7 Sep 2002, Bryan McLemore wrote:
> Hi Guys I have written this SQL Query :
>
> CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address
>VARCHAR(50), startDate DATE, lastWork DATE, progress
Hi Guys I have written this SQL Query :
CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address
VARCHAR(50), startDate DATE, lastWork DATE, progress INT(3))
I'm sending it in through php and I can't get it to work correctly. Please help.
Also, I would like to make id
I need help getting a specific table structer.
Does any one have any code snips that I can follow on this I want to get the
structer of a table and display it on the screen.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello again
Well I followed Jim recomendation but it didn't work either, I think I'd
better send the full code to you (don't worry is very short), so you can have
a broader idea of what I'm intending to do, which is actually quite a simple
thing, just to retrieve results from a database accord
well... honestly i don't know how to write PHP scripts that will do this,
but...
maybe i can point you in the right direction...
sounds like what you're talking about is Data Mining, especially data mining
that incorperates the use of some type of web spidering ability. One product
that we use a
1:
http://quanta.sourceforge.net/
2:
yes
Adam
On Fri, 6 Sep 2002, Bryan McLemore wrote:
> First off, What html/php editor do you guys think is better?
>
> Secondly, perhaps a little more relevant to the database part of this. I just want
>to clarify that with mysql_q
Your problem seems to stem from the $content .= $row; $row is an Array and
you must use an index to get at any given value it holds. If you need all of
the values in $row, use the count() function to get the number of elements
(columns in this case), then loop through them adding them to $content
1). vi (The best editor for any language, IMHO)
2). Yes
Bryan McLemore wrote:
> First off, What html/php editor do you guys think is better?
>
> Secondly, perhaps a little more relevant to the database part of this. I just want
>to clarify that with mysql_query() I can send any valid sql expre
First off, What html/php editor do you guys think is better?
Secondly, perhaps a little more relevant to the database part of this. I just want to
clarify that with mysql_query() I can send any valid sql expression and it will do
that?
-Bryan
Hello guys
Thanks to all those you helped me with y the question I made before (not a
valid MySQL result) it's working now.
Now, I want to display the result of my search with the following code:
if($code){
$query_cat = "select author.author_names || ' '|| author.aut
Oops, you have one more error that I see, one one line you reference
author-cat as a table name and on another you refer to it as author_cat.
Make the appropriate change and try it again. One of the table references is
wrong and will generate a missing table error.
Jim
---Original Messag
Change your query to be:
$query_cat = "select concat(author_names, ' ', author_surnames) as
somenewcolname from author, author-cat
where author_cat.cat_code = $code
and author.author_code = author-cat.author_code";
Change somenewcolname to whatever you want the column to be called or lea
Hi guys
Thanks for your help. Peter was right I had an error in the sentence, I
worked it out but still the same error came up. The mysql_error() function
doesn't return any thing.
Any idea?
Thanks a lot.
>Hi
>Couple of points, you probably have an SQL error,
>I use
>echo $query;
>echo
Dear All
I have recently downloaded a calendar from CST (which is no longer
supported ) and I have made a few changes to the script.
The calendar will be used to see when something is booked and you can assign
messages to it as well which the general user cannot see. In this respects I
have crea
You would probably need some API plugins to search other websites.
I've seen some people open socket connections, open the site and read the raw
HTML from the socket into a buffer and then parse out the information that way.
I don't know if PHP was really developed for such a purpose? Maybe
Hi
Couple of points, you probably have an SQL error,
I use
echo $query;
echo ''.mysql_error();
which shows the query and the error
you use 'author-cat' in the table name
and 'author_cat' and 'author-cat' in the where clause which will throw an
error.
HTH
Peter
---
Hi,
I'm wondering how can I write some php script to scan a couple of(or more)
websites to find out the lowest price of a particular item? what is the idea
behind this kind of programing?
Also, I am always wondering how does the pricewatch website works? (I don't
think that they did page by page
Hello,
It's always good practice to put some error detection in your code, i.e.
$result = mysql_query($query)
or die(mysql_error());
I think your problem is the mysql does not like your query, but you are not
catching it until PHP tries to figure out the number of rows returned by the
query.
Hello guys
This is my first posting to the list, even though I've had some experience
with C++, these are my first steps with php and mysql.
Well, the thing is that I'm getting the following message:
Warning: Supplied argument is not a valid MySQL result resource
in /var/www/bva/new/main/cole
Read this: (Does a good job explaining uploads)
http://www.php.net/manual/en/features.file-upload.php
How I personally handle images in mysql, is not put the image in the database
(Does it even allow this??) But just put the relative, or complete PATH to the
image. So, your database would stor
>
> my improvement is:
> ===
> $counter = 1;
> echo ""; //start of table
> for ($i=0;$i<$num_rows; $i++) //loop through the number of records
> {
> $row = mysql_fetch_array($result); //Get associate row
> echo "$row[0]"; //Print out the NAME
> if($counter =(! $counte
Hi,
I know this should be simple but being a beginner...
How do you insert an image into a mysql table and also how can you upload an image to
a mysql table via a form.
Thanks in advance.
Neil
http://www.mysql.com/information/benchmarks.html
Gurhan
On Fri, 2002-09-06 at 04:26, :B nerdy wrote:
> anyone know anything about oracle & php at all? =D
>
>
> ":B Nerdy" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > ive been using mysql my whole php l
"Markbm" <[EMAIL PROTECTED]> ha scritto nel messaggio
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> It doesn't bring back any HTML when I view the source:
>
>
>
>
>
>
>
>
>
> I tried the addslashes and stripslashes but I
Escuder Nicolas wrote:
> Hello,
>
> i use php as not a cgi it is include in my apache
> my odbc is a custom odbc driver
>
>
> so i try to use odbc_pconnect, the first time it connect to the db i saw the
>connection tcp by netstat
> and the next time (on the next page) i reuse pconnect with the
anyone know anything about oracle & php at all? =D
":B Nerdy" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> ive been using mysql my whole php life. i recently got oracle trial db.
>
> how does it weigh against mysql? is there a website really benchmarks them
26 matches
Mail list logo