I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Hmmm har lige prøvet.... Kommer med dette: --------------------------------------------------------------- Warning: Supplied argument is not a valid MySQL result resource in /usr/local/www/vipzdk/www/Projekt/admin_vote_delt.php on line 13 --------------------------------------------------------------- Hvorfor det da? :-) Min linje ser således ud: --------------------------------------------------------------- $result = mysql_query("SELECT * FROM projekt_vote2 ORDER BY RAND() LIMIT 0,1"); ---------------------------------------------------------------
Den melder samme fejl...? I får lige hele min kode: ---------------------------------------------------------------------- <?php include("header.php"); ?>
<?php if($udf == "Gem"){
$conn = mysql_connect("xxxxx", "xxxxx", "xxxxx");
mysql_select_db("xxxxxxx");
$result = mysql_query("select * from projekt_vote2 ORDER BY RAND() LIMIT 0,1") or die( mySql_error());
sthen: Der skal være "" i [] - ellers gætter PHP bare på... at du har glemt at skrive ""... Hvis der vel at mærke ikke tilfældigvis er en konstant der hedder det samme som det navn du har angivet - så fungerer det bare ikke...
RAND(N) Returns a random floating-point value in the range 0 to 1.0. If an integer argument N is specified, it is used as the seed value: mysql> SELECT RAND(); -> 0.9233482386203 mysql> SELECT RAND(20); -> 0.15888261251047 mysql> SELECT RAND(20); -> 0.15888261251047 mysql> SELECT RAND(); -> 0.63553050033332 mysql> SELECT RAND(); -> 0.70100469486881
You can't use a column with RAND() values in an ORDER BY clause, because ORDER BY would evaluate the column multiple times. In MySQL Version 3.23, you can, however, do: SELECT * FROM table_name ORDER BY RAND() This is useful to get a random sample of a set SELECT * FROM table1,table2 WHERE a=b AND c<d ORDER BY RAND() LIMIT 1000. Note that a RAND() in a WHERE clause will be re-evaluated every time the WHERE is executed. RAND() is not meant to be a perfect random generator, but instead a fast way to generate ad hoc random numbers that will be portable between platforms for the same MySQL version.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.