Just so you are aware: TUDBC is not published under any of GNU's
licenses. The website explains the terms and conditions, which are
pretty tight. It does say there are no plans to commercialize TUDBC,
but the terms are not at all comforting on that subject.
I don't recommend building software that
> Evert Lammerts-2 wrote:
>>
>> Your 'taggings' table is basically a link table to deal with a 'many
>> to many' relationship - i guess you know:
>>
>> You have a table A and a table B that have a many-to-many
>> relationship, which is
lution and rather expensive! There can be
another one that I can't think of - i'd love to know it. I think your
best options are to either revise your design, or to consider whether
you really need a query like this - as far as i know they're not used
on flickr etc: these sites show tag
XML handles hierarchical structuring of data, a relational database
system handles relational structuring of data. Imho, usage of any of
these methods depend on the requirements of the system to be built.
That being said, I'm not sure what the real need would be for, like
you say, a database only a
ame) values ($name,
> $notes, $user)";
>$sql->query($qry);
>return $sql->lastInsertID("List");
>
> I'm now getting the following error message: Call to undefined method
> SQL::lastInsertID()
>
> Any further clues?
>
> Yves
>
>
Here are some other options for escaping:
http://pear.php.net/manual/en/package.database.mdb2.intro-quote.php
I think getAfterId will not work - seems to be part of LiveUser Admin.
Interesting stuff, definitely worth a look.
On Mon, Sep 8, 2008 at 7:14 PM, YVES SUCAET <[EMAIL PROTECTED]> wrote:
> * mysql_last_insert_id()
getAfterId()
http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId
> * mysql_real_escape_string()
escape()
http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodescape
--
PHP Da
all of us do, it's subscribed to the list. i filter it out.
On Mon, Sep 8, 2008 at 7:06 PM, Chris Hale <[EMAIL PROTECTED]> wrote:
> Evert Lammerts wrote:
>>
>> My bad! Forgot the dollar signs This should work:
>> function editproduct($item_id, $item_name, $item
Do a print on the query:
>> function editproduct($item_id, $item_name, $item_desc, $item_price,
>> $item_pix, $item_man_id, $item_cat_id) {
>>$item_id = mysql_real_escape_string($item_id);
>>$item_name = mysql_real_escape_string($item_name);
>>$item_desc = mysql_real_escape
quot;") .
"item_man_id='{item_man_id}', item_cat_id='{item_cat_id}' WHERE
item_id={$item_id}";
mysql_query($sql) or die('Insert failed: ' . mysql_error());
}
It looks like you're getting the values for the parameters from a form
- you should h
Little change - the label was not used in the right way:
http://pastebin.com/m2d98e677
On Sun, Sep 7, 2008 at 11:46 PM, Evert Lammerts
<[EMAIL PROTECTED]> wrote:
> I guess this code was not copy pasted from your actual source? It
> would generate mysql errors.
>
> Anyway, I thi
Pastebin is so much nicer when posting code. Find the code i've sent here:
http://pastebin.com/mc5d611a
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I guess this code was not copy pasted from your actual source? It
would generate mysql errors.
Anyway, I think I've an idea of what you want, so here's my two cents :
function edit_cat_radio($item_cat_id) {
connect();
$query = mysql_query("SELECT * FROM cat");
while ($row
Is your table set up in the same way on your webserver? Maybe you
forgot to set the default value to na.gif in your item_pix column. If
not, can you send your table definition?
On Sat, Sep 6, 2008 at 9:02 PM, Chris Hale <[EMAIL PROTECTED]> wrote:
> I have the following function:
>
> function
> add
cel columns and to set
up your table beforehand. Don't forget to replace all necessary parts
in the command above.
If you're not on Windows you should probably use \n instead of \r\n
for the newline character.
On Fri, Sep 5, 2008 at 1:12 PM, Nasreen Laghari
<[EMAIL PROTECTED]>
> 1) having separate databases for each blog = fast
> (problem: what if I will need to do search in all of the blogs for some
> article?)
>
> 2) having all blogs in one database - that might be 10 000 * 100 articles =
> too many rows, but easy to search and maintain, hmm?
The answers on your quest
nt,
>>
>>David DURIEUX
>>Tel : 04.74.04.81.34
>>Port : 06.34.99.45.18
>>Mail : [EMAIL PROTECTED]
>>Site Web : http://www.siprossii.com/
>>
>>SIPROSSII
>>847 route de Frans (Créacité)
>>69400 Villefranche sur Saône
>>
>>
>
>switch($_GET[page])
> {
> connect();
> case "about" :
Put the connect() before the switch (and keep error_reporting(E_ALL)
at the top):
connect();
switch($_GET[page])
{
case "about" :
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www
Add the line:
error_reporting(E_ALL);
at the top of your functions page
On Wed, Sep 3, 2008 at 9:29 PM, Chris Hale <[EMAIL PROTECTED]> wrote:
> I have a functions page:
> function connect()
> {
> include("includes/Vars.php");
> mysql_connect($host, $user, $passwd) or die("Couldn't connect to
> Your SELECT has a terminating semicolon.
I'm guessing Multiple statement execution is enabled by default...
http://dev.mysql.com/doc/refman/5.0/en/mysql-query.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
; Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : [EMAIL PROTECTED]
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 20:51:49 +0200
> "Evert Lammerts" <
lefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 20:43:25 +0200
> "Evert Lammerts" <[EMAIL PROTECTED]> a écrit:
>
>>Are you still using the code we talked about?
>>
>>if ($row = mysql_fetch_assoc($query)) {
>> var_dump ($row);
>>
vid DURIEUX
> Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : [EMAIL PROTECTED]
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 20:05:22 +0200
> "Evert Lammerts
On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts <[EMAIL PROTECTED]> wrote:
> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy <[EMAIL PROTECTED]> wrote:
>> When using mysql_query, the SQL string to be executed should not end
>> in a semicolon.
>
> Ending a query with a
On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy <[EMAIL PROTECTED]> wrote:
> When using mysql_query, the SQL string to be executed should not end
> in a semicolon.
Ending a query with a semicolon should not be a problem - the string
is parsed by the mysql server, which handles it fine.
--
PHP Database M
> Humm with this query I have forgotten to tell you the ID is DELETED
You mean the record with id=134?
> Are you sur it is 3 ? it is 134 no?
You're right :-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> string(3) "134" int(0)
This means you're trying to delete the entry with id=3, and that it
cannot find that in the database. Are you sure it exists? We tried the
queries separately and the SELECT had no problem... SELECT * FROM
table WHERE id=3;
--
PHP Database Mailing List (http://www.php.net
> I have :
>
> array(2) { ["module"]=> string(12) "sousdomaines" ["deleteid"]=>
> string(3) "134" }
>
> But the ID is not deleted in mysql.
That seems to be your var_dump($_GET), which means that either if
(isset($_GET['deleteid'])) evaluates to FALSE or your SELECT does not
return results. Let's
> Cordialement,
>
> David DURIEUX
> Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : [EMAIL PROTECTED]
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 12:54:19 +02
gt;
> David DURIEUX
> Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : [EMAIL PROTECTED]
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 12:39:45 +0200
> "E
0001/Web_data/hebergement/pages/sousdomaines.php
>>> on line 7 string(0) "" NULL
>>>
>>> Warning: Wrong parameter count for mysql_num_rows()
>>> in /usr/home/sites/CL01/Web_data/hebergement/pages/sousdomaines.php
>>> on line 12 string(0) &qu
nt for mysql_num_rows()
> in /usr/home/sites/CL01/Web_data/hebergement/pages/sousdomaines.php
> on line 16 string(0) "" NULL
>
>
>
> Le Wed, 3 Sep 2008 12:11:00 +0200
> "Evert Lammerts" <[EMAIL PROTECTED]> a écrit:
>
>>> In fact the firs
> In fact the first return 0 results
So the problem is in your select, and if your select works when you
manually insert the value for id (iow, without using $var), the
problem has something to do with $var.
Is the data type of the ID column INT? Try the following and let us
know the output:
$va
> string(40) "SELECT * FROM table WHERE id=107 "
> string(3) "107"
And this query works when you run it on the database directly? Id 107 exists?
Assuming that that's both so we're running out of options.
After the select, can you do a print of mysql_error() and of mysql_num_rows()?
--
PHP Data
>>If that doesn't work then var_dump($sql, $var) and write us the
>>result. Also let us know the data type of the ID column.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
p://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 11:13:11 +0200
> "Evert Lammerts" <[EMAIL PROTECTED]> a écrit:
>
>>> $sql = 'SELECT * FROM table WHERE i
> $sql = 'SELECT * FROM table WHERE id="'.$var.'" ';
> $req = mysql_query($sql) or die('Erreur SQL
> !'.$sql.''.mysql_error());
> while($data = mysql_fetch_assoc($req)) {
> echo $data['id'];
> }
> $sql2 = 'DELETE FROM table WHERE id="'.$var.'" ';
> $req2 = mysql_query($sql2) or die('Erreur SQL
> !
apache
> being unable to start at all.
>
> Than I remembered that on this particular machine we were running as a
> different user and not local system. When I changed that it worked ok
>
> I really need to understand more about windows I guess
>
> Jack
>
> -Ori
No interesting entries in the logs?
On Mon, Sep 1, 2008 at 2:27 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote:
> I have the phpinidir directive set in apache so it loads the exact same
> php.ini as the cli
>
> Jack
>
> 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]>
&g
ical.
>
> Oracle 10.2.0.4 client
> apache 2.2
> php 5.2.6
>
> Thanks
>
>
> On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote:
>>
>> Can you send your and the output of phpinfo when run from the command
>> line and when run from the brows
Can you send your and the output of phpinfo when run from the command
line and when run from the browser?
On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote:
> Hi List,
>
>
> I have installed Oracle, PHP and apache on my windows machine and have the
> following issue
>
> If I
$loopsize = mysql_num_rows();
$anagram = "";
for ($i = 0; $i < $loopsize; $i++) {
$cell = mysql_result($anagram_result, $i, "anagram");
$anagram .= "" . $cell{0} . "" . substr($cell, 1) . "\n";
}
On Mon, Sep 1, 2008 at 2:09 AM, Ron Piggott <[EMAIL PROTECTED]> wrote:
> I have the following save
I'm pretty sure I found the problem - I should've spotted it earlier.
The function ProfileList::render gets a reference to the $db object by
its parameter &$db. While you loop over your results, you pass the
reference on to $this->des->load. I'm guessing that the definition of
$this->des->load is
ut. Anybody
can drop your database, so do fix it!
On 8/31/08, Gav <[EMAIL PROTECTED]> wrote:
> On Sun, Aug 31, 2008 at 9:27 PM, Evert Lammerts
> <[EMAIL PROTECTED]>wrote:
>
>> You don't need to print the query anymore - I already did that. You
>> nee
on the database and see what the result is?
Also check if you get an error after setting error_reporting to E_ALL.
On Sun, Aug 31, 2008 at 1:16 PM, Evert Lammerts
<[EMAIL PROTECTED]> wrote:
> The code you've sent seems to be fine, and if I check your website it
> does everything it
st need to set error_reporting to
E_ALL in php.ini and restart your webserver, or add the line
error_reporting(E_ALL); at the beginning of you code. After that you
need to print the query from ProfileList::render. Can you adjust the
function and add var_dump($q); after the line $q = $q." LIMIT $sta
count; or var_dump($count); in the
ProfileList::render() function.
Make sure to always include the list in your replies. This way people
can reuse solutions from the archives.
Evert
On Sun, Aug 31, 2008 at 11:21 AM, Gav <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I moved a site acros
> $list->render( $db, $start, COUNT );
Send the code of this function and tell me the value of COUNT.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
In the SQL standard this would be
AND NOT ministry_directory.listing_approved=0 AND NOT
ministry_directory.listing_approved=4
MySQL supports (and there are probably more RDBs that do):
AND ministry_directory.listing_approved!=0 AND
ministry_directory.listing_approved!=4
On Fri, Aug 29, 2008 at
> Putting commands into input containers in HTML is deprecated in the
> XHTML specification. You should use this instead in the input:
Only if your doctype is XHTML, in which case you should also close
every tag, including the input tag. If your doctype is HTML your code
is fine. I use the HTML v
Everybody seems to agree on escaping :-) And I'm learning! HEREDOC,
nifty indeed!
How about your $_POST variable, is there anything in there?
On Wed, Aug 27, 2008 at 6:38 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> On Aug 27, 2008, at 12:24 PM, Evert Lammerts wrote:
>
>
Your index.php looks very strange:
>
>
>
>
>
> ?>
I'm guessing you're echoing this? I never echo from my scripts so I
don't know if this is new functionality, but in my days you echoed
either by or by .
Anyway, since you're using the $_POST variable, did you check if it
contains any val
Forget my last mail. Good to hear it's solved.
On Wed, Aug 20, 2008 at 1:20 PM, Evert Lammerts
<[EMAIL PROTECTED]> wrote:
> Can you post the code you're using when you get the timeout?
>
> I guess you already tried to do a select only and an update only to
> check if
lic_html/willowtreecrafts/seweblink/seinvaudit.php on lin
> which was a permissions error on the folder,
> now i'm timing out and getting nothing,
> Sorry to have such a basic problem!
> On 20 Aug 2008, at 11:45, Evert Lammerts wrote:
>
> What happens if you try the UPDATE
vaudit.php on lin
> Sorry to have such a basic problem!
> On 20 Aug 2008, at 11:45, Evert Lammerts wrote:
>
> What happens if you try the UPDATE before a SELECT?
>
> $sesdb = new PDO('sqlite:file.sqlite3');
> var_dump($sesdb->exec("UPDATE ZITEM SET ZQUANTIT
SET ZQUANTITY=0 WHERE ZPRODUCTID=bli-343";
> var_dump($sesdb->exec("UPDATE ZITEM SET ZQUANTITY=0 WHERE
> ZPRODUCTID=bli-343"));
> $sesdb->exec($sql);
> var_dump($sesdb->exec("UPDATE ZITEM SET ZQUANTITY=0 WHERE
> ZPRODUCTID=bli-343"));
> $query=
What happens if you try the UPDATE before a SELECT?
$sesdb = new PDO('sqlite:file.sqlite3');
var_dump($sesdb->exec("UPDATE ZITEM SET ZQUANTITY=0 WHERE ZPRODUCTID=1"));
On Wed, Aug 20, 2008 at 12:42 PM, Evert Lammerts
<[EMAIL PROTECTED]> wrote:
> Sorry, I'm
ZPRODUCTID={$prodid}";
> $sesdb->exec($sql);
>
> On 20 Aug 2008, at 11:10, Evert Lammerts wrote:
>
> A little time on google told me that if you want to do a write after a
> read (or the other way around) you need to free up the query resource
> - apparent
sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID={$prodid}";
>
> $sesdb->exec($sql);
>
> }
>
> On 20 Aug 2008, at 09:59, Evert Lammerts wrote:
>
>>> $sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID='".$prodi
> $sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID='".$prodid."'";
Try to unquote $prodid:
$sql = "UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID={$prodid}";
Evert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
You can set a save handler for the session and save the session to the
database (http://php.net/session_set_save_handler). But it will be
hard for server 2 to find out which data belongs to a user that just
came from server 1 - you can't rely on a session id found in the url
or in a cookie since...
Check http://php.net/manual/en/language.types.float.php
Quote:
Warning
Floating point precision
It is typical that simple decimal fractions like 0.1 or 0.7 cannot be
converted into their internal binary counterparts without a small loss
of precision. This can lead to confusing results: for examp
SHOW COLUMNS FROM tablename;
Also check http://dev.mysql.com/doc/refman/5.0/en/
On Wed, Aug 13, 2008 at 3:02 PM, Simcha <[EMAIL PROTECTED]> wrote:
> You can try 'select `testcol` from `table`' and then check if you got a
> mysql_error().
>
>
>
> -Original Message-
> From: Robin Vickery [m
JSON does the trick for you (www.json.org), and PHP's glob() gets rid
of your readdir() overhead (you'll need PHP 5.2 or later for this):
$path = "/path/to/images/";
$images = glob($path . "{*.jpg,*.gif,*.png}", GLOB_BRACE);
for ($i = 0; $i < sizeof($images); $i++)
$images[$i] = array($images[
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html should get you
started. Good luck!
On Tue, Aug 12, 2008 at 8:27 AM, Manoj Singh <[EMAIL PROTECTED]> wrote:
> Hello all,
> I am getting this error when connecting to the database through
> mysql_connect function.
>
> Error: mysql_connect() [ hre
> Why use extract()? Try commenting it out... apart from it being
If you use 'register globals' there's a good chance that a variable
$rights exists because it's a key in your $_SESSION array (don't shoot
me if I'm wrong, I've never worked with 'register globals'). By using
extract() without the $
If it changes the value of $_SESSION['rights'], then how come
if ($_SESSION['rights'] != "super")
on line 14 doesn't exit()? Or does that happen when you hit refresh
the second time? Or does the user it changes to also have 'super'
rights?
Why use extract()? Try commenting it out... apart from it
C) or mysql_fecth_assoc($result).
Evert
On Mon, Jul 14, 2008 at 8:21 AM, Ron Piggott <[EMAIL PROTECTED]> wrote:
> I am using json_encode to output the results of a mySQL query which is
> part of a jquery & ajax.
>
> $result = json_encode($array);
> echo $result;
>
> The output
Check out your system's logs / event viewer. If apache crashes (how do
you notice?) there should be some indication of the reason.
Evert
On Thu, Jul 10, 2008 at 2:24 AM, Chris <[EMAIL PROTECTED]> wrote:
> Bonger O wrote:
>> Hi,
>>
>> I have set up an environment
ny to many relationship exists, a
link table is the solution, with or without foreign keys. I don't know
what the overhead of using foreign keys is, but that's something you
can test. ON UPDATE and ON DELETE do make things a lot easier.
Evert
On Fri, Jun 20, 2008 at 2:41 PM, J. Hi
It is wise to use foreign keys when using linktables - but you can
only do this when using INNODB. Check
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
Evert
On Fri, Jun 20, 2008 at 8:38 AM, Hussein Jafferjee
<[EMAIL PROTECTED]> wrote:
> Hey Guys,
>
>
>
>
I should've checked the assumption.
A little strange though for a scripting language. I'd say, since
default behaviour of mysql_* functions is to assume the last opened
link when a parameter is not passed, and since default behaviour is to
evaluate null, false and 0 the same, mysql_* functions sho
o surpress the warnings:
[new code]
if (!mysql_connect($a, $b, $c)) return;
$link = null;
if (!mysql_select_db($dbname)) return;
$res = mysql_query("SELECT * FROM manual;", $link);
[/new code]
Evert
On Thu, Jun 19, 2008 at 9:12 AM, Isaak Malik <[EMAIL PROTECTED]> wrote:
>
Pastebin works lots better when you're posting code: www.pastebin.com
I don't see your database.php included in both of these modules. Where
do you include it?
EVert
On Wed, Jun 18, 2008 at 9:38 PM, bateivan <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> To answer thes
I've forwarded this msg to the php-db list (php-db@lists.php.net). Try
to subscribe to it.
The mysql extension for php is only an interface between php and mysql -
the parsing of queries is done within mysql itself. So if your query
works through CLI it will also work from within php. Try to v
that in this case, $sub will always only hold the value of the
last result - or of the only result if there is only one result row.
Nasreen Laghari wrote:
Hi Evert,
What to you mean by this "If I were you I'd go for one of them and
apply this to all."
also to get the value
vid. If I were you I'd go for one of them and apply this to all.
Evert
Nasreen Laghari wrote:
Hi,
I have a table which contains 2 foreign key relation columns. I'm trying to get all columns from main table as well as all column from those 2 foreign key relation tables.
Th
Freedom
All I want to do is to know who bring who?
On Sat, Apr 12, 2008 at 4:41 PM, Evert Lammerts
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
Something like this should work.
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
Something like this should work.
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$tomorrow = mktime(0, 0, 0, date("m"), date("d") + 1, date("Y"));
$sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$today} AND
{$tomorrow}";
$thismonth = mktime(0, 0, 0, date("m"), 1, date("Y")
Richard Dunne wrote:
In my code below, I am trying to verify that the query is selecting data from both rows of my answers table. I have run the query on my MySQL CLI and getting answers from both rows, but running this script I get $rows = 0. I can't figure out why its not returning 2 for the n
The semi-colon is gone, although I didn't even notice it! I am using two
different queries, one for count and the other to access the data itself.
After running mysql_fetch_assoc, is foreach ok for accessing array members, or
is there a more subtle approach?
So it's working now? If it is, yo
Tried that as well and got the same result.
I tried "Select count(answer) as total from answers where studentID='A123456789'";
from the CLI and got total = 2 as a result.
So, we got rid of the Invalid Resource error and we know that the
student id you use occurs in both rows in your tabl
OK. Tried that and count comes back as 1.
So your query returns only one record. Try
$query ="Select answer from answers";
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
This is my code. The only error is at line 15 as I stated above.
1
Turn line 13 into
$result = mysql_query($query) or die(mysql_error());
, so leave out the connection parameter and append the die() function,
and see what error that produces.
--
PHP Database Mailing List (http://www.
PHP is telling me that the resource I am using for mysql_fetch_assoc is invalid:
$query ="Select answer from answers where studentID ='A123456789'";
$result = mysql_query($query,$connection);
$count=0;
while($row = mysql_fetch_assoc($result));
{
$count++;
}
echo $count;
Are you sure your d
'A123456789';");
$row = mysql_fetch_assoc($result);
$count = $row['||nr_of_results||'];||
|
Evert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Correction:
Also, this condition:
[quote]
if (!isset($_POST['txtLoginName']) || empty($_POST['txtLoginName']))
[/quote]
is true if and only if no form element by the name txtLoginName
existed on the previous page - and on top of that, empty() does the
same as isset() and apart from that als
uot;, NULL or FALSE) that evaluates to FALSE.
I don't understand why you'd want to fill the username with a tab
either: "\t".
Maybe you can post your full code?
Evert
Daniel Brown wrote:
On Tue, Mar 25, 2008 at 1:14 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
the act
_name()
(http://usphp.com/manual/en/function.oci-bind-array-by-name.php).
In general, and I bet you do, keep the oci8 function overview close
(http://usphp.com/manual/en/ref.oci8.php).
Evert
Hebat-Allah Farag wrote:
Dear all ,
I am stick since 2 days at the same point, I am using 10g, PHP my pr
VanBuskirk, Patricia wrote:
I have a "customer description" text area field on my form which feeds through
php to FMP,
What's FMP? Is that what links this email to the db-list?
and spits out a confirmation page and email. The issue I am having is this ... as
the customer types, the text wra
ure what Charly means by this though...
Evert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
A quick google shows I'm not the first to ask this question... Lets take
the address of the list? (I cc'ed owner)
OWNER: Please take [EMAIL PROTECTED] from the php-db list. It's a
google group email address that doesn't accept anonymous emails (if I've
decrypted the indonesian well) and automa
intaining compatibility with it, and then I'm still not sure what it
does), if you want to have all rows in tour regardless of the join condition with
NULL values for angler_results.result where tour.record_id is not in
angler_results.tour_id. To leave out the NULL values use an INNER JOIN
lts.result where tour.record_id is not in
angler_results.tour_id. To leave out the NULL values use an INNER JOIN instead.
Evert
Bastien Koert wrote:
Hi All,
Got myself stuck in a little sql here and can't seem to work out what I am doing wrong
SELECT
DISTINCT (tour.record_id), tour.event_start_d
SOAP stands for Simple Object Access Protocol and is, as its name
implies, a protocol for accessing objects or in other words, a standard
that defines how a possibly remote object can be communicated with.
XML-RPC, with RPC standing for Remote Procedure Call, is a protocol to
call remote proced
Hi Ben,
Number of things wrong with your code, look below.
$select_sql = sprintf("SELECT `username` FROM `users` WHERE `username` =
'$user' AND `password` = '$pass'", mysql_real_escape_string($user),
mysql_real_escape_string($pass));
In the string you are printing using sprintf you need to u
You can use regular expressions in mysql to check for the right format,
but (as far as i know) you can not return any matches: SELECT * FROM
table WHERE column REGEX '[0-9]+';, which returns all records where
column has a digit in its value.
In PHP however, you can easily get the matches:
$var
p/15-Using%20ODBC.html).
If your database is only interfaced by a website I'd recommend using a
database system that is supported by PHP (MySQL would be a good option).
There might of course be other options out there that I'm not aware of.
Good luck,
Evert
-Original Message--
one
to have problems with processing big amounts of data in tree structures. Do
you guys have any suggestions?
Thanks,
Evert Lammerts
Would you happen to have a nice little example-script for me/us? :-)
Regards,
Evert
Niel Archer wrote:
> Hi
>
>> Easiest way would be to have MySQL to do it, using an INSERT ... SELECT
>> statement
>
> ... and if you're moving (not just copying) deleting th
1 - 100 of 107 matches
Mail list logo
