___
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
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 Ophth
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
*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
$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
Consultant
$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
ItemNameTest . '\'
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 <t...@clothears.org.uk> wrote:
> On 21 Jul 2017 at 07:33, Edmondo Bora
Cheers
Edmondo
On Fri, 21 Jul 2017 at 12:24, Clemens Ladisch <clem...@ladisch.de> 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 yo
0:45, <no...@null.net> wrote:
> On Fri Jul 21, 2017 at 06:33:55AM +, Edmondo Borasio wrote:
> > I am updating a record of a SQLite database as follows:
> >
> > $db->exec('UPDATE Movies SET name = "new movie" WHERE ID="4"');
> >
11 matches
Mail list logo