___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ys it started giving me a blank screen and freezing when
it was idle. I have updated Mac OS and VB but nothing.
No valid rapl domain found in package 0.
Failed to start journal service
Do you have any idea by any chance of what it could be?
Cheers
Edmondo
--
Dr Edmondo Borasio, MedC BQ
Hi Simon,
Yes, you are correct. The program should get me to the previous one which
is 2 or the next one which is 6.
It know it because I have previously manually selected that particular one.
Regards,
Edmondo
___
sqlite-users mailing list
sqlite-users
*progr_no* *ID*
1 grace
*2* *john*
3 alan
4 tim
*5* *john*
*6* *john*
7 sandra
*8* *john*
What is the simplest and most efficient way of telling SQLITE to select the
NEXT or the PREVIOUS *progr_no *for a given recurring ID, let's say "john"?
Let's assume that I currently I am at progr_no=5.
I wa
$ID;
echo $ID; //This returns: *string(1) "5"*
$NewID = $ID + 1;
echo $NewID; //This returns: *6*
//If I input the $NewID manually as a string (for example '6', *it works
fine* and updates the db correctly)
*$query1="INSERT INTO
Table"."(ID,name,surname)"."VALUES('6','newName','newSurname');"; *
Bingo! Many thanks!
Hey, do you know where I can find good instructions on how to use SQLITE in
PHP?
I have searched a lot but haven't found much more than isolated questions
from different users on some forum...
Regards
Edmondo
Dr Edmondo Borasio, MedC BQ Ophth, FEBO
Consu
$results = $db->query("SELECT MAX(ID) FROM Table")->fetchArray();
$Highest_ID = $results['ID'];
var_dump($Highest_ID);
I get NULL
Cheers
Ed
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.or
ATE Anagrafica SET name = \'' . $DbItemNameTest . '\'
WHERE hospital_ID=' . $hIdTest); //IT DOESN'T WORK
The second one doesn't work even if I change hIdTest to integer.
$hIdTest = 1;
Any suggestions pls?
Cheers
On 21 July 2017 at 12:35, Tim Streater wrote
();
Cheers
Edmondo
On Fri, 21 Jul 2017 at 12:24, Clemens Ladisch wrote:
> Edmondo Borasio wrote:
> > $stmt->bind_param($p_name,$bind_value);
>
> This looks like PHP's MySQL driver. Which DB are you actually using?
>
> Anyway, I recommend you start with the examp
;
$stmt = $conn->prepare('UPDATE Anagrafica SET name=? WHERE hID=?');
$stmt->bind_param($p_name,$bind_value);
$stmt->exec();
To make things more complex, once this is working, then I would also need
to take the parameter "name" of "SET name" from a variab
. Neither using escape
characters like \"$DbItemName\" and \"$hId\".
Any idea of the right syntax pls?
--
Dr Edmondo Borasio, MedC BQ Ophth, FEBO
Consultant Ophthalmologist
Specialised in Cornea, Cataract & Laser Refractive Surgery
Head of Corneal and
12 matches
Mail list logo
